SQL-COURSES

SQL courses from DataCamp, data engineering career track

Introduction to SQL file:

• Best practices introduction
• Order of Execution
  1. FROM
  2. WHERE
  3. GROUP BY
  4. HAVING
  5. SELECT and AS
  6. ORDER BY
  7. LIMIT
• SQL formatting best practices
• Filtering data
  1. Filtering individual records with WHERE
  2. Filtering grouped records with HAVING
• Managing null values
• Aliasing and arithmetics
• Summarizing data
  1. AVG()
  2. SUM()
  3. MIN()
  4. MAX()
  5. COUNT()