A Small Class Size is the Best Learning Environment*
Only F1 has no more than 6 Delegates in a Class
Everyone has Individual Attention from the Trainer

View Recent History

Course:(8911) Installation and Deployment in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2552) Designing, Planning, and Managing a Windows SharePoint Services Infrastructure - Microsoft Training Courses in London and South West
Course:(F1024) What's New in Microsoft CRM 3.0 - Applications - Microsoft Training Courses in London and South West
Course:(2732) Planning Deploying and Managing an Enterprise Project Management Solution - Microsoft Training Courses in London and South West
Course:(2505) Deploying Microsoft Office XP - Microsoft Training Courses in London and South West
indexes/Certification_courses_index.aspx Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2289) Deploying Business Desktops with Microsoft Windows XP and Microsoft Office 2003 - Microsoft Training Courses in London and South West
Course:(2830) Designing Security for Microsoft Networks - Microsoft Training Courses in London and South West
Course:(80054) Project Managing Microsoft Dynamics CRM Implementations with Microsoft Dynamics Sure Step - Microsoft Training Courses in London and South West
Course:(F1008) Developer Reskilling: Visual FoxPro to Visual Basic - Microsoft Training Courses in London and South West
Course:(2073) Programming a Microsoft SQL Server 2000 Database - Microsoft Training Courses in London and South West
Course:(F1002) Visual FoxPro 6.0 Enterprise - Microsoft Training Courses in London and South West
Course:(5060) Implementing Windows SharePoint Services 3.0 - Microsoft Training Courses in London and South West
Course:(8529) Microsoft CRM 3.0 Administration - Microsoft Training Courses in London and South West
Course:(2030) Creating Reporting Solutions using Microsoft SQL Server 2000 Reporting Services - Microsoft Training Courses in London and South West
Course:(50046) Introduction to Development Using Windows SharePoint Services 3.0 - Microsoft Training Courses in London and South West
Course:(2731) Deploying and Managing Microsoft Identity Integration Server (MIIS) 2003 - Microsoft Training Courses in London and South West
Course:(4009) Setting Up Projects for Success Using Microsoft Office Project 2003 - Microsoft Training Courses in London and South West
Course:(50354) Microsoft SharePoint 2010 SharePoint Designer - Microsoft Training Courses in London and South West
Course:(8522) Microsoft CRM 3.0 Marketing Automation - Microsoft Training Courses in London and South West
Course:(2553) Designing, Planning, and Managing a SharePoint Portal Server 2003 Infrastructure - Microsoft Training Courses in London and South West
Course:(2723) Microsoft SQL Server 2000 for Experienced Database Professionals - Microsoft Training Courses in London and South West
Course:(F1028) Introduction to Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(2591) Implementing Replication Using Microsoft SQL Server 2000 - Microsoft Training Courses in London and South West
Course:(F1023) What's New in Microsoft CRM 3.0 - Technical - Microsoft Training Courses in London and South West
Course:(1131) SQL Server 7.0 Upgrade and Migration - Microsoft Training Courses in London and South West
Course:(6294) Planning and Managing Windows 7 Desktop Deployments and Environments - Microsoft Training Courses in London and South West
Course:(2093) Implementing Business Logic with MDX in Microsoft SQL Server 2000 - Microsoft Training Courses in London and South West
Course:(2071) Querying Microsoft SQL Server 2000 with Transact-SQL. - Microsoft Training Courses in London and South West
Exchange Server 2010 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(5179) Implementing and Maintaining Telephony Using Microsoft Office Communications Server 2007 - Microsoft Training Courses in London and South West
Course:(8526) Microsoft CRM 3.0 Installation and Configuration - Microsoft Training Courses in London and South West
Visual Studio 2008 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2840) Implementing Security for Applications - Microsoft Training Courses in London and South West
Course:(2074) Designing and Implementing OLAP Solutions with Microsoft SQL Server 2000 - Microsoft Training Courses in London and South West
Course:(4005) Beyond the Spreadsheet: Managing Financial Information Using Microsoft Office Access 2003 - Microsoft Training Courses in London and South West
Course:(5061) Implementing Microsoft Office SharePoint Server 2007 - Microsoft Training Courses in London and South West
Course:(50051) Architecting Microsoft Office SharePoint Server 2007 Portals and Collaboration Solutions - Microsoft Training Courses in London and South West
Course:(80003) Workflow in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Visual Basic .NET Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(5928) Managing Projects Using Microsoft Office Project Server 2007 - Microsoft Training Courses in London and South West
Course:(50050) Architecting Documents and Records Management Solutions with Microsoft Office SharePoint 2007 - Microsoft Training Courses in London and South West
Course:(5056) First Look: Windows Vista for IT Professionals - Microsoft Training Courses in London and South West
Course:(80002) Administration in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2015) Enabling Business Processes using XML Smart Documents and Smart Solutions within the Microsoft Office System - Microsoft Training Courses in London and South West
Visual Studio .NET Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8524) Microsoft CRM 3.0 Service Scheduling - Microsoft Training Courses in London and South West
Course:(1634) Accelerated Training for Microsoft SQL Server 7.0 - Microsoft Training Courses in London and South West
Course:(5929) Managing Projects and Programs Using Microsoft Office Project Server 2007 - Microsoft Training Courses in London and South West
Course:(2297) Planning Implementing Managing and Maintaining a Microsoft Windows Server 2003 Environment for an MCSE on Windows 2000 - Microsoft Training Courses in London and South West
Application Architecture Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(F1032) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Power User in 3 Days Flat! - Microsoft Training Courses in London and South West
Course:(50049) Architecting Web Content Management Solutions with Microsoft Office SharePoint 2007 - Microsoft Training Courses in London and South West
Course:(1609) Designing Data Services and Data Models - Microsoft Training Courses in London and South West
Course:(8912) Customisation and Configuration in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2014) Customizing Microsoft Office SharePoint Portal Server 2003 - Microsoft Training Courses in London and South West
Course:(4002) Forecasting and Trend Analysis Using Microsoft Office Excel 2003 - Microsoft Training Courses in London and South West
Course:(2151) Microsoft Windows 2000 Network and Operating System Essentials - Microsoft Training Courses in London and South West
Windows Server 2008 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8913) Applications in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2092) Populating a Data Warehouse with Microsoft SQL Server 2000 Data Transformation Services - Microsoft Training Courses in London and South West
Course:(8521) Microsoft CRM 3.0 Sales Management - Microsoft Training Courses in London and South West
Course:(F1033) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Developer in 5 Days Flat! - Microsoft Training Courses in London and South West
Course:(F1004) FoxPro 2.6 Intensive - Microsoft Training Courses in London and South West
Course:(4008) Building Better Microsoft Office Word 2003 Documents in Less Time - Microsoft Training Courses in London and South West
Course:(6064) Planning, Implementing, and Managing Windows Mobile 6 - Microsoft Training Courses in London and South West
Course:(8530) Microsoft CRM 3.0 Data Migration - Microsoft Training Courses in London and South West
Course:(6292) Installing and Configuring Windows 7 Client - Microsoft Training Courses in London and South West
Course:(6438) Implementing and Administering Windows SharePoint Services 3.0 in Windows Server 2008 - Microsoft Training Courses in London and South West
Course:(8525) Microsoft CRM 3.0 Customization - Microsoft Training Courses in London and South West
Course:(6289) First Look: Windows 7 Beta for IT Professionals - Clinic & Hands-on Lab - Microsoft Training Courses in London and South West
Course:(80141) Integrating Microsoft Dynamics CRM 4.0 and Microsoft Office SharePoint Server 2007 - Microsoft Training Courses in London and South West
Course:(50219) Introduction to Microsoft Windows 7 for Developers - Microsoft Training Courses in London and South West
Course:(6291) Updating Your Technology Knowledge of Microsoft Windows XP to Windows 7 Beta - Microsoft Training Courses in London and South West
Course:(5058) Deploying Microsoft Office 2007 Professional Plus - Microsoft Training Courses in London and South West
Course:(3370) First Look: Getting Started with Microsoft Office SharePoint Server 2007 - Microsoft Training Courses in London and South West
Course:(6067) Developing Native Applications for Microsoft Windows Mobile 6 - Microsoft Training Courses in London and South West
Course:(2554) Designing, Planning, and Managing a Windows SharePoint Services and SharePoint Portal Server 2003 Infrastructure - Microsoft Training Courses in London and South West
Course:(2299) Managing and Maintaining a Microsoft Windows Server 2003 Environment for an MCSA on Windows 2000 - Microsoft Training Courses in London and South West
Course:(50429) Microsoft SharePoint 2010 Business Intelligence - Microsoft Training Courses in London and South West
Course:(8910) What's New in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2013) Optimizing Microsoft SQL Server 7.0 - Microsoft Training Courses in London and South West
Course:(2810) Fundamentals of Network Security - Microsoft Training Courses in London and South West
Course:(6066) Developing Managed Applications for Microsoft Windows Mobile 6 - Microsoft Training Courses in London and South West
Course:(1140) Microsoft SQL Server 7.0 Overview - Microsoft Training Courses in London and South West
Course:(8036) Designing IT Platform Collaborative Applications with Microsoft SharePoint 2003 Workshop - Microsoft Training Courses in London and South West
Course:(F1030) Advanced Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(4003) Summarizing Microsoft Office Excel 2003 Data to Make Better Business Decisions - Microsoft Training Courses in London and South West
Visual Studio 2010 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2439) Scripting Microsoft Windows Management Instrumentation - Microsoft Training Courses in London and South West
Course:(2088) Designing a Highly Available Web Infrastructure (IIS) - Microsoft Training Courses in London and South West
Course:(5178) Implementing and Maintaining Audio/Visual Conferencing and Web Conferencing Using Microsoft Office Communications Server 2007 - Microsoft Training Courses in London and South West
Course:(2264) Exam Preparation for the MCDST Certification - Microsoft Training Courses in London and South West
Course:(2381) Planning Collaborative Solutions With Microsoft Office XP Technologies - Microsoft Training Courses in London and South West
Course:(3374) First Look: First Look: Getting Started with Microsoft Office 2007 SharePoint Server Hands-On Lab - Microsoft Training Courses in London and South West
Systems Management Server Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8879) Using the Microsoft Dynamics Sure Step Methodology for Microsoft Dynamics CRM - Microsoft Training Courses in London and South West
Course:(F1034) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Expert in 7 Days Flat! - Microsoft Training Courses in London and South West
Office (inc SharePoint) Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(10175) Microsoft SharePoint 2010, Application Development - Microsoft Training Courses in London and South West
Course:(2657) Programming Microsoft Access 2002 - Microsoft Training Courses in London and South West
Course:(4006) Time and Task Management Using Microsoft Office Outlook 2003 - Microsoft Training Courses in London and South West
Course:(F1037) Customisation of xRM/CRM for Microsoft Partners and Customers - Microsoft Training Courses in London and South West
Application Centre Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(6331) Deploying and Managing Microsoft System Center Virtual Machine Manager - Microsoft Training Courses in London and South West
Visual Basic 6.0 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(7197) Managing Enterprise Desktops Using the Microsoft Desktop Optimization Pack - Microsoft Training Courses in London and South West
Visual Studio 2005 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8969) Extending Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2300) Developing Security-Enhanced Web Applications - Microsoft Training Courses in London and South West
Course:(2016) Bringing Data into Desktop Programs using the Microsoft Office 2003 Editions Research and Reference Technologies - Microsoft Training Courses in London and South West
Course:(F1029) Intermediate Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(6290) First Look: Windows 7 Beta for IT Professionals - Hands-on Lab - Microsoft Training Courses in London and South West
Course:(3373) First Look: Getting Started with Windows SharePoint Services 3.0 Hands-On Lab - Microsoft Training Courses in London and South West
Mobile Internet Toolkit Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(4004) Managing Critical Business Information Using Microsoft Office Access 2003 - Microsoft Training Courses in London and South West
Course:(2091) Building XML-Enabled Applications Using Microsoft SQL Server 2000 - Microsoft Training Courses in London and South West
Course:(2052) Using Microsoft Visual Studio Tools for the Microsoft Office System - Microsoft Training Courses in London and South West
Course:(4001) Team Collaboration Using Microsoft Windows SharePoint Services - Microsoft Training Courses in London and South West
Course:(50352) Microsoft SharePoint 2010 Overview for End Users - Microsoft Training Courses in London and South West
Course:(50218) Microsoft Windows 7 Training for Developers - Microsoft Training Courses in London and South West
Course:(5927) Managing Projects Using Microsoft Office Project 2007 - Microsoft Training Courses in London and South West
Course:(10174) Configuring and Managing Microsoft SharePoint 2010 - Microsoft Training Courses in London and South West
Course:(5177) Implementing and Maintaining Instant Messaging Using Microsoft Office Communications Server 2007 - Microsoft Training Courses in London and South West
Course:(2433) Microsoft Visual Basic Scripting Edition and Microsoft Windows Script Host Essentials - Microsoft Training Courses in London and South West
NET Framework Development Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8531) Extending Microsoft CRM 3.0 - Microsoft Training Courses in London and South West
Course:(F1001) Visual FoxPro 6.0 Intensive - Microsoft Training Courses in London and South West
Course:(80047) Using Microsoft Dynamics Sure Step - Microsoft Training Courses in London and South West
Course:(F1035) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Guru in 10 Days Flat! - Microsoft Training Courses in London and South West
Course:(3087) First Look: Microsoft Windows Vista for Developers - Microsoft Training Courses in London and South West
Knowledge Management Training Course Index - F1Computing Microsoft Training Courses London South West UK
Microsoft Dynamics CRM Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2018) Creating and Customizing Team Folders - Microsoft Training Courses in London and South West
Visual Studio 6.0 Training Course Index - F1Computing Microsoft Training Courses London South West UK

