Learn
Practice
Newsletter
Resources
Animations
New
F
Toggle theme
0
F
0
Toggle menu
SQL Roadmap
What is SQL & Relational Databases
Primary Keys & Foreign Keys
Setting up Database (MySQL, PostgreSQL, SQLite)
Foundations
Database vs Table vs Row vs Column
Data Types in SQL
SELECT Statements
Sorting with ORDER BY
DISTINCT
Basic Querying
Filtering with WHERE
LIMIT & OFFSET
Basic Operators (AND, OR, NOT, BETWEEN, IN)
COUNT, SUM, AVG, MIN, MAX
HAVING Clause
Aggregations
GROUP BY
NULL Handling (IS NULL, COALESCE)
INNER JOIN
RIGHT JOIN
SELF JOIN
UNION & UNION ALL
Joins
LEFT JOIN
FULL OUTER JOIN
CROSS JOIN
Subqueries (Scalar, Correlated)
Window Functions (ROW_NUMBER, RANK, PARTITION BY)
String Functions
Intermediate SQL
CTEs (Common Table Expressions)
CASE Statements
Date & Time Functions
Normalization (1NF, 2NF, 3NF, BCNF)
Entity-Relationship Diagrams (ERD)
Indexes (Clustered vs Non-Clustered)
Schema Design & Modeling
Denormalization
One-to-One, One-to-Many, Many-to-Many Relationships
Constraints (NOT NULL, UNIQUE, CHECK)
ACID Properties
Isolation Levels (READ COMMITTED, SERIALIZABLE, etc.)
Transactions & Concurrency
COMMIT & ROLLBACK
Deadlocks & Locking Mechanisms
Indexes & Query Optimization
Denormalization for Performance
Caching Strategies
Performance & Optimization
Execution Plans & EXPLAIN
Sharding & Partitioning Basics
Stored Procedures & Functions
Views & Materialized Views
JSON & Arrays in SQL
Advanced SQL Topics
Triggers
Recursive Queries
Full-text Search
Designing a Library Database
Analytics Dashboard Queries
ETL (Extract, Transform, Load) with SQL
Practical Applications
E-commerce Schema Design
Handling Large Datasets
SQL Query Challenges
Schema Design Problems
Interview Preparation
Optimization Questions
Real-World Case Studies
SQL Roadmap
