SQL for Data Analysis using PostgresSQL - analyzing Parch&Posey fictional company
Last updated May 6, 2026
20
Stars
10
Forks
0
Issues
0
Stars/day
Attention Score
12
Topics
Language breakdown
TSQL 100.0%
▸ Files
click to expand
README
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.
- Basic SQL
- SQL Join
- SQL Aggregations
- Sub Queries & Temporary Tables
- SQL Data Cleansing
- [Advanced]SQL Window Functions
- [Advanced]SQL Advanced Joins & Performance Tuning
