Agile Database Design Techniques

PT6826
Summary
This course provides students with the skills necessary to design databases using Agile design techniques. It is based on the Scott Ambler book Agile Database Techniques: Effective Strategies for the Agile Software Developer by John Wiley, ISBN: 0471202837.
Prerequisites
Students should have experience designing databases and data warehouses. Knowledge of Agile design techniques is helpful.
Duration
5 Days/Lecture & Lab
Audience
This course is targeted at database designers, data modelers, database analysts, and anyone who needs to design databases.
Topics
  • The Agile Data Method
  • From Use Cases to Databases Real-World UML
  • Data Modeling 101
  • Data Normalization
  • Class Normalization
  • Relational Database Technology, Like It, Or Not
  • The Object-Relational Impedance Mismatch
  • Legacy Databases Everything You Need to Know But Are Afraid to Deal With
  • Vive LEvolution
  • Agile Model-Driven Development (AMDD)
  • Test-Driven Development (TDD)
  • Database Refactoring
  • Database Encapsulation Strategies
  • Mapping Objects to Relational Databases
  • Performance Tuning
  • Tools for Evolutionary Database Development
  • Implementing Concurrency Control
  • Finding Objects in Relational Databases
  • Implementing Referential Integrity and Shared Business
  • Implementing Concurrency Control
  • Finding Objects in Relational Databases
  • Implementing Referential Integrity and Shared Business Logic
  • Implementing Security Access Control
  • Implementing Reports
  • Realistic XML
  • How You Can Become Agile
  • Bringing Agility Into Your Organization

Related Scheduled Courses