| |||||||||||||||||||||||||||||||||
|
![]()
|
||||||||||||||||||||||||||||||||
| UPGRADE PATHS | ||||
For this Microsoft Technology |
If You Have this Certification |
![]() |
||
| Version 2008 | ||||
| MCITP: Database Administrator 2005 | ||||
| MCITP: Database Developer 2005 | ||||
| MCITP: Business Intelligence Developer 2005 | ||||
Though you may see some SQL Server 2005 courses on our schedule, please note that Microsoft retired the SQL Server 2005 exams as of June 30, 2011.
Version 2008 Certifications ![]()
Microsoft
Certified Technology Specialist (MCTS):
SQL Server 2008 Implementation and Maintenance
(First series certification)

To achieve this certification you must pass the designated exam. You can prepare for the exam by attending the courses listed below.
Certification Exam
70-432: TS: Microsoft SQL Server 2008 Implementation and Maintenance
Authorized Courses
(click
course title for outline & dates)
6231: Maintaining a Microsoft SQL Server 2008 Database (5 days)
This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database. View outline &
dates
2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL (3 days)
This 3-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008. View outline &
dates
6232: Implementing a Microsoft SQL Server 2008 Database (5 days)
This five-day instructor-led course provides students with the knowledge and skills to implement a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to implementing a database. View outline &
dates
Microsoft
Certified Technology Specialist (MCTS): SQL Server 2008 Database Development
(First series certification)

To achieve this certification you must pass the designated exam. You can prepare for the exam by attending the courses listed below.
Certification Exam
70-433: TS: Microsoft SQL Server 2008 Database Development
Authorized Courses
(click
course title for outline & dates)
6232: Implementing a Microsoft SQL Server 2008 Database (5 days)
This five-day instructor-led course provides students with the knowledge and skills to implement a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to implementing a database.View outline &
dates
2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL (3 days)
This 3-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008. View outline &
dates
6231: Maintaining a Microsoft SQL Server 2008 Database (5 days)
This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database. View outline &
dates
Microsoft
Certified Technology Specialist (MCTS): SQL Server 2008 Business Intelligence Development and Maintenance
(First series certification)

To achieve this certification you must pass the designated exam. You can prepare for the exam by attending the courses listed below.
Certification Exam
70-448: TS: Microsoft SQL Server 2008 Business Intelligence Development and Maintenance
Authorized Courses
(click
course title for outline & dates)
6234: Implementing and Maintaining Microsoft SQL Server2008 Analysis Services (3 days)
This three-day instructor-led course teaches students how to implement an Analysis Services solution in an organization. The course discusses how to use the Analysis Services development tools to create an Analysis Services database and an OLAP cube, and how to use the Analysis Services management and administrative tools to manage an Analysis Services solution. View outline &
dates
6235: Implementing and Maintaining Microsoft SQL Server 2008 Integration Services (3 days)
This three-day instructor-led course teaches students how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages. View outline &
dates
6236: Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services (3 days)
This three-day instructor-led course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution. View outline &
dates
Microsoft
Certified IT Professional (MCITP): Database Administrator 2008
(Second series certification)
To achieve this certification you must first be certified as a MCTS: SQL Server Implementation & Maintenance and then pass the exam listed below. You can prepare for this exam by attending the course shown below.
Certification Exam
70-450: PRO: Designing, Optimizing and Maintaining a Database Server Infrastructure using SQL Server 2008
Authorized Courses
(click
course title for outline & dates)
50400: Designing, Optimizing & Maintaining Administrative Solutions for SQL Server 2008 (5 days)
This five-day instructor-led course provides the knowledge and skills to design, optimize, and maintain a database administrative solution for Microsoft SQL Server 2008. 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. View outline &
dates
Microsoft
Certified IT Professional (MCITP): Database Developer 2008
(Second series certification)
To achieve this certification you must first be certified as a MCTS: SQL Server 2008, Database Development and then pass the exam listed below. You can prepare for this exam by attending the course shown below.
Certification Exam
70-451: PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008
Authorized Courses
(click
course title for outline & dates)
50401: Designing and Optimizing Database Solutions with SQL Server 2008 (5 days)
This five-day instructor-led course provides provides the knowledge and skills that IT Professionals need to design, optimize, and maintain SQL Server 2008 database.. View outline &
dates
Microsoft
Certified IT Professional (MCITP): Business Intelligence Developer 2008
(Second series certification)
To achieve this certification you must first be certified as a MCTS: SQL Server 2008, Business Intelligence Development and Maintenance and then pass the exam listed below. You can prepare for this exam by attending the course shown below.
Certification Exam
70-452: PRO: SQL Server 2008, Business Intelligance Development and Maintenance
Authorized Courses
(click
course title for outline & dates)
50402: Designing and Optimizing Database Solutions with SQL Server 2008 (3 days)
This three-day instructor-led course prepares you to design and deploy remote access solutions using Microsoft Forefront Unified Access Gateway 2010 (UAG). Forefront UAG provides organizations with unparalleled flexibility in providing access to network resources (such as Web sites and internal applications) with granular access control, custom content protection, and endpoint validation. Forefront UAG also integrates with DirectAccess, a Windows 7 technology that provides seamless remote access to all corporate resources without connecting to a virtual private network. This course is intended for architects, consultants, network administrators, and technical sales professionals who are responsible for selling, designing, and deploying edge access solutions for enterprises. View outline &
dates
Upgrade from version 2005 to 2008 Certifications ![]()
Upgrade from Microsoft
Certified IT Professional (MCITP) Database Administrator 2005 to
Microsoft
Certified IT Professional (MCITP):
Database Administrator 2008
(Upgrade
to Second series certification)
Individuals with Microsoft Certified IT Professional (MCITP) Database Administrator 2005 certification who want to become MCITP: Database Administrator 2008 certified must pass the authorized exam below. You can prepare for the exam by attending the listed course.

