Relational Database Design and Data Modeling

This 5 day database design training class can be customized based on the students’ experience working with and building databases.

It is based heavily on Data Modeling, A Beginner’s Guide by Andy Oppel and Data Modeling Essentials by Graeme Simsion and Graham Witt.  Both books are included with the course.

1. Data Modeling Concepts
   1. Introduction to Data Modeling
   2. Relational Database Components
   3. Data and Process Modeling
   4. Organizing Database Project Work
2. Data Modeling Details
   1. Conceptual Data Modeling
   2. Logical Database Design Using Normalization
   3. Beyond Third Normal Form
   4. Physical Database Design
3. Design Alternatives
   1. Alternatives for Incorporating Business Rules
   2. Alternatives for Handling Temporal Data
   3. Modeling for Analytical Databases
   4. Enterprise Data Modeling