 |
 |
|
|
|
 Technical Training - Designing Data
Services and Data Models Course
No: M1609 Course Length: 3 Days |
| Who
Should Attend: This
course has been designed to help delegates to analyse business requirements
to determine data storage and data access requirements. |
Pre-Requisites:
Delegates 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
|
Topics
Covered:
- Solution Design
Process
- Normalising the
Logical Data Design
- Implementing Data
Integrity
- Designing Data
Services
- Data Storage Considerations
|
|
|
|
|
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
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 |
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
Implementing
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
Data Storage Considerations
Choosing a
Database Product
Data Storage Technologies
Data Storage Considerations
Activity
Data quiz |
|
|
 |
|
Desktop Courses