DA 204 – Agile Database Techniques: With Discipline

Data is clearly an important aspect of software-based systems, a fact that the information technology (IT) industry has understood for decades, yet many agile development teams are still struggling to involve data professionals within their projects. Until now.

In this workshop participants learn how to take an agile approach to data activities on an agile project, exploring how approaches such as agile data modeling, database refactoring, and database testing fit together to enable agile database development. The workshop also overviews how to take an agile approach to datawarehouse development, data administration, and data management (including Master Data Management (MDM)).


Audience

  • Agile developers wanting to improve their approach to database development
  • Existing database administrators (DBAs) wanting to gain fundamental agile database skills
  • Existing data architects or data managers wanting to gain a better understanding of how data activities fit into a disciplined agile delivery project

Benefits

  • Learn how to take an agile approach to database development
  • Discover strategies to significantly reduce database development effort as compared with traditional approaches
  • Learn how to improve data quality in a safe and proven manner
  • See how disciplined agile teams and enterprise data teams can work together in an effective manner

Outline

  • The Agile Data (AD) method
  • Challenges with an agile approach to data
  • Data activities through the agile lifecycle
  • Agile data architecture
  • Agile data modeling
  • Database refactoring
  • Database testing
  • Continuous database integration
  • Database encapsulation strategies
  • Agile strategies for data warehousing(DW)/business intelligence (BI)
  • Agile enterprise data administration and management
  • Where to go from here

Workshop Logistics

  • Level: Medium
  • Length: One day – 7 hours of classroom time plus breaks.
  • Approach: For each major topic in the agenda there will be instruction followed by group work.
  • Prerequisites: A basic understanding of Disciplined Agile (DA) and Agile Model Driven Development (AMDD) is very useful. See DA 101: The Disciplined Agile Experience Workshop and DA 102: Introduction to Agile Model Driven Development (AMDD) respectively.
  • Class size: Ideally 10 to 15, although up to 20 if the room allows.
  • Classroom requirements: For the students a table layout is preferred. Ideally there should be tables of 4-6 people with sufficient space between them so that students can easily move about the room. For the instructor a screen, projector, and writing space (whiteboards or flipcharts).

Delivery Considerations

  • This workshop is typically delivered as an addition to DA 101: The Disciplined Agile Experience Workshop so as to give students a greater understanding of agile database techniques.