Agile Data Site Map AgileData.org: Techniques for Disciplined Agile Database Development
Home  |  Agile DBAs  |  Developers  |  Enterprise Architects  |  Enterprise Administrators  |  Best Practices  |  Agility@Scale Blog  |  Announcements  |  Contact Us

Table of Contents

• Best Practices
• Fundamental Knowledge
• Fundamental Skills
• People
• Process
• Technology
• Other

Best Practices

• Agile data modeling
• Agile database best practices (an overview)
• Configuration management of database assets
• Database refactoring
• Data normalization
• Encapsulating database access
• Sandboxes
• Test-driven development (TDD)

Fundamental Knowledge

• Choosing a Primary Key: Natural or Surrogate?
• Data modeling 101
• Data models don't drive object models (and vice versa)
• Object orientation 101
• Relational databases 101
• Working with legacy data
• XML

Fundamental Skills

• Best practices for retrieving objects from an RDB
• Encapsulating database access
• Implementing referential integrity and shared business logic
• Implementing reports
• Implementing security access control
• Implementing transactions and concurrency control
• Mapping objects to RDBs (O/R mapping)

People

• Cultural impedance mismatch
• Enterprise administration -- e.g. Operational DBAs
• Enterprise architecture

  • Architecture and Architectural Modeling Techniques 

• Roles

Process

• Agile Best Practices for Data Warehouse (DW)/Business Intelligence (BI) Projects
• Agile Data method

  • Adoption

  • Philosophies
  • Roles
• Agile Master Data Management (MDM)
• Case studies and experience reports

• Choosing the right software method for the job

• Data and the Rational Unified Process (RUP)
• Evolutionary database development

Technology

• Object/relational impedance mismatch
• Tools

Other

• Agile Databases Mailing List
• Becoming more agile
• Links Page
• On Relational Theory
• The "One Truth Above All Else" Anti-Pattern
• Training Workshops