| September 25 |
1. Introduction (2.1-3)
|
| September 27 |
2. SQL Basics (6.1-6.2)
|
| September 30 |
3. SQL Joins (6.1-6.2)
|
| October 2 |
4. SQL NULLs, Aggregates
|
| October 4 |
5. Aggregates
|
| October 7 |
6. SQL Review (so far)
|
| October 9 |
7. SQL Subqueries
|
| October 11 |
8. SQL Subqueries
|
| October 14 |
9. Relational Algebra (Recording only)
|
| October 16 |
10. ER Diagrams (2.1) (Recording only)
|
| October 18 |
11. ER Diagrams (2.2-2.3)
|
| October 21 |
12. Functional Dependencies (2.2-2.3)
|
| October 23 |
13. BCNF (3.4-3.6)
|
| October 28 |
15. TXN Basics (18.1-18.2) demo
|
| October 30 |
16. TXN Serializability (18.1-18.2)
|
| November 1 |
17. TXN Locks
|
| November 4 |
18. TXN Isolation Levels
|
| November 6 |
19. Application Programming
|
| November 8 |
20. TXN Isolation Levels
|
| November 13 |
21. Query Execution
|
| November 15 |
22. Storing Data on Disk
|
| November 18 |
23. Indexes
|
| November 20 |
24. External Memory Algorithms
|
| November 22 |
25. Query Optimization
|
| November 25 |
26. Cardinality Estimation
|
| November 27 |
27. Semistructured Data
|
| December 2 |
28. SQL++ Demo
|
| December 4 |
29. SQL++ Demo
|
| December 6 |
30. Review
|