Certification Exam
70-453: UPGRADE: Transition your MCITP Database Administrator Skills to MCITP Database Administrator 2008
Authorized
Courses
(click course title for outline &
dates)
6158: Updating Your SQL Server 2005 Skills to SQL Server 2008 (3 Days)
This three-day instructor-led course provides students with the knowledge and skills to upgrade their SQL Server 2005 skills to SQL Server 2008. View
outline & date
It is possible that additional classroom training will become available to prepare for this exam. Contact our Education Advisors at 1.800.288.8221 to review the latest information.
Upgrade from Microsoft
Certified IT Professional (MCITP) Database Developer 2005 to
Microsoft
Certified IT Professional (MCITP):
Database Developer 2008
(Upgrade
to Second series certification)
Individuals with Microsoft Certified IT Professional (MCITP) Database Developer 2005 certification who want to become MCITP: Database Administrator 2008 certified must pass the authorized exam below. You can help prepare for the exam by attending the listed course.

Certification Exam
70-454: UPGRADE: Transition your MCITP Database Developer Skills to MCITP Database Developer 2008
Authorized
Courses
(click course title for outline &
dates)
6158: Updating Your SQL Server 2005 Skills to SQL Server 2008 (3 Days)
This three-day instructor-led course provides students with the knowledge and skills to upgrade their SQL Server 2005 skills to SQL Server 2008. View
outline & date
It is possible that additional classroom training will become available to prepare for this exam. Contact our Education Advisors at 1.800.288.8221 to review the latest information.
Upgrade from Microsoft
Certified IT Professional (MCITP) Business Intelligence 2005 to
Microsoft
Certified IT Professional (MCITP):
Busines2008
(Upgrade
to Second series certification)
Individuals with Microsoft Certified IT Professional (MCITP) Business Intelligence Developer 2005 certification who want to become MCITP: Business Intelligence Developer 2008 certified must pass the authorized exam below. You can help prepare for the exam by attending the listed course.

Certification Exam
70-454: UPGRADE: Transition your MCITP Database Developer Skills to MCITP Database Developer 2008
Authorized
Courses
(click course title for outline &
dates)
6158: Updating Your SQL Server 2005 Skills to SQL Server 2008 (3 Days)
This three-day instructor-led course provides students with the knowledge and skills to upgrade their SQL Server 2005 skills to SQL Server 2008. View
outline & date
It is possible that additional classroom training will become available to prepare for this exam. Contact our Education Advisors at 1.800.288.8221 to review the latest information.
Authorized Microsoft Classes at ONLC Training Centers
ONLC is a Microsoft Gold Partner for Learning. Microsoft technical and Dynamics classes are authorized, hands-on training that use official Microsoft products and are facilitated by a Microsoft Certified Trainer (MCT).
Microsoft Software
Assurance Vouchers Accepted Here
ONLC gladly accepts Microsoft Software Assurance (SA) Vouchers. These vouchers can be redeemed for any official Microsoft instructor-led training course that was created for the IT professional or developer audience. SA Vouchers can also be used for Microsoft Dynamics CRM courses. Need
help with the SA Voucher process? We can also provide 1x1 activation coaching. More.
![]()
Questions?
To
learn more about ONLC's classes or in the event of questions contact our Education
Advisors at:
1.800.288.8221
| |||||||
| ONLC Training Centers has grown to be the largest IT training company in the US with over 250 classroom training locations. Click the links below to learn why so many people are selecting us as their training provider. | |||
Our Classes |
For Companies | RCI™ | |
•Course Schedule (all titles) |
•Savings Options & Plans •Microsoft Office Migration •Microsoft Software Assurance Vouchers |
•RCI Overview •RCI from Destinations •RCI from Home/Office |
|
Why Register with ONLC |
For Professionals | About ONLC | |
| •Fewest Class Cancellations •Training Company Comparison •Reasons to Register Now |
•Certification Programs •Savings Plans •Money Back Guarantee |
•About Us •Our Instructors •Employment Opportunities |
|
Other Information |
For Government | ||
| •Federal, State, Local & Military •GSA •DoD 8570.1 |
|||
•U.S. Locations
•U.S. Locations by City ![]()
Attend hands on, instructor-led computer classes at our more than 250 classroom locations in these cities...
•Canada Locations ![]()
You can attend any ONLC class right from your PC via RCI™ including these areas in Canada...