Compilation of SQL related projects, notes and challenges by using PostgreSQL.
PostgreSQL Tools : pgAdmin4
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.
- Basic SQL
- SQL Join
- SQL Aggregations
- Sub Queries & Temporary Tables
- SQL Data Cleansing
- [Advanced]SQL Window Functions
- [Advanced]SQL Advanced Joins & Performance Tuning