[go: up one dir, main page]
Scribd
Upload
20 views2 pages

6-Day SQL Syllabus PostgreSQL

This 6-day SQL syllabus focuses on data analytics and data science using PostgreSQL. It covers foundational SQL concepts, aggregations, joins, subqueries, window functions, and includes practical projects and interview preparation resources. Each day features specific topics, practice exercises, and recommended resources for learning and application.

Uploaded by

Dev Soni
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
20 views2 pages

6-Day SQL Syllabus PostgreSQL

This 6-day SQL syllabus focuses on data analytics and data science using PostgreSQL. It covers foundational SQL concepts, aggregations, joins, subqueries, window functions, and includes practical projects and interview preparation resources. Each day features specific topics, practice exercises, and recommended resources for learning and application.

Uploaded by

Dev Soni
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

6-Day SQL Syllabus for Data Analytics & Data Science

Using PostgreSQL | Generated on July 23, 2025

Day 1: SQL Foundations + SELECT Mastery


- - SELECT, FROM, WHERE, ORDER BY
- - Logical operators: =, <>, <, >, BETWEEN, LIKE, IN, IS NULL
- - LIMIT, DISTINCT, Aliases (AS)
- Resources: SQLBolt (Lessons 1-5), Mode.com SQL Tutorial
- Video: FreeCodeCamp SQL (0-40 mins)
- Practice: LeetCode (Easy), DB Fiddle

Day 2: GROUP BY, Aggregations & HAVING


- - COUNT, SUM, AVG, MIN, MAX
- - GROUP BY multiple columns, HAVING
- Resources: SQLBolt (Lessons 6-8), W3Schools Aggregates
- Video: Corey Schafer (GROUP BY)
- Practice: HackerRank (Aggregations), Mode SQL

Day 3: JOINs (The Real World Skill)


- - INNER, LEFT, RIGHT, FULL JOIN
- - JOIN ON, Filtering joined results, Table Aliases
- Resources: SQLBolt (Lessons 9-12), Mode SQL JOINs
- Video: Be A Better Dev (Joins Explained Visually)
- Practice: LeetCode JOINs, DB Fiddle

Day 4: Subqueries + CASE WHEN


- - Scalar and Correlated Subqueries
- - CASE WHEN THEN ELSE END logic
- Resources: SQLBolt, W3Schools, SQLServerTutorial
- Video: Caleb Curry (Subqueries)
- Practice: HackerRank (Advanced SELECT), LeetCode
Day 5: Window Functions + RANKING
- - OVER(), PARTITION BY, ORDER BY
- - ROW_NUMBER(), RANK(), DENSE_RANK(), LAG(), LEAD()
- Resources: Mode SQL Tutorial, SQLShack Guide
- Video: Data with Dan (Window Functions)
- Practice: LeetCode (Window Functions), DB Fiddle

Day 6: Projects + Interview Prep


- - Practice with IMDb & Nashville Housing Dataset
- - Mini projects: Top 10 movies, Avg house price, Seller ranking
- Tools: PostgreSQL via pgAdmin, DB Fiddle, Mode Notebooks
- Interview Prep: StrataScratch, DataLemur SQL Questions

You might also like