0
|
1/19
|
- Course overview and introduction
- Database design and ER diagrams
|
1
|
1/22, 1/24, 1/26
|
- ER diagrams (cont.)
- The relational model
- Relational algebra and SQL
|
2
|
1/29, 1/31, 2/2
|
- SQL (cont.)
- 1/31: last day to add a class
- Problem Set 1, part I due on 1/30
|
3
|
2/5, 2/7, 2/9
|
|
4
|
2/12, 2/14, 2/16
|
- Indexing (cont.)
- Semi-structured data and XML databases
- Problem Set 1, part II due on 2/13
|
5
|
2/21, 2/23
|
- XML databases (cont.)
- Implementing a logical-to-physical mapping
- Query processing
- No lecture on 2/19 (holiday)
- No labs this week; Wed. is a Monday schedule
- 2/22: last day to drop without a ‘W’
- Problem Set 2, part I due on 2/20
|
6
|
2/26, 2/28, 3/1
|
- Transactions and schedules
- Midterm 1 on 2/28
|
7
|
3/4, 3/6, 3/8
|
- Transactions (cont.)
- Problem Set 2, part II due on 3/5
|
|
|
Spring break
|
8
|
3/18, 3/20, 3/22
|
|
9
|
3/25, 3/27, 3/29
|
- Concurrency control (cont.)
- Distributed databases and replication
- 3/29: last day to drop with a ‘W’
- Problem Set 3 (all) due on 3/26
|
10
|
4/1, 4/3, 4/5
|
- Distributed databases (cont.): map-reduce
- NoSQL
- Problem Set 4, part I due on 4/2
|
11
|
4/8, 4/10, 4/12
|
- NoSQL (cont.)
- Midterm 2 on 4/8
|
12
|
4/17, 4/19
|
- Recovery and logging
- Problem Set 4, part II due on 4/16
|
13
|
4/22, 4/24, 4/26
|
- Recovery and logging (cont.)
- Performance tuning
|
14
|
4/29, 5/1
|
- Wrap-up and review
- Problem Set 5 (all) due on 4/30
- 5/2-5/3: Study period
|
15
|
|
- Final exam: Fri, 5/10, 12:00-2:00 pm
The exam must be taken at this time, so please
plan your travel accordingly!
|