In this workshop, attendees will get hands-on with data model-driven database development from the point of view of the Data Architect and DBA. In Model-Driven development, we leverage both native and third-party tools to deliver formal and flexible database designs, using agile and modern development approaches.

We will address questions like "Who does what?", "Why are we doing this?", "Why is this better

and "What's the best way to do this?".

This workshop will include:

• Data Modeling Overview
• Database Design Concepts
• Physical Database Design
• Key & Constraints
• Indexes
• Performance Enhancements Inside the Database
• New and Advanced Features in SQL Server 2016
• Forward and Reverse Engineering
• Design Validation Techniques
• Working with Multiple DBMSs
• Real world Change Management
• Modern Database Design Processes
• Tips and Tricks for Making it all Work & Keeping your Team Happy

Karen Lopez has more than 20 years of database design experience. She specializes in the practical application of design approaches, balancing development time frames with the need to deliver solutions that will support business agility and data quality needs. She is a frequent user group and conference speaker and is a chronic volunteer.