The MCTS: SQL Server 2008 Business Intelligence (BI) Boot Camp is an instructor led fundamental course that focuses on Microsoft SQL Server Integration Services, Analysis Services, and Reporting Services. It is an intensive program designed for IT professionals with solid fundamental SQL Server experience. The Boot Camp hours are from 8:00 AM to 6:00 PM, Monday through Friday.
This course discusses how to use the BI development tools to create Analysis Services databases, OLAP cubes, Integration Services packages, Reporting solutions and how to use the SQL Server 2008 management and administrative tools to manage Microsoft SQL Server 2008 BI solutions. We will also look at the comparison/contrast between the SQL 2005 and SQL 2008 versions.
The boot camp provides students with the knowledge and the skills that are required to take Microsoft Exam 70-448 (Microsoft SQL Server 2008 Business Intelligence - Implementation and Maintenance). Students will receive Transcender self-paced test prep software. The test-prep software provides a realistic simulation of the Microsoft certification exam to help prepare the student to apply the knowledge taught in class for the exam.
This intense Boot Camp is designed for IT professionals with solid fundamental SQL Server experience.
Return to Top
Before beginning this course, students must have:
- Exposure to Data Import/Export Scenarios
- Conceptual Understanding of OLAP Solutions
- Exposure to Report Creation (Access, Crystal, Etc,...)
- Experience with Windows Services
- Experience with Service Accounts and Permissions
- Experience with Navigating the Microsoft SQL Server (SQL Queries, SQL Server Agent, SQL Systems Tables, SQL Accounts)
Return to Top
Microsoft Exam 70-448 (Microsoft SQL Server 2008 Business Intelligence - Implementation and Maintenance)
Return to Top
The student kit includes a comprehensive workbook and other necessary materials
for this class.
Return to Top
Section One: Microsoft SQL Server 2008 Integration Services
Lesson 1: Introduction to SQL Server 2008 Integration Services
- Overview of SQL Server Integration Services
- Using Integration Services Tools
Lesson 2: Developing Integration Services Solutions
- Creating an Integration Services Solution
- Using Variables
- Building and Running a Solution
Lesson 3: Implementing Control Flow
- Control Flow Tasks
- Control Flow Precedent Constraints
- Control Flow Containers
Lesson 4: Implementing Data Flow
- Data Flow Sources and Destinations
- Basic Data Flow Transformations
- Advanced Data Flow Transformations
- Data Flow Paths
Lesson 5: Implementing Logging
- Overview of Integration Services Logging
- Using Logging
Lesson 6: Debugging and Error Handling
- Debugging a Package
- Implementing Error Handling
Lesson 7: Implementing Checkpoints and Transactions
- Implementing Checkpoints
- Implementing Transactions
Lesson 8: Configuring and Deploying Packages
- Package Configurations
- Preparing and Deploying Packages
Lesson 9: Managing and Securing Packages
- Managing Packages
- Securing Packages
Section Two: Microsoft SQL Server 2008 Analysis Services
Lesson 1: Introduction to Microsoft SQL Server 2008 Analysis Services
- Overview of Data Analysis Solutions
- Overview of SQL Server Analysis Services
- Installing SQL Server Analysis Services
Lesson 2: Creating Multidimensional Analysis Solutions
- Developing Analysis Services Solutions
- Creating Data Sources and Data Source Views
- Creating a Cube
Lesson 3: Working with Cubes and Dimensions
- Configuring Dimensions
- Defining Attribute Hierarchies
- Sorting and Grouping Attributes
Lesson 4: Working with Measures and Measure Groups
- Working With Measures
- Working with Measure Groups
Lesson 5: Querying Multidimensional Analysis Solutions
- MDX Fundamentals
- Adding Calculations to a Cube
Lesson 6: Customizing Cube Functionality
- Implementing Key Performance Indicators (KPI)
- Implementing Actions
- Working with Perspectives
- Working with Translations
Lesson 7: Deploying and Securing an Analysis Services Database
- Deploying an Analysis Services Database
- Securing an Analysis Services Database
Lesson 8: Maintaining a Multidimensional Solution
- Configuring Processing
- Logging, Monitoring, and Optimizing an Analysis Services Solution
- Backing Up and Restoring an Analysis Services Database
Lesson 9: Introduction to Data Mining
- Overview of Data Mining
- Creating a Data Mining Solution
- Validating Data Mining Models
Section Three: Microsoft SQL Server 2008 Reporting Services
Lesson 1: Introduction to Microsoft SQL Server 2008 Reporting Services
- Overview of SQL Server Reporting Services
- Installing Reporting Services
- Reporting Services Tools
Lesson 2: Authoring Basic Reports
- Creating a Basic Table Report
- Formatting Report Pages
- Calculating Values
Lesson 3: Enhancing Basic Reports
- Interactive Navigation
- Displaying Data
Lesson 4: Manipulating Data Sets
- Defining Report Data
- Using Parameters and Filters
- Using Parameter Lists
Lesson 5: Using Report Models
- Creating Report Models
- Using Report Builder
Lesson 6: Publishing and Executing Reports
- Publishing Reports
- Executing Reports
- Creating Cached Instances
- Creating Snapshots and Report History
Lesson 7: Using Subscriptions to Distribute Reports
- Introduction to Report Subscriptions
- Creating Report Subscriptions
- Managing Report Subscriptions
Lesson 8: Administering Reporting Services
- Reporting Server Administration
- Performance and Reliability Monitoring
- Administering Report Server Databases
- Security Administration
- Upgrading to Reporting Services 2008
Lesson 9: Programming Reporting Services
- Querying for Server Information Using a Web Service
- Automating Report Management
- Rendering Reports
- Creating Custom Code
Microsoft SQL Server 2008 Business Intelligence MegaLab
