Course Detail 
BC-BI2791-3-MCTS SQL - MCTS: SQL Server 2005 Business Intelligence Learning and Certification Boot Camp  
Schedule
DateDayStart TimeEnd TimeDaysLocationRequest InfoRegistration
False2010/09/062010/09/1009:0017:00104b3bcf-48a0-472d-9778-cfa9ea84ab8f09/06/2010
09/07/2010
09/08/2010
09/09/2010
09/10/2010
Monday
Tuesday
Wednesday
Thursday
Friday
9:00 AM
9:00 AM
9:00 AM
9:00 AM
9:00 AM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5New Jerseyrequest inforegister
False2010/09/132010/09/1709:0017:006f5a93ef-5118-4623-a20b-3813e68a11f809/13/2010
09/14/2010
09/15/2010
09/16/2010
09/17/2010
Monday
Tuesday
Wednesday
Thursday
Friday
9:00 AM
9:00 AM
9:00 AM
9:00 AM
9:00 AM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5New York City-Midtownrequest inforegister
False2010/09/202010/09/2409:0017:00cb7514dc-2cdb-4cb1-a97e-bf6596bec75f09/20/2010
09/21/2010
09/22/2010
09/23/2010
09/24/2010
Monday
Tuesday
Wednesday
Thursday
Friday
9:00 AM
9:00 AM
9:00 AM
9:00 AM
9:00 AM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5New Jerseyrequest inforegister
False2010/10/112010/10/1509:0017:002c6df756-dc0a-4d45-b4b2-405fda880a0710/11/2010
10/12/2010
10/13/2010
10/14/2010
10/15/2010
Monday
Tuesday
Wednesday
Thursday
Friday
9:00 AM
9:00 AM
9:00 AM
9:00 AM
9:00 AM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5New Jerseyrequest inforegister
False2010/10/182010/10/2209:0017:00a06e6986-33af-42f1-a424-cf65b3ad181b10/18/2010
10/19/2010
10/20/2010
10/21/2010
10/22/2010
Monday
Tuesday
Wednesday
Thursday
Friday
9:00 AM
9:00 AM
9:00 AM
9:00 AM
9:00 AM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5New York City-Midtownrequest inforegister
False2010/10/252010/10/2909:0017:009d34a153-9aff-4553-ac89-92e9eac7ccf310/25/2010
10/26/2010
10/27/2010
10/28/2010
10/29/2010
Monday
Tuesday
Wednesday
Thursday
Friday
9:00 AM
9:00 AM
9:00 AM
9:00 AM
9:00 AM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5New Jerseyrequest inforegister
False2010/11/082010/11/1209:0017:0076ba5ee9-28b3-477a-9ef6-33a9ee09198f11/08/2010
11/09/2010
11/10/2010
11/11/2010
11/12/2010
Monday
Tuesday
Wednesday
Thursday
Friday
9:00 AM
9:00 AM
9:00 AM
9:00 AM
9:00 AM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5New Jerseyrequest inforegister
False2010/11/152010/11/1909:0017:00e29b6e6d-cdc1-4b96-b513-9c2e935f53ae11/15/2010
11/16/2010
11/17/2010
11/18/2010
11/19/2010
Monday
Tuesday
Wednesday
Thursday
Friday
9:00 AM
9:00 AM
9:00 AM
9:00 AM
9:00 AM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5New York City-Midtownrequest inforegister
False2010/11/222010/11/2609:0017:00b5445b51-20c3-4ccc-8921-357a8820717811/22/2010
11/23/2010
11/24/2010
11/25/2010
11/26/2010
Monday
Tuesday
Wednesday
Thursday
Friday
9:00 AM
9:00 AM
9:00 AM
9:00 AM
9:00 AM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5New Jerseyrequest inforegister
False2010/12/062010/12/1009:0017:004656047d-e2ee-4e7d-9a68-2b6e32d1bc0e12/06/2010
12/07/2010
12/08/2010
12/09/2010
12/10/2010
Monday
Tuesday
Wednesday
Thursday
Friday
9:00 AM
9:00 AM
9:00 AM
9:00 AM
9:00 AM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5New Jerseyrequest inforegister
False2010/12/132010/12/1709:0017:00ade45af0-a971-4c12-a416-3b85649cb65e12/13/2010
12/14/2010
12/15/2010
12/16/2010
12/17/2010
Monday
Tuesday
Wednesday
Thursday
Friday
9:00 AM
9:00 AM
9:00 AM
9:00 AM
9:00 AM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5New York City-Midtownrequest inforegister
False2010/12/202010/12/2409:0017:00e2bc297a-d80a-4f8d-8f52-b81cd5c2f66612/20/2010
12/21/2010
12/22/2010
12/23/2010
12/24/2010
Monday
Tuesday
Wednesday
Thursday
Friday
9:00 AM
9:00 AM
9:00 AM
9:00 AM
9:00 AM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5New Jerseyrequest inforegister
Untitled Document

MCTS: SQL Server 2005 Business Intelligence Learning and Certification Boot Camp

Course Code: BC-BI2791-3

Exam: 70-445-TS: Microsoft SQL Server 2005 Business Intelligence – Implementation and Maintenance

5 Day Instructor-led Bootcamp

Introduction

The Technology Specialist certifications enable professionals to target specific technologies and distinguish themselves by demonstrating in-depth knowledge and expertise in their specialized technologies. Microsoft Certified Technology Specialists in Microsoft SQL Server 2005 Business Intelligence (MCTS: SQL Server 2005 BI) 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.

This boot camp event includes a test voucher for Technology Specialist exam 70-445, customized Microsoft Official Courseware, test prep material for the exam, and catered lunch and dinner on each day. A test center will be open on testing days until 8 PM for your testing convenience.

Training begins at 8 AM on each day and ends at 8 PM.

Module I of III

2791- Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services

The purpose of this Module of the SQL Server 2005 Business Intelligence Learning and Certification Boot Camp is to teach 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.

After completing this module, students will be able to:

After completing this course, students will be able to:

• Describe how SQL Server Analysis Services can be used to implement analytical solutions.
• Create multidimensional analysis solutions with SQL Server Analysis Services.
• Implement dimensions 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

2792- Implementing and Maintaining Microsoft SQL Server 2005 Integration Services

This module teaches Business Intelligence (BI) professionals how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages.

After completing this course, students will be able to:

• 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

2793- Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services

In this module students learn 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.

After completing this module, students will be able to: