CSE 344 Autumn 2013
Lecture Topics

Subscribe to this calendar (google, iCal, etc.)

DateDescription
September 25 1. Introduction
Slides
September 27 2. Data Models (2.1-2.3)
Sqlite notes
September 30 3. SQL (6.1, 6.2)
Sqlite notes (Sqlite supplement)
October 2 4. SQL - Aggregates (6.3, 6.4)
Slides, Sqlite notes, data
October 4 5. SQL - Aggregates (6.3, 6.4)
same materials from last lecture
October 7 6. Basic Query Evaluation, Indexes (14.1)
Slides
October 9 7. SQL - Nested Queries (6.3)
Slides Sqlite notes, Additional notes
October 11 8. SQL Wrap-up and RDBMs Architecture (6.3, 2.4)
Slides
October 14 9. Relational Algebra (2.4, 5.1) -- guest Lecturer Sudeepa Roy
Slides
October 16 10. Relational Algebra Wrapu and Architectures
Slides
October 18 11. Datalog (5.3, 5.4)
Slides
October 21 12. Relational Calculus (5.3, 5.4)
Slides, Query Language Primer
October 23 13. XML, XPath (11.1-11.3, 12.1)
Slides XML XML with DTD
October 25 14. XPath and XQuery (12.1 - 12.2)
Slides
October 28 15. E/R Diagrams (4.1-4.6)
Slides
October 30 16. Constraints (7.1, 7.2, 7.4)
Slides
November 1 17. Design Theory (3.1-3.4)
Slides
November 6 19. Midterm Discussion, Design Theory Wrap-up, Views
Slides
November 8 20. Views (continue lecture from last week)
November 13 21. Transactions
Sqlite Notes
November 15 22. Transactions
Slides
November 18 23. Transactions
Slides
November 20 24. Parallel Databases
Slides
November 22 25. Parallel Databases
November 25 26. Parallel Databases - MapReduce
Slides
November 27 27. Parallel Databases - MapReduce
December 2 28. Parallel Databases - MapReduce, PigLatin
Slides
December 4 29. Parallel Databases - Wrapup
Slides
December 6 30. Final Review
Slides