MCTS: SQL Server 2008, Business Intelligence Development and Maintenance Boot Camp

	Enroll Online Schedules & Pricing Financing

Duration: 6 days

The Academy of South Florida is proud to be the #1 Microsoft Gold Certified Partner for Learning Solutions (CPLS) in Florida.  

Outline:

6234: Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services Boot Camp

1. Introduction to Microsoft SQL Server Analysis Services

2. Creating Multidimensional Analysis Solutions

3. Working with Cubes and Dimensions

4. Working with Measures and Measure Groups

5. Querying Multidimensional Analysis Solutions

6. Customizing Cube Functionality

7. Deploying and Securing an Analysis Services Database

8. Maintaining a Multidimensional Solution

9. Introduction to Data Mining 

6235: Implementing and Maintaining Microsoft SQL Server 2008 Integration Services Boot Camp

1. Introduction to SQL Server 2008 Integration Services

2. Developing Integration Services Solutions

3. Implementing Control Flow

4. Implementing Data Flow

5. Implementing Logging

6. Debugging and Error Handling

7. Implementing Checkpoints and Transactions

8. Configuring and Deploying Packages

9. Managing and Securing Packages

6236: Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services Boot Camp

1. Introduction to Microsoft SQL Server Reporting Services

2. Authoring Basic Reports

3. Enhancing Basic Reports

4. Manipulating Data Sets

5. Using Report Models

6. Publishing and Executing Reports

7. Using Subscriptions to Distribute Reports

8. Administering Reporting Services

9. Programming Reporting Services

Materials:

MOC 6234

MOC 6235

MOC 6236

Completion:

At course completion, the student should be able to do the following:

•  Describe how SQL Server Analysis Services can be used to implementanalytical 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.

• 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.

• 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.

Pricing Information:

$2450.00 includes tuition and the following:

• Breakfast, Daily Snacks
• Exam vouchers
• Registration Fees
• Books and Materials

Your training may also be partially tax-deductible.
Please note – Tuition does not include airfare, hotel or transportation to the Boot Camp.


Academy Code of Honor  
The Academy guarantees that students shall pass all vendor examinations during the training program or may re-attend within one year of the program completion date. Students will only be responsible for accommodations and vendor exam fees.                     

Please call 1-(800) 482-2233 or Sales@academyflorida.com to arrange for a special delivery of this course. Most classes require a minimum of 2 to be taught. Group discounts are available for larger groups at client’s request. On-site or private classes are also available at clients request in Florida or throughout the entire US. Clients may also qualify for free training through our state funded programs. If you do not see a class listed in our schedules, please contact THE ACADEMY with your request.

*These courses are only for Corporate Contract Training.

Disclaimer: The Academy offers training only in the field of Information Technology. The Academy does not offer, nor is it affiliated with any other entity that offers, training in any fields other than Information Technology.