The Microsoft SQL Server 2008 certification tracks are designed to demonstrate your custom skill set and in-depth understanding of the features and functionality of key technology areas in SQL Server 2008.
This Microsoft MCTS boot camp training includes 50 hours on intense training lectures, hands on labs, Microsoft Official Courseware, test prep material for the exam, and lunch.
This bootcamp consists of the following courses:
- Course 6234: Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services
- Course 6235: Implementing and Maintaining Microsoft SQL Server 2008 Integration Services
- Course 6236: Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services
Training begins every morning at 8:00 AM and ends at 6:00 PM.
Module I of III
Course 6234 - Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services
This instructor-led course teaches students how to implement an Analysis Services solution in an organization. The course discusses how to use the Analysis Services development tools to create an Analysis Services database and an OLAP cube, and how to use the Analysis Services management and administrative tools to manage an Analysis Services solution.
Module objectives:
- Describe how SQL Server Analysis Services can be used to implement analytical solutions.
- Create multidimensional analysis solutions with SQL Server Analysis Services.
- Implement dimensions and cubes in an Analysis Services solution.
- Implement measures and measure groups in an Analysis Services solution.
- Query a multidimensional Analysis Services solution.
- Customize an Analysis Services cube.
- Deploy and secure an Analysis Services database.
- Maintain a multidimensional Analysis Services solution.
- Implement a Data Mining solution.
Module II of III
Course 6235: Implementing and Maintaining Microsoft SQL Server 2008 Integration Services
This instructor-led course teaches students how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages.
Module objectives:
- Describe SQL Server Integration Services and its tools.
- Create an Integration Services package.
- Implement control flow in an Integration Services package.
- Implement data flow in an Integration Services package.
- Implement logging in an Integration Services package.
- Debug and implement error handling in an Integration Services package.
- Implement checkpoints and transactions in an Integration Services package.
- Deploy an Integration Services package.
- Manage and secure an Integration Services package.
Module III of III
Course 6236: Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services Boot Camp
This two-day instructor-led course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution.
Module objectives:
- Describe SQL Server Reporting Services and its components.
- Create a Reporting Services report.
- Enhance a Reporting Services report.
- Create and manipulate data sets.
- Use report models to implement reporting for business users.
- Configure report publishing and execution settings.
- Implement subscriptions for reports.
- Administer Reporting Services.
- Implement custom Reporting Services applications.