|
Consultech’s Microsoft Certified MCTS & MCITP
Series Microsoft Certified IT Professional: Database Developer
(MCITP: Database Developer) & Database Administrator (MCITP: Database
Administrator) premier certifications for database Administrators or designers
and developers.
SERIES 1 MCTS
MCTS: SQL Server 2005 credential (one exam); this is Consultech’s 2 week series
with 431 exam voucher
SERIES 2 MCITP: Database Developer
or Database Administrator Paths
MCITP: each is Consultech’s 1 week series: with 441 & 442 or 443 & 444 exam
vouchers
SERIES 1: MCTS Required
Exams for MCTS: SQL Server 2005
(CORE for BOTH MCITP paths)
|
One Exam Required |
Classroom Training |
|
Exam 70–431: TS: Microsoft SQL Server 2005 - Implementation and
Maintenance |
1 WEEK 7988 COURSE
Course 2779: Implementing a SQL Server 2005 Database &
Course 2784: Tuning and Optimizing Queries Using SQL Server 2005
1 WEEK 8084 COURSE
Course 2780: Maintaining a SQL Server 2005 Database &
Course 2788: Designing High Availability Database Solutions Using SQL
Server 2005 |
SERIES 2A path: MCITP: Database
Developer
(SERIES 1 MCTS Prerequisite)
|
Two Exams Required |
Classroom Training |
|
Exam 70–441: PRO: Designing Database Solutions by Using Microsoft SQL
Server 2005 Open License 6.0 |
1 WEEK 818283 CLASS
Course 2781: Designing Microsoft SQL Server 2005 Server-Side Solutions &
Course 2782: Designing SQL Server 2005 Databases &
Course 2783: Designing the Data Tier for SQL Server 2005 |
|
Exam 70–442: PRO: Designing and Optimizing Data Access by Using
Microsoft SQL Server 2005 |
Included in above 1 week class |
SERIES 2B path: MCITP: Database
Administrator 1 WEEK CLASS
(SERIES 1 MCTS Prerequisite)
|
Required Two Exams |
Classroom Training |
|
Exam 70–443: PRO: Designing a Database Server Infrastructure by Using
SQL Server 2005 |
1 WEEK 86878990 CLASS
Course 2786: Designing a SQL Server 2005 Infrastructure &
Course 2787: Designing Security for SQL Server 2005 &
Course 2789: Administering & Automating SQL Server 2005 Databases &
Services 2005 &
Course 2790: Troubleshooting & Optimizing Database Servers Using SQL
Server 2005 |
|
Exam 70–444: PRO: Optimizing & Maintaining a Database Administration
Solution by Using SQL Server 2005 |
Included in above 1 week class |
SERIES 3A path: MCTS: Microsoft SQL Server
2005 Business Intelligence – Implementation and Maintenance (2 weeks)
|
REPORTING SERVICES |
Classroom Training with exam: one week $2295 or 3A
series $4099 |
|
Exam 70-445:
MCTS: Microsoft SQL Server 2005 Business Intelligence—Implementation
& Maintenance |
1 WEEK 9397
Course 2793: Implement & Maintain SQL Server Reporting Services &
Course 2797: Design Reporting Solution Architecture
1 WEEK 279192
Course 2791: Implement & Maintain Microsoft SQL Server 2005 Analysis
Services (three days) &
Course 2792: Implement & Maintain SQL Server 2005 Integration Services
(three days) |
SERIES 3B path added to SERIES 3A: MCITP:
Business Intelligence Developer 4 weeks & 2 exams
|
REPORTING SERVICES-BI |
Classroom Training with exam: any 1 class $2295 or
3B series $8099 (includes 3A classes & exam) |
The Microsoft Certified Professional
(PRO) exam, Exam 70-446: PRO:
Designing a Business Intelligence Infrastructure by Using Microsoft SQL
Server 2005
|
1 WEEK
Course 2794: Designing a Business Intelligence Solution Architecture for
the Enterprise Using Microsoft SQL Server 2005 &
Course 2795: Designing an ETL Solution Architecture Using Microsoft SQL
Server 2005 Integration Services ( 4 days)
1 WEEK
Course 2796: Designing an Analysis Solution Architecture Using Microsoft
SQL Server 2005 Analysis Services &
Course 2797: Designing a Reporting Solution Architecture Using Microsoft
SQL Server 2005 Reporting Services (5 days)
|
|