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.

Name		Name	Last commit message	Last commit date
Latest commit History 14 Commits
CSV Data		CSV Data
Schema Dump		Schema Dump
01.Basic SQL.sql		01.Basic SQL.sql
02.SQL Join.sql		02.SQL Join.sql
03.SQL Aggregrations.sql		03.SQL Aggregrations.sql
04.Sub Queries & Temporary Tables.sql		04.Sub Queries & Temporary Tables.sql
05.SQL Data Cleaning.sql		05.SQL Data Cleaning.sql
06.[Advanced]SQL Window Functions.sql		06.[Advanced]SQL Window Functions.sql
07.[Advanced]SQL Advanced JOINS.sql		07.[Advanced]SQL Advanced JOINS.sql
The Parch & Posey Database ERD.png		The Parch & Posey Database ERD.png
readme.md		readme.md