sql
- SQL Joins
Combining rows from multiple tables with INNER, LEFT, RIGHT, FULL, and CROSS joins, including NULL behavior and performance considerations. - SQL Indexes and Query Performance
How database indexes make lookups fast, when they help, and how to design them for predictable query cost.