Home

Learning Paths

Microsoft SQL Server 2005

2071Q - Fundamentals in Transact-SQL with Microsoft SQL Server 2005 or Equivalent Experience 2779 - Implementing a Microsoft SQL Server 2005 Database 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 2791 - Implementing and Maintaining SQL Server 2005 Analysis Services MCTSBI - MCTS - Microsoft SQL Server 2005 Business Intelligence Boot Camp This course is an intense 5-day deep-dive into Microsoft SQL Server 2005 Integration Services, Analysis Services, and Reporting Services, focusing on the hands on application and understanding of all three technologies. It is an intensive program designed for attendees with solid fundamental Microsoft SQL Server experience. The boot camp runs Monday through Friday from 8:00 am to 6:00 pm, with MCTS Test Prep sessions every evening from 6:00 pm to 8:00 pm. 2792 - Implementing and Maintaining SQL Server 2005 Integration Services 2793 - Implementing and Maintaining SQL Server 2005 Reporting Services note: at this point you may be eligible to take Microsoft Exam 70-445 if you are working toward certification: MCTS: Business Intelligence - Implementation and Maintenance RECOMMENDED ELECTIVES FOR MCITP: DATABASE BUSINESS INTELLIGENCE CERTIFICATION 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 2794 - Designing a Business Intelligence Solution Architecture for the Enterprise Using SQL 2005 Prerequisite(s): Requires completion of 2791, 2792, and 2793 before enrolling note: at this point you may be eligible to take Microsoft Exam 70-446 if you are working toward certification: MCITP: Business Intelligence Developer