Lectures
Lectures are pre-recorded videos in which new concepts and skills are introduced by example. Every two weeks, you’ll begin learning new concepts and skills by engaging with the corresponding lecture.
Lectures are watched on-demand.
| Date | Lecture | Topics | |
|---|---|---|---|
| Lecture 0 | 2024-01-22T12:00:00-05:00 | Querying | databases, database engines, selecting, filtering, aggregating, ordering |
| Lecture 1 | 2024-02-05T12:00:00-05:00 | Relating | keys, tables, nested queries, joins |
| Lecture 2 | 2024-02-19T12:00:00-05:00 | Designing | schemas, types, table creation, normalization |
| Lecture 3 | 2024-03-04T12:00:00-05:00 | Writing | inserting, updating, cleaning, deleting, triggers |
| Lecture 4 | 2024-03-18T12:00:00-04:00 | Viewing | views for simplifying, aggregating, partitioning, and securing; common table expressions |
| Lecture 5 | 2024-04-01T12:00:00-04:00 | Optimizing | indexes, b-trees, locks, transactions, vacuuming |
| Lecture 6 | 2024-04-15T12:00:00-04:00 | Scaling | database servers (MySQL, PostgreSQL), replicating, sharding, access controls |