Table of Contents

Index Design Drills

SQL Problem Drills

Concurrency Control

EXPLAIN & Planner Behavior

ORM Abstractions & Defects

Cursor vs Offset Pagination

UNLOGGED Tables

Recursive Query

Stored Procedures

Review: Launch & Mgmt

Review: Data Types

Review: Constraints

Review: Joins / Grouping / Aggregating

Review: Text Search

Review: Loading and Normalizing CSV

Window Functions