|
|
|
Module 1: Course Overview
- Business Solutions Design Curriculum
- Overview of This Course
Skills
- 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.
Top |
|
Module 2: Solution Design Processes
- Design Processes
- Services-Based Design
Skills
- 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.
Top |
|
|
Module 3: Using a Conceptual Design for Data Requirements
- Investigation Process
- Data Requirements
Skills
- Describe the information investigation process.
- Determine functional data requirement from use cases.
- Identify non-functional requirements that will affect a solution’s design.
- Identify data-related use cases and data requirements
- Relate data requirements to conceptual design
Top |
|
Module 4: Deriving a Logical Data Design
- Logical Data Design
- Entities and Attributes
- Data Relationship
- Entity/Relationship Modelling
Skills
- Analyse data requirements to determine data entities and attributes.
- Analyse data entities and attributes to determine their relationships.
- Determine the cardinality and existence characteristics of a relationship.
- Identify entity and attributes from data requirements.
- Create an entity/relationship diagram.
- Creating a logical data model.
Top |
|
|
Module 5: Normalising the Logical Data Design
- Implementing Entity Relationships
- Normalisation Basics
Skills
- Use primary and foreign keys to implement relationships between entities.
- Explain the benefits of normalising entities.
- Identify keys in the logical model
- Normalise a table to third normal form.
Top |
|
Module 6: Deriving a Physical Data Design
- Physical Data Design
- Implementing Relationships
- Data Optimisation Techniques
Skills
- Translate the logical data design to derive a physical data design for tables and fields.
- Analyse data usage characteristics to optimise a physical data design.
- Determine methods for implementing relationships in a physical data design.
- Identify different optimisation techniques.
- Determine the proper criteria for optimising a physical data design.
Top |
|
|
Module 7: Implementing Data Integrity
- Overview of Data Integrity
- Implementing Data Integrity Requirements
Skills
- 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.
Top |
|
Module 8: Designing Data Services
- Overview of Data Services
- Accessing Relational Data
- Accessing Host-based Systems
Skills
- 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.
Top |
|
|
Module 9: Data Storage Considerations
- Choosing a Database Product
- Data Storage Technologies
- Data Storage Considerations
Skills
- 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.
Top |
|
|
|
|
Exams:
-
There are no exams directly associated with this course
|
|
Price Options ex VAT:
Classroom Training
? |
Distance Learning
? |
eLearning Options
? |
Book Learning
? |
£
1185
(€1683)
|
£
674.00
(€957)
|
- |
No Books Supported for Course at present
|
|
|
Call Free on 0800 169 1890
Print 2 Page Flyer
Last Modified 01 May 2008
|
|
