Home

Learning Paths

Microsoft SQL Server 2005

WHAT IS YOUR EXPERIENCE WITH MICROSOFT SQL SERVER? New to Microsoft SQL Server 2071Q - Fundamentals in Transact-SQL with Microsoft SQL Server 2005 or Equivalent Experience Experienced Microsoft SQL Server 2000 Developer 2779 - Implementing a Microsoft SQL Server 2005 Database 2734Q - Updating Database Developer Skills to Microsoft SQL Server 2005 note: If you have completed 2780 - Maintaining a Microsoft SQL Server 2005 Database or have equivalent experience you may be eligible to take Microsoft Exam 70-431 if you are working toward certification: MCTS: Microsoft SQL Server 2005 2781 - Designing SQL Server 2005 Server-Side Solutions 2782 - Designing SQL Server 2005 Database note: at this point you may be eligible to take Microsoft Exam 70-441 if you are working toward certification: MCITP: Database Developer 2784 - Tuning and Optimizing Queries using SQL Server 2005 RECOMMENDED ELECTIVE FOR MCITP: DATABASE DEVELOPER CERTIFICATION 2783 - Designing the Data Tier for SQL Server 2005 note: at this point you may be eligible to take Microsoft Exam 70-442 if you are working toward certification: MCITP: Database Developer RECOMMENDED ELECTIVES FOR SQL SERVER 2005 BUSINESS INTELLIGENCE SPECIALIZATION 2791 - Implementing and Maintaining SQL Server 2005 Analysis Services 2792 - Implementing and Maintaining SQL Server 2005 Integration Services 2793 - Implementing and Maintaining SQL Server 2005 Reporting Services BUSINESS INTELLIGENCE ELECTIVES 2794 - Designing a Business Intelligence Solution Architecture for the Enterprise Using SQL 2005 Prerequisite(s): Requires completion of 2791, 2792, and 2793 before enrolling 2795 - Designing an ETL Solution Architecture Using Microsoft SQL Server 2005 Prerequisite(s): Requires completion of 2792 before enrolling 2796 - Designing on OLAP Solutions Architecture Using Microsoft SQL Server 2005 Prerequisite(s): Requires completion of 2791 before enrolling 2797 - Designing a Reporting Solution Architecture Using SQL Server 2005 Reporting Services Prerequisite(s): Requires completion of 2793 before enrolling