• Home
• Course Catalogue
• Certifications
• Onsite Training
• Scheduled Training
• E-Learning
• Managed Services
• Consulting
• Company
• Special Offers
• News
• Links
• Enquiry And Feedback Form

Training Course Outline

IT Vendor Courses   Microsoft SQL Server Training Courses

M1609: Designing Data Services and Data Models

View course dates

Course Duration: 3 days

Course Code: M1609

Course Description:

This course teaches students to analyse 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.

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

This course includes the following modules:

Course Overview

• Business Solutions Design Curriculum
• Overview of This Course
• Activity
• Categorizing existing Information

Solution Design Processes

• Design Processes
• Services-Based Design
• Activity
• Identifying Services

Using a Conceptual Design for Data Requirements

• Investigation Process
• Data Requirements
• Activities
• Identifying Data-Related Use Cases and Data Requirements
• Relating Data Requirements to Conceptual Design Skills

Deriving a Logical Data Design

• Logical Data Design
• Entities and Attributes
• Data Relationships
• Entity/Relationship Modeling
• Activities
• Deriving entities and attributes from data requirements
• Creating a logical data model

Normalizing the Logical Data Design

• plementing Entity Relationships
• Normalization Basics
• Activities
• Identifying keys in the logical model
• Normalizing data

Deriving a Physical Data Design

• Physical Data Design
• Implementing Relationships
• Data Optimization Techniques
• Activities
• Translating the logical data design
• Optimizing a physical data design

Implementing Data Integrity

• Overview of Data Integrity
• Implementing Data Integrity Requirements
• Activities
• Identifying data integrity requirements
• Determining data integrity implementations

Designing Data Services

• Overview of Data Services
• Accessing Relational Data
• Accessing Host-based Systems
• Activities
• Selecting data access technologies

Data Storage Considerations

• Choosing a Database Product
• Data Storage Technologies
• Data Storage Considerations
• Activity
• Data quiz

 

To make an enquiry for this course to be run ONSITE at your location, click here or call Sales on +44 (0) 20 7620 0033.

Perpetual Solutions are a global provider of onsite training solutions throughout London, UK and the rest of the world. For scheduled training our UK partner network provides an unrivalled choice of courses.

Save as PDF

Print this course