CS 499 Lecture Outline

  1. Triggers and Stores Procedures - SQL Chapter 8

  2. T-SQL Programming Constructs - SQL Chapter 7

  3. Creating and Altering Database Objects - SQL Chapter 6

  4. Transact-SQL Datatypes - SQL Chapter 5

  5. Introduction to Transact-SQL- SQL Chapter 4

  6. SQL- A Relational Database Language- Chapter 7

  7. Design Guidelines,Functional Dependencies, and Normalization- Chapter 12

  8. The Relational Data Model and Relational Algebra- Chapter 6

  9. Storage Devices, Blocks, Buffers, and File Organizations- Chapter 4

  10. Data Modeling Using the Entity-Relationship Model - Chapter 3

  11. Database System Concepts and Architecture - Chapter 2

  12. Databases and Database Users - Chapter 1

Last update May 13, 1998.