Back to Search Results

Training Course Summary:

This workshop teaches students to analyze business requirements to determine data storage and data access requirements. Participants will learn to design data models and the data layer of a Microsoft Windows® DNA architecture, and select the appropriate Microsoft technologies.

Pre-Requisites:

Before attending this course, students must be able to demonstrate the following:

A general understanding of the software development life cycle
A general understanding of relational database management systems
A general understanding of the process of gathering and analyzing business requirements
Recommended course:

Course 1585, Gathering and Analyzing Business Requirements

Training Course Overview/Content:

At the end of the course, students will be able to:

Derive conceptual data requirements from business requirements.
Develop entity/relationship (ER) models.
Normalize a logical data model.
Create an optimized physical data model.
Select the appropriate type and location of data integrity requirements to implement, given a set of constraints.
Select appropriate data access and data storage technologies for a solution.

Qualifications:

This course will help the student prepare for the following Microsoft Certified Professional (MCP) exam(s):

Exam 70-100, Analyzing Requirements and Defining Solution Architectures