You are here:Courses|Microsoft|MCITP Certification|MCITP: Database Developer: SQL Server 2008

MCITP: Database Developer: SQL Server 2008

This course is targeted at the professional level SQL Server 2008 Database Developer.

After the completion of this course the candidates will be able to implement tables and views, implement programmable objects, work with query fundamentals and apply additional query techniques in SQL Server 2008 R2

They will also learn how to work with additional SQL Server 2008 R2 components, XML data and gather performance information and perform query optimization.

Then the course will move on to designing conceptual and logical database design, designing strategies for database access, optimal query performance and transactions and concurrency.

After completing this course, students 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

Database Developer: SQL Server 2008

Course#

Course Contents

Exam#

Exam

Regular Track (days)

Fast Track (days)

2778

Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

70-433

TS: Microsoft SQL Server 2008, Database Development

3

2

6232B

Implementing a Microsoft SQL Server 2008 R2 Database

6

4

50401

Designing and Optimizing Database Solutions with Microsoft SQL Server 2008

70-451

PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008

5

3

Total duration

14

9

Prerequisite:

·         Working knowledge of relational databases (database design skills).

·         Core Windows Server skills.

 

·         Basic programming language.

Our Location

Get In Touch

1st Floor of CHABAH House,

Chabah Bus Stop on the Odokor-Mallam HighWay

Opposite Total Filling Station

P. O. Box DS 2022

Accra, Ghana

Phone: +233 303 393 1256 / +233 302 325 815

Cell: +233 244036 522

Email:[email protected]