Week 1

• Administrivia
• Intro, Database Design, ER Model, UML-ish notation

Week 2

• Relational Database Model
• Intro to SQL: Language and the basics

Week 3

• More SQL: Joins, Views, Transactions, Data types
• Programatic SQL: Functions, Procedures, Triggers, and Recursive queries

Week 4

• Relational algebra
• Relational algebra (cont), relational calculus

Week 5

• Exam #1
• Trees-structured indexes

Week 6

• Hash-based indexing
• Query evaluation, external sorting

Week 7

• Transactions
• Concurrency Control

Week 8

• Transactions/Concurrency control, extra day
• Exam #2

Week 9

• Semi-structured Databses/XML
• XML, a Programmer's view

Week 10

• Object-Oriented and Object-Relational Model
• Data warehousing and Data mining

Week 11

• Distributed databases, challenges of
• Casandra and HBase

Week 12

• Database theory, normalization, dependency theory, etc. (Part 1)
• Database theory, normalization, dependency theory, etc. (Part 2)

Week 13

• Database design and tuning, physical considerations (Part 1)
• Database design and tuning, physical considerations (Part 2)

Week 14

• Query optimization
• No class, Thanksgiving

Week 15

• Recovery
• Close up shop