CS 499-D Lecture Outline

  1. Database Design and Performance (Chapter 18)

  2. Concurrency Control in Distributed Databases

  3. Timestamp-Based Concurrency Control

  4. Understanding the Query Optimizer (Chapter 13)

  5. Designing Indexes for Performance (Chapter 12)

  6. Understanding SQL Server Storage Structures (Chapter 11)

  7. Defining Performance Expectations (Chapter 10)

  8. Transaction Management (Chapter 9)

  9. Stored Procedures(Chapter 8)

  10. Triggers(Chapter 8)

  11. Transact-SQL Programming Constructs(Chapter 7)

  12. Creating and Altering Database Objects(Chapter 6)

  13. Transact-SQL Datatypes (Chapter 5)

  14. Introduction to Transact-SQL (Chapter 4-B)

  15. Introduction to Transact-SQL (Chapter 4-A)

Last update March 10, 1998.