|
SQL Server 2005 (download pdf)
MCTS: SQL Server 2005
MCITP: Database Developer on Microsoft SQL Server 2005
MCITP: Database Administrator on Microsoft SQL Server 2005
MCITP: Database Administrator (upgrade from MCDBA SQL 2000)
MCTS: SQL Server 2005 Business Intelligence
MCITP: Business Intelligence Developer on Microsoft SQL Server 2005
|
| MCTS: SQL Server 2005 |
| Microsoft Certified Technology Specialist (1 MCTS exam) |
Microsoft Certified Technology Specialists in Microsoft SQL Server 2005implement and maintain databases using specific instructions and specifications. They have thorough knowledge of the product, understand how to use the tools and Transact-SQL language, and know how to explore the user interface. Technology Specialists typically pursue careers as database administrators, database developers, or business intelligence developers. They may also be developers and systems administrators who do not work with SQL Server daily but who want to show their breadth of technology experience.
|
| Microsoft SQL Server 2005 - Implementation & Maintenance (1 MCTS exam) |
| |
|
|
|
|
|
|
| 2071 |
|
2779 |
|
2780 |
|
|
| Querying Microsoft SQL Server 2000/2005 with Transact-SQL |
|
Implementing a Microsoft SQL Server 2005 Database |
|
Maintaining a Microsoft SQL Server 2005 Database |
|
|
| (2 days) |
|
(5 days) |
|
(5 days) |
|
|
| exam 70-431 |
|
|
| |
|
|
|
|
|
|
| Experienced SQL 2000 Administrators & Developers: Can update skills to SQL Server 2005 by taking 2733 & 2734 |
|
2733 |
|
2734 |
|
|
|
Updating Database Administration Skills to Microsoft SQL Server 2005 |
|
Updating Database Development Skills to MS SQL Server 2005 Intense |
|
|
|
(3 days) |
|
(2 days) |
|
|
| |
exam 70-431 |
|
|
|
|
|
|
|
|
|
|
| MCITP: Database Developer on Microsoft SQL Server 2005 |
| Microsoft Certified IT Professional: Database Developer (1 MCTS exam + 2 MCITP exams) |
| MCITP: Database Developer is the premier certification for database designers and developers. This credential demonstrates that you can design a secure, stable, enterprise database solution by using Microsoft SQL Server 2005. Database developers design and implement relational database models (logical and physical) and database storage objects. They also program servers by using user-defined functions, triggers, stored procedures, Transact-SQL, or the CLR. They retrieve or modify data using SQL queries or tune and optimize queries. |
| 1) Microsoft SQL Server 2005 - Implementation & Maintenance (1 MCTS exam) |
| |
|
|
|
|
|
|
| 2071 |
|
2779 |
|
2780 |
|
|
| Querying MS SQL Server 2000/2005 with Transact-SQL |
|
Implementing a Microsoft SQL Server 2005 Database |
|
Maintaining a Microsoft SQL Server 2005 Database |
|
|
| (2 days) |
|
(5 days) |
|
(5 days) |
|
|
| exam 70-431 |
|
|
| |
|
|
|
|
|
|
| Experienced SQL 2000 Administrators & Developers: Can update skills to SQL Server 2005 by taking 2733 & 2734 |
|
2733 |
|
2734 |
|
|
|
Updating Database Administration Skills to Microsoft SQL Server 2005 |
|
Updating Database Development Skills to MS SQL Server 2005 Intense |
|
|
|
(3 days) |
|
(2 days) |
|
|
|
exam 70-431 |
|
|
| |
|
|
|
|
|
|
| 2) Designing Database Solutions by Using Microsoft SQL Server 2005 (1 MCITP exam) |
| |
|
|
|
|
|
|
| 2781 |
|
2782* |
|
|
*Note: Learn IT! combines the 2782 and 2784 as our Advanced MS SQL Server 2005 for Developers course |
| Designing MS SQL Server 2005 Server-Side Solutions |
|
Designing Microsoft SQL Server 2005 Database |
|
|
| (3 days) |
|
(2 days) |
|
|
| exam 70-441 |
|
|
| |
|
|
|
|
| 3) Designing and Optimizing Data Access Using Microsoft SQL Server 2005 (1 MCITP exam) |
| |
|
|
|
|
|
|
| 2781 |
|
2783 |
|
2784* |
|
|
| Designing MS SQL Server 2005 Server-Side Solutions |
|
Designing the Data Tier for Microsoft SQL Server 2005 |
|
Tuning and Optimizing Queries Using MS SQL Server 2005 |
|
|
| (3 days) |
|
(1 day) |
|
(3 days) |
|
|
| exam 70-442 |
|
|
Back to top
|
| MCITP: Database Administrator on Microsoft SQL Server 2005 |
| Microsoft Certified IT Professional: Database Administrator (1 MCTS exam + 2 MCITP exams) |
MCITP: Database Administrator is the premier certification for database server administrators. This certification demonstrates that you can keep up with your enterprise business solutions 24 hours a day, 7 days a week. Database administrators install or configure Microsoft SQL Server and manage or maintain databases or multidimensional databases, user accounts, database availability, recovery, and reporting. They also design or implement security or server automation and monitor and troubleshoot SQL Server activity.
|
| 1) Microsoft SQL Server 2005 - Implementation & Maintenance (1 MCTS exam) |
| |
|
|
|
|
|
|
| 2071 |
|
2779 |
|
2780 |
|
|
| Querying Microsoft SQL Server 2000/2005 with Transact-SQL |
|
Implementing a Microsoft SQL Server 2005 Database |
|
Maintaining a Microsoft SQL Server 2005 Database |
|
|
| (2 days) |
|
(5 days) |
|
(5 days) |
|
|
| exam 70-431 |
|
|
| |
|
|
|
|
|
|
| Experienced SQL 2000 Administrators & Developers: Can update skills to SQL Server 2005 by taking 2733 & 2734 |
|
2733 |
|
2734 |
|
|
|
Updating Database Administration Skills to Microsoft SQL Server 2005 |
|
Updating Database Development Skills to Microsoft SQL Server 2005 Intense |
|
|
|
(3 days) |
|
(2 days) |
|
|
|
exam 70-431 |
|
|
| |
|
|
|
|
|
|
| 2) Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005 (1 MCITP exam) |
| |
|
|
|
|
|
|
| 2786 |
|
2787* |
|
2788* |
|
*Note: Learn IT! combines the 2787, 2788, & 2789 as our Advanced Microsoft SQL Server 2005 for Administrators course |
| Designing Microsoft SQL Server 2005 Infrastructure |
|
Designing Security for Microsoft SQL Server 2005 |
|
Designing High Availability Database Solutions Using Microsoft SQL Server 2005 |
|
| (2 days) |
|
(2 days) |
|
(3 days) |
|
| exam 70-443 |
|
| |
|
|
|
|
|
|
| 3) Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005 (1 MCITP exam) |
| |
|
|
|
|
|
|
| 2787* |
|
2789* |
|
2790 |
|
|
| Designing Security for Microsoft SQL Server 2005 |
|
Administering and Automating Microsoft SQL Server 2005 Databases and Servers |
|
Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005 |
|
|
| (2 days) |
|
(1 day) |
|
(2 days) |
|
|
| exam 70-444 |
|
|
Back to top
|
|
|
|
|
|
|
| MCITP: Database Administrator (upgrade from MCDBA SQL 2000) |
| Microsoft Certified IT Professional: Database Administrator (1 MCTS exam + MCITP upgrade exam) |
| If you are a MCDBA on Microsoft SQL Server 2000, you may upgrade to the MCITP: Database Administrator certification by taking one MCITP upgrade exam instead of the two required MCITP exams. MCDBAs must still obtain the MCTS: SQL Server 2005 certification as a prerequisite. |
| 1) Microsoft SQL Server 2005 - Implementation & Maintenance (1 MCTS exam) |
| |
|
|
|
|
|
|
| 2071 |
|
2779 |
|
2780 |
|
|
| Querying Microsoft SQL Server 2000/2005 with Transact-SQL |
|
Implementing a Microsoft SQL Server 2005 Database |
|
Maintaining a Microsoft SQL Server 2005 Database |
|
|
| (2 days) |
|
(5 days) |
|
(5 days) |
|
|
| exam 70-431 |
|
|
| |
|
|
|
|
|
|
| Experienced SQL 2000 Administrators & Developers: Can update skills to SQL Server 2005 by taking 2733 & 2734 |
|
2733 |
|
2734 |
|
|
|
Updating Database Administration Skills to Microsoft SQL Server 2005 |
|
Updating Database Development Skills to Microsoft SQL Server 2005 Intense |
|
|
|
(3 days) |
|
(2 days) |
|
|
|
exam 70-431 |
|
|
| |
|
|
|
|
|
|
| 2) Upgrade: MCDBA Skills to MCITP Database Administrator by Using Microsoft SQL Server 2005 (1 MCITP exam) |
| |
|
|
|
|
|
|
| 2786 |
|
2787* |
|
2788* |
|
*Note: Learn IT! combines the 2787, 2788, & 2789 as our Advanced Microsoft SQL Server 2005 for Administrators course. |
| Designing Microsoft SQL Server 2005 Infrastructure |
|
Designing Security for Microsoft SQL Server 2005 |
|
Designing High Availability Database Solutions Using Microsoft SQL Server 2005 |
|
| (2 days) |
|
(2 days) |
|
(3 days) |
|
| exam 70-447 |
|
| |
|
|
|
|
|
|
| 2789* |
|
2790 |
|
|
|
Courses 2786, 2787, 2788, 2789, & 2790 all relate to the 70-447 upgrade exam. |
| Administering and Automating Microsoft SQL Server 2005 Databases and Servers |
|
Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005 |
|
|
|
| (1 day) |
|
(2 days) |
|
|
|
| exam 70-447 |
|
|
|
Back to top
|
|
|
|
|
|
|
| MCTS: SQL Server 2005 Business Intelligence |
| Microsoft Certified Technology Specialist (1 MCTS exam) |
| Microsoft Certified Technology Specialists in Microsoft SQL Server 2005 Business Intelligence implement and maintain business intelligence solutions. They have thorough knowledge of the Microsoft SQL Server 2005 Business Intelligence Development tool suite. This includes knowledge of database schemas, debugging, monitoring, and troubleshooting Business Intelligence solutions, and working with the Microsoft .NET Framework. They can write database queries, use SSAS data mining algorithms, and create and deploy SQL Server Reporting Services (SSRS) reports. Additionally, they author and deploy SQL Server Integration Services (SSIS) packages. Technology Specialists typically pursue careers as database administrators, database developers, or business intelligence developers. They may also be developers and systems administrators who do not work with SQL Server daily but who want to show their breadth of technology experience. |
| Microsoft SQL Server 2005 Business Intelligence - Implementation and Maintenance (1 MCTS exam) |
| |
|
|
|
|
|
|
| 2791 |
|
2792 |
|
2793 |
|
|
| Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services |
|
Implementing and Maintaining Microsoft SQL Server 2005 Integration Services |
|
Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services Intense |
|
|
| (5 days) |
|
(3 days) |
|
(2 days) |
|
|
| exam 70-445 |
|
|
Back to top
|
|
|
|
|
|
|
| MCITP: Business Intelligence Developer on Microsoft SQL Server 2005 |
| Microsoft Certified IT Professional (1 MCTS exam + 1 MCITP exam) |
| MCITP: Business Intelligence Developer is the premier certification for business intelligence system designers and developers. This certification demonstrates that you can design analysis solutions, data transformations, and reports. Business intelligence developers design and implement multi-dimensional database models (logical and physical), data marts, data warehousing, data transforms, data analytics, and reporting solutions. This includes programming and customizing servers that use Multidimensional Expressions (MDX), custom transforms, and custom reporting solutions. |
| 1) Microsoft SQL Server 2005 Business Intelligence - Implementation and Maintenance (1 MCTS exam) |
| |
|
|
|
|
|
|
| 2791 |
|
2792 |
|
2793 |
|
|
| Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services |
|
Implementing and Maintaining Microsoft SQL Server 2005 Integration Services |
|
Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services Intense |
|
|
| (5 days) |
|
(3 days) |
|
(2 days) |
|
|
| exam 70-445 |
|
|
| |
|
|
|
|
|
|
| 2) Designing a Business Intelligence Solution by Using Microsoft SQL Server 2005 (1 MCITP exam) |
| |
|
|
|
|
|
|
| 2794 |
|
2795 |
|
2796 |
|
2797 |
| Designing a Business Intelligence Solution Architecture for the Enterprise Using Microsoft SQL Server 2005 |
|
Designing an ETL Solution Architecture Using Microsoft SQL Server 2005 Integration Services |
|
Designing an Analysis Solution Architecture Using Microsoft SQL Server 2005 Analysis Services |
|
Designing a Reporting Solution Architecture Using Microsoft SQL Server 2005 Reporting Services |
| (2 days) |
|
(2 days) |
|
(3 days) |
|
(2 days) |
| exam 70-446 |