SQL & Query Processing
A 16-module path through sql & query processing, in study order from foundations to the frontier.
Modules
- SQL Data Definition and Schema Creation
- Basic SELECT Queries and Projection
- Joins in SQL
- Aggregation and the GROUP BY Clause
- Nested Subqueries
- Set Operations in SQL
- Views in SQL
- Triggers and Stored Procedures
- Indexing Overview for Query Access
- Query Processing Overview
- Selection and Projection Evaluation
- Cost Estimation for Query Plans
- Join Algorithms: Nested-Loop
- Join Algorithms: Sort-Merge
- Join Algorithms: Hash Join
- The Query Optimizer