| |||||||||||||||||||||||||||||||||||||||||||
|
| ||||||||||||||||||||||||||||||||||||||||||
) to see specific locations and dates of "
) to see specific locations and dates of Early Notice classes.
Top of page
| 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 | |
||
| Version 2005 | ||||
 |
MCDBA certification | |
MCITP: Database Administration 2005 | |
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
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
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)
6315: Designing, Optimizing and Maintaining a Database Server Infrastructure using SQL Server 2008 (5 days)
Look for this course to be scheduled as soon as it is released by Microsoft.
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)
6316: Designing, Developing and Optimizing SQL Server 2008 Databases (5 days)
Look for this course to be scheduled as soon as it is released by Microsoft.
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)
6314: Designing SQL Server 2008 Business Intelligence Solutions (5 days)
Look for this course to be scheduled as soon as it is released by Microsoft.
Version 2005 Certifications
Microsoft
Certified Technology Specialist (MCTS):
SQL Server 2005
(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-431: TS: Microsoft® SQL Server™ 2005
- Implementation and Maintenance
Authorized Courses
(click
course title for outline & dates)
2779:
Implementing SQL Server 2005 Database (5 Days)
This five-day instructor-led
course provides students with the knowledge and skills to implement a Microsoft
SQL Server 2005 database. The course focuses on teaching individuals how to use
SQL Server 2005 product features and tools related to implementing a database. View outline & dates
2780:
Maintaining SQL Server 2005 Database (5 Days)
This five-day instructor-led
course provides students with the knowledge and skills to maintain a Microsoft
SQL Server 2005 database. The course focuses on teaching individuals how to use
SQL Server 2005 product features and tools related to maintaining a database. View outline & dates
Microsoft Certified Technology
Specialist (MCTS):
SQL Server 2005 Business Intelligence Tools
(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-445: TS: Microsoft® SQL Server™ 2005
Business Intelligence - Implementation and Maintenance
Authorized Courses
(click
course title for outline & dates)
2794:
Designing a Business Intelligence Solution for the Enterprise Using SQL Server
2005 (2 Days)
The purpose of this 2-day instructor-led course is to
teach Business Intelligence (BI) professionals working in enterprise environments
to design a BI solution architecture. Students will be taught the importance of
keeping all components of the solution and stages of the lifecycle in mind. The
first day focuses on foundational standards and practices for the enterprise.
The second day focuses on a project-specific lifecycle for capturing requirements
and deriving a solution architecture. View
outline & dates
2795:
Designing an ETL Solution Architecture Using SQL Server 2005 Integration Services (2 Days)
The purpose of this 2-day instructor-led course is to teach Business
Intelligence (BI) professionals working in enterprise environments to design an
extract, transform, and load (ETL) solution that supports their BI solution. Students
will learn how to plan an ETL solution, and specifically how to design and implement
a SQL Server Integration Services (SSIS) based ETL solution. They will also learn
how to monitor, optimize, and deploy an SSIS solution.
This course focuses
on the planning and design aspects of an ETL solution and does not teach students
how to create SSIS packages or how to use the development tools provided with
SQL Server 2005. View outline
& dates
2796:
Designing an Analysis Solution Architecture Using SQL Server 2005 Analysis Services (3 Days)
This 3-day course will teach Business Intelligence (BI) professionals
working in enterprise environments to design a multidimensional solution architecture
that supports their BI solution. Students will go through the entire process—from
capturing business and technical requirements to deploying a multidimensional
solution to production. Students will also be taught to develop custom functionality
and optimize a multidimensional solution.
This course focuses on the planning
and design aspects of an analysis solution and does not teach students how to
create Analysis Services database objects or how to use the development tools
provided with SQL Server 2005. View
outline & dates
2797:
Designing a Reporting Solution Architecture Using SQL Server 2005 Reporting Services (2 Days)
The purpose of this 2 day course is to teach Business Intelligence
(BI) professionals working in enterprise environments to design a reporting solution
architecture that supports their BI solution. Students will go through the entire
process-from identifying report data to promoting the reporting solution to production.
Students will scale a reporting solution. Students will also be taught best practices
for collaborating with application developers to integrate applications and reporting
services. This course focuses on the planning and design aspects
of a reporting solution and does not teach you how to create reports or how to
use the development tools provided with SQL Server 2005. View
outline & dates
Microsoft
Certified IT Professional (MCITP):
Database Administrator 2005
(Second
series certification)
Requires certification first as a MCTS: SQL Server 2005 and then passing the authorized exams listed below.
Certification Exams
70-443: PRO: Designing a Database Server Infrastructure by Using Microsoft® SQL Server™ 2005
70-444: PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft® SQL Server™ 2005
Authorized Courses
(click course title for outline &
dates)
2786:
Designing a SQL Server 2005 Infrastructure (2 Days)
This two-day instructor-led
course provides database administrators working in enterprise environments with
the knowledge and skills to design a Microsoft SQL Server 2005 database infrastructure.
The course focuses on the development of strategies for data archiving, consolidation,
distribution, and recovery. The course also stresses the importance of capacity
analysis and emphasizes the tradeoffs that need to be made during design. View
outline & dates
2787:
Designing Security for SQL Server 2005 (2 Days)
This two-day instructor-led
course enables database administrators who work with enterprise environments to
design security for database systems using Microsoft SQL Server 2005. The course
emphasizes that students should think about the whole environment, which includes
business needs, regulatory requirements, network systems, and database considerations
during design. Students will also learn how to monitor security and respond to
threats. View outline &
dates
2788:
Designing High Availability Database Solutions Using SQL Server 2005 (3
Days)
This three-day instructor-led course provides students with the knowledge
and skills to design high availability database solutions using Microsoft SQL
Server 2005. The course focuses on teaching experienced database administrators
working in enterprise environments to design database solutions that meet the
availability needs of their organization. It emphasizes that students should think
broadly about high availability, which includes thinking about the database itself
and about their entire environment, including business needs; regulatory requirements;
and network, systems, and database considerations during design. Students will
also learn how to document and test the high availability database solution. View
outline & dates
2789:
Administering and Automating Microsoft SQL Server 2005 Databases and Servers (1 Day)
This one-day instructor-led course provides students with the knowledge
and skills to administer and automate Microsoft SQL Server 2005 databases and
servers. This course focuses on the need to maintain administration and automation
information. View outline
& dates
2790:
Troubleshooting Shooting and Optimizing Database Servers Using SQL Server 2005 (2 Days)
The purpose of this two-day workshop is to teach database administrators
working in enterprise environments how to determine and troubleshoot performance
issues using Microsoft SQL Server 2005. The primary focus of this workshop is
to teach the overall process of troubleshooting. It includes establishing monitoring
standards and baselines, determining performance thresholds, and focusing the
investigation on specific issues. View
outline & dates
Microsoft
Certified IT Professional (MCITP):
Database Developer 2005
(Second
series certification)
Requires certification first as a MCTS: SQL Server 2005 and then passing the authorized exams listed below.
Certification Exams
70-441: PRO: Designing Database Solutions by
Using Microsoft® SQL Server™ 2005
70-442: PRO: Designing and Optimizing
Data Access by Using Microsoft® SQL Server™ 2005
Authorized Courses
(click course title for outline &
dates)
2781:
Designing SQL Server 2005 Server-Side Solutions (3 Days)
This three-day
instructor-led course provides students with the knowledge and skills to design
server-side solutions for Microsoft SQL Server 2005. The course focuses on teaching
database developers who work in enterprise environments to identify and place
database technologies during design to achieve a suitable solution that meets
the needs of an organization. Students will also learn to consider the solution
from a system-wide view instead of from a single database or server perspective. View outline &
dates
2782:
Designing SQL Server 2005 Databases (2 Days)
This two-day instructor-led
course provides students with the knowledge and skills to design databases for
Microsoft SQL Server 2005 using business requirements to guide their decisions
(beyond structured third normal form [3NF] modeling techniques). Students will
also learn to incorporate security requirements throughout their design. View
outline & dates
2783:
Designing the Data Tier for SQL Server 2005 (1 Day)
This one-day instructor-led
clinic provides students with the knowledge and skills to design the data tier
for Microsoft SQL Server 2005. The clinic focuses on teaching database developers
working in enterprise environments to understand and decide how application developers
are going to access and consume their data. This is a major failure point of database
solutions today. View
outline & dates
2784:
Tuning and Optimizing Queries Using SQL Server 2005 (3 Days)
This three-day
instructor-led workshop provides database developers working in enterprise environments
using Microsoft SQL Server 2005 the knowledge and skills to evaluate and improve
queries and query response times. The workshop focuses on systematic identification
and optimization of database factors that impact query performance. Elements of
this syllabus are subject to change. View
outline & dates
Microsoft
Certified IT Professional (MCITP):
Business Intelligence Developer 2005
(Second
series certification)
Requires certification first as a MCTS: SQL Server 2005 Business Intelligence Tools and then passing the authorized exam listed below.
NOTE: The courses recommended for this certification are the same as those listed for the MCTS: SQL Server 2005 Business Intelligence Tools certification, which is a requirement:
- 2794: Designing a Business Intelligence Solution for the Enterprise Using SQL Server 2005
- 2795: Designing an ETL Solution Architecture Using SQL Server 2005 Integration Services
- 2796: Designing an Analysis Solution Architecture Using SQL Server 2005 Analysis Services
- 2797: Designing a Reporting Solution Architecture Using SQL Server 2005 Reporting Services
Certification Exam
70-446: PRO: Designing and Developing a Business Intelligence Infrastructure by Using Microsoft® SQL Server™ 2005
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.
Upgrade from MCAD to 2005 Certification
Upgrade from MCDBA to
Microsoft
Certified IT Professional (MCITP):
Database Administration 2005
(Upgrade
to Second series certification)
Individuals with Microsoft Certified Database Administrator (MCDBA) certification who want to become MCITP: Database Administrator 2005 must pass the authorized exams below. You can prepare for the exams by attending the courses shown here.
Certification Exam
70-431: TS: Microsoft® SQL Server™ 2005 - Implementation and Maintenance
70-447: UPGRADE:
MCDBA Skills to MCITP Database Administrator by Using Microsoft SQL Server 2005
Authorized
Courses
(click course title for outline &
dates)
2779:
Implementing SQL Server 2005 Database (3 Days)
This three-day instructor-led
course provides students with product knowledge and skills needed to implement
a Microsoft SQL Server 2005 database. The course focuses on teaching individuals
how to use SQL Server 2005 product features and tools related to implementing
a database and will help prepare you for exam 70-431. View
outline & dates
2780:
Maintaining SQL Server 2005 Database (3 Days)
This three-day instructor-led
course provides students with product knowledge and skills needed to maintain
a Microsoft SQL Server 2005 database. The course focuses on teaching individuals
how to use SQL Server 2005 product features and tools related to maintaining a
database and will help prepare you for exam 70-431. View
outline & dates
2786:
Designing a SQL Server 2005 Infrastructure (2 Days)
This two-day instructor-led
course provides database administrators working in enterprise environments with
the knowledge and skills to design a Microsoft SQL Server 2005 database infrastructure.
The course focuses on the development of strategies for data archiving, consolidation,
distribution, and recovery. The course also stresses the importance of capacity
analysis and emphasizes the tradeoffs that need to be made during design. View
outline & dates
2787:
Designing Security for SQL Server 2005 (2 Days)
This two-day instructor-led
course enables database administrators who work with enterprise environments to
design security for database systems using Microsoft SQL Server 2005. The course
emphasizes that students should think about the whole environment, which includes
business needs, regulatory requirements, network systems, and database considerations
during design. Students will also learn how to monitor security and respond to
threats. View outline &
dates
2788:
Designing High Availability Database Solutions Using SQL Server 2005 (3
Days)
This three-day instructor-led course provides students with the knowledge
and skills to design high availability database solutions using Microsoft SQL
Server 2005. The course focuses on teaching experienced database administrators
working in enterprise environments to design database solutions that meet the
availability needs of their organization. It emphasizes that students should think
broadly about high availability, which includes thinking about the database itself
and about their entire environment, including business needs; regulatory requirements;
and network, systems, and database considerations during design. Students will
also learn how to document and test the high availability database solution. View
outline & dates
2789:
Administering and Automating Microsoft SQL Server 2005 Databases and Servers (1 Day)
This one-day instructor-led course provides students with the knowledge
and skills to administer and automate Microsoft SQL Server 2005 databases and
servers. This course focuses on the need to maintain administration and automation
information. View outline
& dates
2790:
Troubleshooting Shooting and Optimizing Database Servers Using SQL Server 2005 (2 Days)
The purpose of this two-day workshop is to teach database administrators
working in enterprise environments how to determine and troubleshoot performance
issues using Microsoft SQL Server 2005. The primary focus of this workshop is
to teach the overall process of troubleshooting. It includes establishing monitoring
standards and baselines, determining performance thresholds, and focusing the
investigation on specific issues. View
outline & date
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.
IT Edge Program
ONLC's IT Edge program provides an added discount to companies training displaced IT workers. Classes are available for developers, programmers, business analysts, helpdesk support technicians, system administrators, and operations managers. In addition to product-specific IT classes, individuals can also brush up on their Microsoft Office skills by taking courses on Word, Excel, PowerPoint, and Access. Learn 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 200 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 Defined •No Travel Option •RCI FAQs |
Why Register with ONLC |
For Individuals | 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 | |
•Events & Offers |
•Federal, State & Local •GSA •DoD 8570.1 |
|
•Locations by State 
Over 200 sites throughout North America. For site details see ONLC Locations
•Locations by City
Attend hands on, instructor-led computer classes at our more than 200 classroom locations in these cities...
•Attend class from Your Location
In addition to our sites, you can attend class from your PC via RCI™ in these and other areas...