Agile Data Base Design Techniques

    

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 published on October 17, 2003 by John Wiley, ISBN: 0471202837.

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 L’Evolution
• 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

Prerequisites:
Students should have experience designing databases and data warehouses. Knowledge of Agile design techniques is helpful.

Last Update: May 20, 2013