SELECT, WHERE, ORDER BY, and LIMIT

About 65-85 minutes of guided work.

By the end of this module you can write a SELECT that says exactly what you mean, predict which rows a filter will silently drop, and use SQL's logical evaluation order to know where an alias is visible and where relying on it will break on another engine.

Units

1. Unit 02.00: Naming columns instead of SELECT *
2. Unit 02.01: Filtering: what WHERE silently excludes
3. Unit 02.02: Logical order: when an alias is visible
4. Unit 02.03: Sorting, ties, and non-deterministic LIMIT
5. Unit 02.04: Exploring safely without shipping a truncated total

Module work

• Activity
• Knowledge check
• Summary