/SQL-for-Data-Analysis-Parch-and-Posey

SQL for Data Analysis using PostgresSQL - analyzing Parch&Posey fictional company

Primary LanguageTSQL

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

P&P