NOT IN cat3_submenu table
SQL Server 2008 Certification | 50401a: SQL Server 2008: Database Solutions
Print this page

Sql Server 2008 Certification

Designing and Optimising Database Solutions with Microsoft SQL Server 2008

A Five-Day Training Course

Course Content

Authorised Microsoft Training Course

This is an authorised Microsoft training course, delivered by certified Microsoft trainers at fully equipped centres using the latest equipment, software and course materials. There is no better way to undertake your training, to maximise your learning and ensure the highest marks possible in your certification exams.

Course Aims

This five-day instructor-led course provides the knowledge and skills that IT Professionals need to design, optimize, and maintain SQL Server 2008 database.

Who Should Attend

The audience of this course is developers who implement database solutions or perform development utilizing the programming features and functionality of SQL Server.
Students taking this course are expected to have three or more years of experience working on databases for two or more of the following phases in the product lifecycle - design, development, deployment, optimization, maintenance, or support.
They should possess a four-year college degree, BS or BA, in the computer field.
Delegates should have experience in the following areas:

  • Developing databases
  • Writing Transact-SQL queries
  • Designing, implementing and troubleshooting programming objects
  • Doing database performance tuning and optimization
  • Designing databases at both the conceptual and logical levels
  • Implementing databases at the physical level
  • Designing and troubleshooting the data access layer of an application
  • Gathering business requirements

In addition, it is recommended, but not required, that students have completed:

  • Course 2779, Implementing a Microsoft SQL Server 2005 Database
  • Course 2780, Maintaining a Microsoft SQL Server 2005 Database

Course Outline

Module 1: Designing a Conceptual Database Model
Lab : Designing a Conceptual Database Model
Module 2: Designing a Logical Database Model
Lab : Designing a Logical Database Model
Module 3: Designing a Physical Database Model
Lab : Designing a Physical Database Model
Module 4: Designing Databases for Optimal Performance
Lab : Designing Databases for Optimal Performance
Module 5: Designing Security for SQL Server 2008
Lab : Designing Security for SQL Server 2008
Module 6: Designing a Strategy for Database Access
Lab : Designing a Strategy for Database Access
Module 7: Designing Queries for Optimal Performance
Lab : Designing Queries for Optimal Performance
Module 8: Designing a Transaction and Concurrency Strategy
Lab : Designing a Transaction and Concurrency Strategy
Module 9: Designing an XML Strategy
Lab : Designing an XML Strategy
Module 10: Designing SQL Server 2008 Components
Lab : Designing SQL Server 2008 Components

Course Objectives

After completing this course, delegates will be able to:

  • Design a database design strategy
  • Design a database for optimal performance
  • Design security for a database
  • Design programming objects
  • Design queries for performance
  • Design a transaction and concurrency strategy
  • Design an XML strategy

Certification

Microsoft Course 50401A

Print this page
Activia Training :   Training courses for business at seventeen locations UK wide