Lift the Elephant: Scaling PostgreSQL Beyond Query Optimization

This textbook provides a thorough walkthrough of relational database SQL queries, multi-table joins, and optimization tips, complete with rich snippets and exercises. Inside, you can see SELECT filters, JOIN combinations, aggregations, and indices indexing syntax. You will learn how to compose high-performance relational queries and avoid full table scans.