SQL BI Fast Track [MS 6234 + MS 6235 + MS 6236]

Goal
This SQL BI Fast Track is a combination of the courses MS 6234, MS 6235 & MS 6236: SQL Server 2008: Analysis Services, Reporting Services and Integration Services. The length of the courses is reduced to 6 days.

Target group
This course is intended for information technology (IT) professionals and developers who need to implement reporting solutions by using Microsoft SQL Server 2008 Reporting Services, who need to implement data transfer or extract, transform, and load (ETL) solutions by using Microsoft SQL Server 2008 Integration Services and who develop applications that deliver content from SQL Server Analysis Services to the organization.

Entry level
Before attending this course, students must have:

• Exposure to creating reports in Microsoft Access or other third-party reporting products, such as Crystal Reports.
• Conceptual understanding of the push and pull distribution/subscription paradigm.
• Experience navigating the Microsoft Windows Server environment.
• Experience with Windows services (starting and stopping).
• Experience creating service accounts and permissions
• Experience with Microsoft SQL Server, including:
  - SQL Server Agent. 
  - SQL Server query language (SELECT, UPDATE, INSERT, and DELETE). 
  - SQL Server System tables. 
  - SQL Server accounts (users and permissions).

Exam
The courses MS 6234, 6235 and 6236 prepares you to exam 70-448. When you pass exam 70-448 you complete the requirements for the following certification(s): MCTS (Microsoft Certified Technology Specialist) Microsoft SQL Server 2008, Business Intelligence Development and Maintenance.

Course content

MS 6234: Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services

• Module 1: Introduction to Microsoft SQL Server Analysis Services
• Module 2: Creating Multidimensional Analysis Solutions
• Module 3: Working with Cubes and Dimensions
• Module 4: Working with Measures and Measure Groups
• Module 5: Querying Multidimensional Analysis Solutions
• Module 6: Customizing Cube Functionality
• Module 7: Deploying and Securing an Analysis Services Database
• Module 8: Maintaining a Multidimensional Solution
• Module 9: Introduction to Data Mining

MS 6235: Implementing and Maintaining Microsoft SQL Server 2008 Integration Services

• Module 1: Introduction to SQL Server 2008 Integration Services
• Module 2: Developing Integration Services Solutions
• Module 3: Implementing Control Flow
• Module 4: Implementing Data Flow
• Module 5: Implementing Logging
• Module 6: Debugging and Error Handling
• Module 7: Implementing Checkpoints and Transactions
• Module 8: Configuring and Deploying Packages
• Module 9: Managing and Securing Packages

MS 6236: Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services

• Module 1: Introduction to Microsoft SQL Server Reporting Services
• Module 2: Authoring Basic Reports
• Module 3: Enhancing Basic Reports
• Module 4: Manipulating Data Sets
• Module 5: Using Report Models
• Module 6: Publishing and Executing Reports
• Module 7: Using Subscriptions to Distribute Reports
• Module 8: Administering Reporting Services
• Module 9: Programming Reporting Services