Compare Recently Viewed Course Dates


Exclusive
Architecture

Designing Data Services and Data Models
(Microsoft Training Course: 1609) - 3 days - £1700 exc VAT

We currently do not have any dates scheduled for this course.
Please contact us to arrange a closed course for your company or add your details to courses in waiting.
(Remember F1 has smaller classes)
Ask a Question ?Print 2 Page PDF


> Target Audience
THIS COURSE HAS NOW RETIRED. PLEASE SEE THE SUPPLEMENTARY INFORMATION FOR DETAILS OF ALTERNATIVE COURSES.
This course teaches students to analyze business requirements to determine data storage and data access requirements.
> Course outline
  1. Course Overview
  2. Solution Design Processes
  3. Using a Conceptual Design for Data Requirements
  4. Deriving a Logical Data Design
  5. Normalising the Logical Data Design
  6. Deriving a Physical Data Design
  7. Implementing Data Integrity
  8. Designing Data Services
  9. Data Storage Considerations
Supplementary Information This course has now retired and is no longer available. We suggest you look at Courses 1846: Microsoft Solutions Framework Essentials and 2710: Analyzing Requirements and Defining Microsoft .NET Solution Architectures.
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
> Pre-Requisites
Before attending this course, students must have the following pre-requistes:
  • 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 analysing business requirements.
  • It is recommended that students have attended Course 1585, Gathering and Analysing Business Requirements or have equivalent experience and knowledge.
> Purpose
At the end of the course, students will be able to gather information about business processes, challenges, and vision; determine business and user requirements; model existing business processes; analyse business requirements in the context of the business environment; and build a vision document.
> Supplementary Information
This course has now retired and is no longer available. We suggest you look at Courses 1846: Microsoft Solutions Framework Essentials and 2710: Analyzing Requirements and Defining Microsoft .NET Solution Architectures.
> EXAMS
There are no exams directly associated with this course