Course Objectives

•           Approach database design from a systematic perspective, gather database requirements, and formulate a conceptual design.

•           Analyze and evaluate a logical database design.

•           Apply best practices for creating a physical database design.

•           Apply best practices when designing for database scalability.

•           Design a database access strategy.

•           Use best practices to model database dependencies

Prerequisites

Before attending this course, students must:

•           Have experience reading user requirements and business-need documents. For example, development project vision/mission statements or business analysis reports.

•           Have experience reading and drawing business process flow charts.

•           Have experience reading and drawing entity relationship (ER) diagrams.

•           Understand Transact-SQL syntax and programming logic.

•           Be able to design a database to 3NF and know the tradeoffs when backing out of the fully normalized design (denormalization) and designing for performance and business requirements in addition to being familiar with design models, such as Star and Snowflake schemas.

•           Have basic monitoring and troubleshooting skills.

Course Benefits

This course is intended for current professional database developers who have three or more years of on-the-job experience developing SQL Server database solutions in an enterprise environment.

Course Duration

40 Hours