Basic SQL Commands, Sorting with SQL and Grouping Data with SQL

  1. Writing SQL Statements, SQL Commands, and Retrieving Data:
    • You’ll learn how to write SQL statements and commands to query and retrieve data from a database. Common commands include SELECT, INSERT, UPDATE, and DELETE.
  2. Sorting with SQL:
    • Sorting involves arranging query results in a specific order, such as ascending or descending. The SQL ORDER BY clause is used for this purpose.
  3. Grouping Data with SQL:
    • SQL GROUP BY is used to group rows that have the same values in specified columns. It’s often used with aggregate functions like SUM, COUNT, AVG, etc., to summarize data.
Back to Lesson