| Outline:
Lesson 1: Approaching Database Design Systematically
Overview of Database Design
Gathering Database Requirements
Creating a Conceptual Database Design
Lesson 2: Modeling a Database at the Logical Level
Building a Logical Database Model
Designing for OLTP Activity
Designing for Data Warehousing
Evaluating Logical Models
Lesson 3: Modeling a Database at the Physical Level
Designing Physical Database Objects
Designing Constraints
Designing for Database Security
Designing Server and Database Options
Evaluating the Physical Model
Lesson 4: Designing for Database Performance
Designing Indexes
Planning for Table Optimization
Planning for Database Optimization
Lesson 5: Designing a Database Access Strategy
Designing for Secure Data Access
Designing User-Defined Functions
Designing Stored Procedures
Lesson 6: Modeling Database Dependencies
Modeling Local Database Dependencies
Modeling Remote Database Dependencies
|