◈ BEGINNERSELECT · WHERE · JOIN · GROUP BY · ORDER BY ◆ INTERMEDIATECTEs · WINDOW FUNCTIONS · NORMALIZATION · INDEXES ◉ ADVANCEDTRANSACTIONS · STORED PROCEDURES · TRIGGERS ◎ EXPERTQUERY OPTIMIZATION · PARTITIONING · DATA WAREHOUSE ◈ BEGINNERSELECT · WHERE · JOIN · GROUP BY · ORDER BY ◆ INTERMEDIATECTEs · WINDOW FUNCTIONS · NORMALIZATION · INDEXES ◉ ADVANCEDTRANSACTIONS · STORED PROCEDURES · TRIGGERS ◎ EXPERTQUERY OPTIMIZATION · PARTITIONING · DATA WAREHOUSE
SQL Mastery Roadmap
S Built by Surendra Manthri · FULL STACK AI DEVELOPER

MASTER
SQL
FROM ZERO

A complete, battle-tested learning path to take you from writing your first SELECT to architecting production-grade database systems — with every resource ranked and linked.

225+
Hours of Content
40+
Curated Resources
5
Learning Phases
4
Skill Levels
Start Learning ↓ View Timeline →
◈
Phase 01 — Beginner
FOUNDATIONS
Weeks 1–3  ·  ~45 hrs  ·  SELECT · WHERE · JOINs · Aggregates
01
📹 Video Courses
🎬
SQL Tutorial – Full Database Course for Beginners
freeCodeCamp · YouTube
Free ⏱ 4.5 hrs ★★★★★
Best single free video to start with. Covers all fundamentals using PostgreSQL. Zero fluff — pure hands-on SQL from minute one.
Open Resource
🏫
Intro to SQL: Querying and Managing Data
Khan Academy
Free ⏱ 6–8 hrs ★★★★★
Interactive browser-based SQL. Zero setup required. Perfect for absolute beginners — type SQL directly in the browser and see instant results.
Open Resource
🎓
The Complete SQL Bootcamp (Jose Portilla)
Udemy
~$15 ⏱ 9 hrs ★★★★★
Most popular paid SQL course on the internet. PostgreSQL-focused with great real-world exercises. Best value for money.
Open Resource
🌐 Interactive Practice
🐘
SQLZoo — Interactive SQL Exercises
sqlzoo.net
Free ⏱ 10–15 hrs ★★★★★
Run-in-browser exercises that get progressively harder. Every core SQL concept covered with instant feedback. A classic for a reason.
Open Resource
📊
Mode SQL Tutorial
mode.com/sql-tutorial
Free ⏱ 8 hrs ★★★★☆
Business analytics focus with real datasets. Excellent if you're on the data analyst career track. Teaches SQL the way analysts actually use it.
Open Resource
🔧
DB Fiddle — Browser SQL Sandbox
db-fiddle.com
Free ⏱ Instant ★★★★★
Zero-install browser SQL sandbox. Try any query instantly, share with others. Your daily scratchpad for experimenting with SQL.
Open Resource
📚 Books & 🛠 Tools
📖
Learning SQL, 3rd Edition
Alan Beaulieu — O'Reilly
~$50 ⏱ Self-paced ★★★★★
The definitive SQL beginner book. Clear, comprehensive explanations with MySQL & Oracle examples. Read alongside your video course.
Open Resource
🐘
PostgreSQL + pgAdmin
postgresql.org
Free ⏱ 30 min setup ★★★★★
Install this first, before anything else. PostgreSQL is the best SQL dialect to learn on. pgAdmin gives you a full GUI. One install, maximum power.
Download Free
🎯
Phase 1 Milestone — Before Moving On
Write a 5-table e-commerce schema with proper JOINs, GROUP BY, HAVING, and ORDER BY entirely from memory. No looking at notes.
◆
Phase 02 — Intermediate
POWER QUERIES
Weeks 4–7  ·  ~60 hrs  ·  CTEs · Window Functions · Design · Indexing
02
📹 Video Courses
🪟
Window Functions Explained (Playlist)
Socratica · YouTube
Free ⏱ 2 hrs ★★★★★
The clearest visual explanation of OVER, PARTITION BY, RANK, LAG, and LEAD on all of YouTube. Watch this before any other window function resource.
Open Resource
🎓
Advanced SQL for Data Scientists
LinkedIn Learning
LinkedIn Premium ⏱ 3 hrs ★★★★☆
Industry-standard coverage of window functions, CTEs, and analytical queries — explained brilliantly with data science use cases.
Open Resource
🎓
PostgreSQL: Advanced SQL Queries
Udemy
~$15 ⏱ 5 hrs ★★★★☆
Deep dive into window functions and CTEs specifically for PostgreSQL. Exercises are dense and practical. A great pair with the Socratica videos.
Open Resource
🌐 Practice Platforms — Interview Prep Begins Here
⚡
LeetCode Database Problems
leetcode.com/problemset/database
Free Tier ⏱ Ongoing ★★★★★
#1 platform for SQL interview prep. 200+ problems, real company tags (Google, Meta, Amazon). The medium-level problems will make you a solid intermediate. Essential.
Start Solving
🎯
StrataScratch
stratascratch.com
Free ⏱ Ongoing ★★★★★
Real SQL interview questions from Google, Amazon, Meta, Netflix. Heavy on window functions. The closest thing to actual FAANG interviews you'll find for free.
Start Solving
🔗
Use The Index, Luke!
use-the-index-luke.com
Free ⏱ 8–10 hrs ★★★★★
The definitive free guide to SQL indexing. Explains B-tree indexes, composite index strategy, covering indexes, and EXPLAIN output. Read every single page.
Open Resource
📚 Books
📖
SQL Antipatterns (Vol 1 & 2)
Bill Karwin — Pragmatic Programmers
~$45 ⏱ Self-paced ★★★★★
Learn what NOT to do — which turns out to be even more valuable than learning what to do. Game-changing for database design thinking. Every mistake you'll ever make is in here.
Open Resource
📖
Database Design for Mere Mortals
Michael Hernandez — Addison Wesley
~$55 ⏱ Self-paced ★★★★★
Best book on relational database design and normalization — hands-on approach with real exercises. You'll design schemas instinctively after this.
Open Resource
🎯
Phase 2 Milestone — Before Moving On
Solve 20 LeetCode Medium SQL problems. Write a fully normalized 3NF database schema for a hospital or university system from scratch.
◉
Phase 03 — Advanced
PROCEDURES & TUNING
Weeks 8–11  ·  ~50 hrs  ·  Transactions · Stored Procedures · Triggers · EXPLAIN
03
📹 Video Courses
🔄
Database Transactions & ACID Explained
Hussain Nasser · YouTube
Free ⏱ 1 hr ★★★★★
Best visual explanation of ACID, isolation levels, and deadlocks on YouTube. Hussain Nasser draws diagrams in real-time that make these concepts click instantly.
Watch Free
⚙️
PostgreSQL PL/pgSQL — Complete Course
Udemy
~$15 ⏱ 8 hrs ★★★★★
The best course specifically on PL/pgSQL stored procedures, functions, and triggers. Dense, practical, with real-world business scenarios throughout.
Open Resource
🎓
SQL Server: Stored Procedures & Transactions
Pluralsight
~$29/mo ⏱ 4 hrs ★★★★☆
Industry-standard coverage of stored procedures, triggers, and transactions in SQL Server. Essential for enterprise & backend developer roles.
Open Resource
🌐 Practice & 📚 Books & 🛠 Tools
💡
DataLemur — FAANG SQL Questions
datalemur.com
Free ⏱ Ongoing ★★★★★
Real SQL interview questions from FAANG companies with detailed solutions and explanations. Highly relevant to actual hiring processes at top tech firms.
Start Solving
📖
SQL Performance Explained
Markus Winand — winand.at
~$30 ⏱ Self-paced ★★★★★
The best book on SQL query optimization and indexing strategies. Concise, dense, and directly applicable. Every page will improve your query writing.
Open Resource
🛠
DBeaver Community Edition
dbeaver.io
Free ⏱ 30 min setup ★★★★★
Best universal database GUI. Visual EXPLAIN plans, schema browser, query history, all SQL dialects. This is the professional tool DBAs actually use daily.
Download Free
🎯
Phase 3 Milestone — Before Moving On
Build a complete banking transaction system with full ACID compliance, stored procedures for fund transfers, and audit triggers that log every balance change.
◎
Phase 04 — Expert
ARCHITECTURE & SCALE
Weeks 12–16  ·  ~70 hrs  ·  Query Optimization · Partitioning · Data Warehouse · Real Projects
04
📹 Video Courses
🏛
CMU 15-445: Database Engineering
Carnegie Mellon University · YouTube
Free ⏱ 40+ hrs ★★★★★
World-class university course taught by top researchers. Deep internals: B-trees, buffer pools, query planning, concurrency control. This is the real thing — not a tutorial.
Watch Free
📦
Data Warehouse Fundamentals
Udemy (Nikolai Schuler)
~$15 ⏱ 7 hrs ★★★★★
Star schema, fact/dimension tables, slowly changing dimensions — all built from scratch. Perfect companion to the Kimball book. You'll design warehouses confidently after this.
Open Resource
🔬
PGExercises — PostgreSQL Deep Dives
pgexercises.com
Free ⏱ 15–20 hrs ★★★★★
PostgreSQL-specific exercises that are structured, progressive, and deeply challenging. The most thorough free exercise platform specifically for PostgreSQL power users.
Start Solving
📚 Books — Must-Reads for Senior Engineers
📕
Designing Data-Intensive Applications
Martin Kleppmann — O'Reilly
~$60 ⏱ Self-paced ★★★★★
THE bible of data systems architecture. Every senior engineer must read this. Covers storage engines, replication, partitioning, transactions, and distributed systems. Life-changing.
Open Resource
📗
The Data Warehouse Toolkit, 3rd Ed.
Kimball & Ross — Wiley
~$65 ⏱ Self-paced ★★★★★
The definitive dimensional modeling bible. Used by every data engineer and BI architect on the planet. If you work with data warehouses, this is required reading.
Open Resource
🎓 Certifications Worth Getting
🏅
HackerRank SQL Certificate
HackerRank — Advanced Level
Free ⏱ 1–2 hrs ★★★★☆
Free, shareable, recognized by recruiters worldwide. Put it on your LinkedIn and resume immediately. Start with this — fastest ROI of any certification here.
Get Certified
☁️
Google Data Analytics Certificate
Coursera / Google
~$49/mo ⏱ 6 months ★★★★☆
Industry-recognized certificate covering SQL, BigQuery, and data analysis. Excellent for career pivots into data analytics. Google's brand carries real weight with hiring managers.
Enroll Now
🔵
Microsoft DP-900: Azure Data Fundamentals
Microsoft Learn
$165 exam ⏱ Self-paced ★★★★☆
Validates SQL + cloud database knowledge. Strong for enterprise and Microsoft-stack roles. Free prep materials available on Microsoft Learn.
Learn More
🎯
Phase 4 Milestone — You've Made It
Design and build a full e-commerce OR analytics data warehouse from scratch. Present your schema, explain every design decision, and publish it on GitHub.
∞
Phase ∞ — Ongoing
STAY SHARP
Forever  ·  Daily habit  ·  Community · Projects · Blogs
∞
🏘 Community & 📰 Blogs
💬
DBA Stack Exchange
dba.stackexchange.com
Free⏱ Daily★★★★★
Expert-level Q&A answered by actual DBAs and database researchers. The quality of answers here is unmatched anywhere else on the internet. Bookmark and check daily.
Join Community
📡
Planet PostgreSQL
planet.postgresql.org
Free⏱ Weekly★★★★★
Aggregated blog feed from PostgreSQL experts and core contributors worldwide. Always fresh, always expert-level. This is how you stay ahead of the curve.
Read Now
✍️
Haki Benita's Blog
hakibenita.com
Free⏱ Monthly★★★★★
Some of the best deep-dive SQL and PostgreSQL performance articles anywhere on the web. Every post is a masterclass. Save every single article you read here.
Read Blog
🗂
Kaggle Datasets + SQL
kaggle.com/datasets
Free⏱ Ongoing★★★★★
Download real-world datasets and build your own analytics projects. Publish your work publicly. Nothing builds credibility faster than a real project with real data on your GitHub.
Explore Datasets
🏆
Ongoing Milestone — Build Your Reputation
Publish a SQL project on GitHub. Answer 10 questions on DBA Stack Exchange. Earn the HackerRank SQL Advanced certificate. Share your progress on LinkedIn.
WEEK-BY-WEEK
Your complete 16-week learning timeline
WK 1–3
◈ Beginner — Foundations
SQL Syntax SELECT & WHERE JOINs GROUP BY
freeCodeCamp video · Khan Academy · SQLZoo · Install PostgreSQL
WK 4–7
◆ Intermediate — Power Queries
CTEs Window Functions Normalization Indexes
Socratica YouTube · LeetCode Medium · StrataScratch · Use-The-Index-Luke
WK 8–11
◉ Advanced — Procedures & Tuning
Transactions Stored Procedures Triggers EXPLAIN ANALYZE
Udemy PL/pgSQL · Hussain Nasser YouTube · DataLemur · DBeaver
WK 12–16
◎ Expert — Architecture & Scale
Query Optimization Partitioning Star Schema Real Projects
CMU 15-445 · Kimball Book · DDIA · Kaggle Projects · Certifications
WK 17+
∞ Ongoing — Build & Contribute
Open Source Community Blogging Networking
DBA StackExchange · Planet PostgreSQL · GitHub · LinkedIn
START TODAY — 100% FREE
Everything you need to begin · Zero cost · Zero excuses
01
Install PostgreSQL
postgresql.org · Free · 30 min
02
Watch freeCodeCamp SQL
YouTube · Free · 4.5 hrs
03
Practice on SQLZoo
sqlzoo.net · Free · 10 hrs
04
Solve LeetCode SQL
leetcode.com · Free tier
05
Get Certified
HackerRank · Free · 1–2 hrs