Advanced Data Modeling

5 Days

What You Will Learn
This course teaches students how to create normalized databases that enforce the most important enterprise rules. Students learn how to create efficient databases that enforce data integrity. They will also learn the theory of relational databases used to implement most modern commercial databases, database performance, optimization and tuning. The course also covers the basics of ACID semantics and transactions. This level of knowledge is essential for anyone who is responsible for an enterprises data.

Course Highlights
  • Relations and attributes
  • Relational queries
  • Functional dependencies
  • The normal forms
  • Normalization through decomposition
  • Synthesis algorithm
  • Indexes and database performance
  • Caches and database performance
  • Table scans
  • Transactions and isolation levels
  • ACID semantics

This course is designed for analysts and developers with experience in E-R diagrams, data modeling and basic SQL.

This course includes: 5 days of instruction, a copy of all course slides with full written commentary, all sources to in class exercises and a two reference books selected by the instructor.

Recommended Reading

"Database: Principles, Programming, and Performance", Patrick O'Neil

About Us