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.
- 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.
"Database: Principles, Programming, and Performance", Patrick O'Neil