SQL for Data Analysis

https://www.udacity.com/course/sql-for-data-analysis--ud198

https://www.udacity.com/

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