00:00:00 Database Design
00:02:15 Normalization
00:04:49 Numeric Data in SQL
00:07:09 Temporal Data Types in SQL
00:09:30 Character Data Types in SQL
00:11:31 NULLs: Missing Data in SQL
00:13:38 Multiple Column Data Elements
00:15:34 Table Operations
00:18:09 Comparison or Theta Operators
00:19:39 Valued Predicates
00:21:18 CASE Expressions
00:23:33 LIKE Predicate
00:25:06 BETWEEN and OVERLAPS Predicates
00:26:35 The [NOT] IN() Predicate
00:28:14 EXISTS() Predicate
00:29:54 Quantified Subquery Predicates
00:31:50 The SELECT Statement
00:33:37 VIEWs, Derived Tables, Materialized Tables, and Temporary Tables
00:35:41 Partitioning Data in Queries
00:37:09 Grouping Operations
00:38:29 Aggregate Functions
00:40:18 Auxiliary Tables
00:41:52 Statistics in SQL
00:43:31 Regions, Runs, Gaps, Sequences, and Series
00:44:55 Arrays in SQL
00:46:32 Set Operations
00:47:59 Subsets
00:49:17 Trees and Hierarchies in SQL
00:51:09 Temporal Queries
00:52:54 Graphs in SQL
00:54:18 OLAP in SQL
00:56:26 Transactions and Concurrency Control
00:58:29 Optimizing SQL
Based on Joe Celko's SQL for Smarties: Advanced SQL Programming.
