Query Language
SQL Guides
Learn to query, join, and shape relational data — the core skill behind almost every data engineering and analytics role.
Topic Areas
What You'll Learn
SQL guides organized by concept, from basic queries to advanced patterns.
🔍
Selecting & Filtering
SELECT, WHERE, ORDER BY, and LIMIT fundamentals.
🔄
Joins
INNER, LEFT, RIGHT, and FULL joins across multiple tables.
🔢
Aggregations
GROUP BY, HAVING, and aggregate functions like SUM and COUNT.
📈
Window Functions
Running totals, ranking, and partitioned calculations.
🛠️
Schema Design
Primary keys, foreign keys, and normalization basics.
⚡
Query Performance
Indexing strategies and reading query execution plans.
Start Here
Featured SQL Tutorial
The most popular starting point for new SQL learners.