Wiki search

SQL in 10 Minutes — Your First Queries and Core Mental Model

Complete beginner guide to SQL querying, clause execution order, SELECT, WHERE, ORDER BY, LIMIT, NULL logic, grouping, and transaction safety.

SQL Indexes and EXPLAIN — How to Optimize Database Queries

Complete beginner guide to understanding B-tree indexes, reading EXPLAIN query plans, avoiding full table scans, and knowing when indexes hurt performance.