|
DESIGNING DATA SERVICES AND DATA MODELS
Introduction
This three day instructor led 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.
At Course Completion
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.
Microsoft Certified Professional Exams
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
Prerequisites
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
Course Outline
Day 1
Module 1: Course Overview
Topics:
- Business Solutions Design Curriculum
- Overview of This Course
- Lab:
- Categorizing existing Information
Skills:
- Students will be able to:
- Describe how the course fits into the entire Business
Solutions Design Curriculum.
- Describe how you will use the case study to apply the
principles you will learn in the course.
Module 2: Solution Design Processes
Topics:
- Design Processes
- Services-Based Design
- Labs:
Skills:
- Students will be able to:
- Explain design processes as they pertain to business
solutions and data-centric solutions.
- Explain the concepts and benefits of services-based
design.
- Identify phases in the project life cycle.
Module 3: Using a Conceptual Design for Data Requirements
Topics:
- Investigation Process
- Data Requirements
- Labs:
- Identifying Data-Related Use Cases and Data Requirements
- Relating Data Requirements to Conceptual Design
Skills:
- Students will be able to:
- Describe the information investigation process.
- Determine functional data requirement from use cases.
-
Identify non-functional requirements that will affect a solution's
design.
Day 2
Module 4: Deriving a Logical Data Design
Topics:
- Logical Data Design
- Entities and Attributes
- Data Relationships
- Entity/Relationship Modeling
- Labs:
- Deriving entities and attributes from data requirements
- Creating a logical data model
Skills:
- Students will be able to:
- Analyze data requirements to determine data entities
and attributes.
- Analyze data entities and attributes to determine their
relationships.
- Determine the cardinality and existence characteristics
of a relationship.
- Create an entity/relationship diagram.
Module 5: Normalizing the Logical Data Design
Topics:
- Implementing Entity Relationships
- Normalization Basics
- Labs:
- Identifying keys in the logical model
- Normalizing data
Skills:
- Students will be able to:
- Use primary and foreign keys to implement relationships
between entities.
- Explain the benefits of normalizing entities.
- Normalize a table to third normal form.
Module 6: : Deriving a Physical Data Design
Topics:
- Physical Data Design
- Implementing Relationships
- Data Optimization Techniques
- Labs:
- Translating the logical data design
- Optimizing a physical data design
Skills:
- Students will be able to:
- Derive a physical data design for tables and fields
from a logical data design.
- Analyze data usage characteristics to optimize a physical
data design.
- Determine methods for implementing relationships in
a physical data design.
- Identify different optimization techniques.
- Determine the proper criteria for optimizing a physical
data design.
Day 3
Module 7: Implementing Data Integrity
Topics:
- Overview of Data Integrity
- Implementing Data Integrity Requirements
- Lab:
- Identifying data integrity requirements
- Determining data integrity implementations
Skills:
- Students will be able to:
- Identify business rules that relate to data integrity.
- Identify the data integrity requirement type to which
a business rule applies.
- Evaluate and determine a location for implementing data
integrity.
- List implementation techniques for a given data integrity
requirement.
Module 8: Designing Data Services
Topics:
- Overview of Data Services
- Accessing Relational Data
- Accessing Host-based Systems
- Lab:
- Selecting data access technologies
Skills:
- Students will be able to:
- Determine the role of data services for a business solution.
- Describe considerations for distributing data access
technologies.
- List the primary considerations for choosing a data
access technology.
- List and describe Microsoft's primary data access technologies.
- Determine the appropriate data access technology for a business
solution.
Module 9: Data Storage Considerations
Topics:
- Choosing a Database Product
- Data Storage Technologies
- Data Storage Considerations
- Lab:
Skills:
- Students will be able to:
- Identify different types of hardware and software technologies
for implementing a data store.
- Choose the appropriate of hardware and software technologies
for implementing a data store.
Inclusive to the overall costs of this Microsoft training
course is equipment, training material, lunch and refreshments.
Booking Information
Courses are offered on the availability of students. If you are interested in one of these courses then please click on the e-mail link:
(Please specify the course in your email enquiry)
Back to Top
|
