CS 499-D: Advanced Database Concepts
Week Day DoW Date Ch Topic Homework
---- --- --- ---- -- ---------------------- -----------
10 20 Wed 3/18 Test
9 19 Mon 3/16 Finishing up,
Reviewing for the Final
Questionnaire
Course Evaluation
9 18 Wed 3/11 18 Database Design and Performance
8 17 Mon 3/9 Concurrency Control in Distributed Databases
Timestamp-Based Concurrency Control
8 16 Wed 3/4 13 Understanding The Query Optimizer
12 Designing Indexes for Performamnce
7 15 Mon 3/2 12 Designing Indexes for Performamnce
11 Understanding SQL Server
Storage Structures
7 14 Wed 2/25 11 Understanding SQL Server
Storage Structures
6 13 Mon 2/23 11 Understanding SQL Server
Storage Structures
10 Defining Performance Expectations
6 12 Wed 2/18 Discussion
5 11 Mon 2/16 10 Defining Performance Expectations
5 10 Wed 2/11 Test1
4 9 Mon 2/9 9 Transaction Management
4 8 Wed 2/4 8 Triggers
Stored Procedures
4 7 Mon 2/2 7 T-SQL Programming
8 Triggers
3 6 Wed 1/28 No class
3 5 Mon 1/26 7 Transact-SQL Programming Read Chapter 7
Constructs and run the
Queries
2 4 Wed 1/21 6 Creating and Altering Read Chapter 6
Database Objects Run the queries
in the handout
2 3 Wed 1/14 4 Introduction to Transact-SQL Run the queries
5 Transact-SQL Datatypes in the handout
Read Chapter 5
1 2 Mon 1/12 4 Introduction to Transact-SQL Run the queries
in the handout
Read Chapter 4
1 1 Wed 1/7 Class Introduction
Syllabus
Last update March 10, 1998.