SQL Cheat Sheets

Indexing, query tuning, execution plans, and performance patterns.

SQL performance reference covering execution plans, indexing strategy, joins, pagination, deduplication, data quality, and common optimization patterns across relational databases.

Related categories

Explore connected topics to go deeper.

PostgreSQL

Advanced relational features

System Design

Data modeling decisions

AWS

Managed database services

Popular in SQL

Quick picks to get you started.

SQL Indexing and Performance

Query tuning patterns with EXPLAIN, indexing, keyset pagination, deduplication, and optimization-oriented SQL recipes.

Updated 3/6/2026

SQL Window Functions and CTEs

Use CTEs, recursive queries, ranking, running totals, partitions, and lag/lead patterns for analytical SQL.

Updated 3/6/2026

SQL DDL and DML

Create and change schema objects, then insert, update, delete, merge, and manage transactional data changes.

Updated 3/6/2026

SQL Functions and Aggregation

Reference for string, date, numeric, conditional, null-handling, and aggregate SQL functions.

Updated 3/6/2026

SQL Joins and Subqueries

Advanced relational query patterns for joins, subqueries, EXISTS, IN, set operations, and correlated queries.

Updated 3/6/2026

SQL Cheat Sheet

Core SQL syntax and patterns for querying, filtering, sorting, joining, grouping, and modifying data.

Updated 3/6/2026

All SQL sheets

6 published sheets · sorted by recently updated.

SQL Indexing and Performance

Query tuning patterns with EXPLAIN, indexing, keyset pagination, deduplication, and optimization-oriented SQL recipes.

Updated 3/6/2026

SQL Window Functions and CTEs

Use CTEs, recursive queries, ranking, running totals, partitions, and lag/lead patterns for analytical SQL.

Updated 3/6/2026

SQL DDL and DML

Create and change schema objects, then insert, update, delete, merge, and manage transactional data changes.

Updated 3/6/2026

SQL Functions and Aggregation

Reference for string, date, numeric, conditional, null-handling, and aggregate SQL functions.

Updated 3/6/2026

SQL Joins and Subqueries

Advanced relational query patterns for joins, subqueries, EXISTS, IN, set operations, and correlated queries.

Updated 3/6/2026

SQL Cheat Sheet

Core SQL syntax and patterns for querying, filtering, sorting, joining, grouping, and modifying data.

Updated 3/6/2026