SQL for Data Analysis

Compilation of SQL related projects, notes and challenges by using PostgreSQL.

PostgreSQL Tools : pgAdmin4

Challenges

challenges are from Udacity course "SQL for Data Analysis" by MODE.

CSV Data : raw data for Parch&Posey company db in csv format.

Schema Dump: schema only dump.

1. Basic SQL
2. SQL Join
3. SQL Aggregations
4. Sub Queries & Temporary Tables
5. SQL Data Cleansing
6. [Advanced]SQL Window Functions
7. [Advanced]SQL Advanced Joins & Performance Tuning