SQL for Data Analysis



Lesson 1: SQL Basics

  • Select, from, where
  • Logical operators

Lesson 2: SQL Joins

  • Inner join
  • Left join

Lesson 3: SQL Aggregations

  • Aggregations with count, sum, min, max
  • Case and date functions, and null values

Lesson 4: Subqueries and Temp Tables

  • Write subqueries to run multiple queries
  • Temp tables

Lesson 5: SQL Data Cleaning

  • Data cleaning with SQL

Lesson 6: Window Functions

  • Window functions for data analysis tasks