Learn SQL Online — Free Structured Course
Free structured SQL course
Choose a lesson while the workspace loads
Explore 129 lessons across 11 ordered modules, from relational foundations through production SQL.
Foundational Concepts7 lessons
SQL Fundamentals15 lessons
- SELECT & Data Retrieval
- WHERE Clause & Filtering
- Comparison & Logical Operators
- Column Aliasing & Expressions
- Data Types & Type Conversion
- DISTINCT & Removing Duplicates
- CASE Statements & Conditional Logic
- INSERT, UPDATE, DELETE Statements
- Arithmetic & Numeric Functions
- String Functions & Operations
- Date & Time Functions
- ORDER BY & Sorting
- LIMIT & OFFSET
- NULL Handling
- Basic Transactions
Advanced Filtering7 lessons
Aggregate Functions & Grouping11 lessons
- COUNT, SUM, AVG, MIN, MAX
- NULL Handling in Aggregate Functions
- GROUP BY Fundamentals
- HAVING Clause
- Multiple Aggregates & Complex Grouping
- Conditional Aggregation with CASE & FILTER
- String Aggregation Functions
- Statistical & Advanced Aggregate Functions
- DISTINCT & ALL
- ROLLUP & CUBE
- Aggregate Functions vs Window Functions
Joins & Relationships15 lessons
- INNER JOIN Deep Dive
- NULL Handling in JOIN Operations
- LEFT/RIGHT/FULL OUTER JOIN
- CROSS JOIN
- Self Joins
- Multiple Table Joins
- Many-to-Many Relationship Patterns
- Complex JOIN Conditions
- JOIN with Aggregation & GROUP BY
- ANTI-JOINs & Finding Non-Matching Rows
- Semi-JOINs & EXISTS Pattern
- Join Order & Optimization Strategies
- LATERAL JOINs & Row-by-Row Operations
- Subqueries vs JOINs: Performance & Readability
- Join Performance Optimization
Subqueries & CTEs13 lessons
- Subquery Types & Classification
- Scalar Subqueries
- Subqueries in SELECT Clause
- Subqueries in WHERE Clause
- Subqueries in FROM Clause (Derived Tables)
- Correlated Subqueries
- Correlated Subqueries Deep Dive
- Common Table Expressions
- Recursive CTEs
- Recursive CTEs for Hierarchical Data
- Materialized CTEs
- Window Functions vs CTEs
- CTE Performance Optimization
Window Functions15 lessons
- Window Functions Fundamentals
- Ranking Functions Deep Dive
- ROW_NUMBER, RANK, DENSE_RANK
- Offset Functions (LAG/LEAD)
- LEAD, LAG, FIRST_VALUE, LAST_VALUE
- Aggregate Functions as Window Functions
- Running Totals & Moving Averages
- NTH_VALUE & Other Advanced Functions
- PARTITION BY Clause & Window Definition
- PARTITION BY vs GROUP BY
- Window Frame Specifications
- Window Frames (ROWS vs RANGE)
- Advanced Analytics Functions
- Window Functions Performance Optimization
- Real-World Window Function Patterns
Query Optimization & Performance16 lessons
- Query Optimization Fundamentals
- Understanding EXPLAIN Plans
- Execution Plans & EXPLAIN
- Index Types Deep Dive
- Index Types & Strategies
- Join Optimization Strategies
- Subquery Optimization
- Aggregate Query Optimization
- Query Rewriting Patterns
- Index Design & Selection
- Query Rewriting Techniques
- Statistics & Query Planning
- Statistics & Cardinality
- Caching & Memory Management
- Table Partitioning Strategies
- Real-World Performance Tuning Cases
Database-Specific Features18 lessons
- Database System Fundamentals
- MySQL Features Deep Dive
- MySQL: JSON Functions
- MySQL String & Math Functions
- PostgreSQL Features Deep Dive
- PostgreSQL: Arrays & JSONB
- PostgreSQL: Advanced Data Types
- PostgreSQL: Full-Text Search
- SQL Server Features Deep Dive
- SQL Server: T-SQL Features
- SQL Server: Windowing & Pagination
- Oracle Features Deep Dive
- Oracle: PL/SQL Basics
- Oracle: Advanced PL/SQL
- SQLite: Embedded SQL
- Cross-Database Compatibility
- Database Migration Strategies
- Real-World Database Selection