SQL Guides

SQL Reference includes 25 in-depth SQL guides that go beyond single-statement documentation. Each guide opens with an introduction to the topic and then walks through its concepts in ordered sections with prose explanations and real queries, so you can read it start to finish like a chapter of a book. Topics range from fundamentals such as SQL Introduction to joins, aggregation, subqueries, window functions, indexing, and query optimization. The full list: SQL Introduction, SELECT Statement, WHERE Clause & Operators, SQL JOINs, GROUP BY & Aggregation, Subqueries & CTEs, INSERT, UPDATE, DELETE, Creating & Managing Tables, Indexes & Performance, Transactions & Concurrency, Views & Virtual Tables, SQL Data Types, SQL Functions Overview, Advanced SQL Topics, Setting Up SQL Databases, Window Functions, Recursive CTEs, NULL Handling, String Functions Deep Dive, Date/Time Functions Deep Dive, Numeric Functions Deep Dive, Advanced Subqueries, JSON in SQL, Pivoting & Cross-Tab, Query Optimization. Pair a guide with the matching category reference pages to look up individual statements, or practice what you learn in the SQL playground, which runs queries live in your browser with sample data.