Business-Intelligence SQL Server Bootcamp
Sunday, 23 January 2011 05:03
Last Updated on Tuesday, 01 November 2011 17:47
Attend 6 days to get certified as:
MCTS: SQL Server 2008, Business Intelligence Development and Maintenance
Exams include:
Boot Camp format
Boot Camp runs 8am – 7pm each day Monday – Saturday
All classes are hands on with our expert Microsoft Certified SQL Server instructor.
What you will receive:
- SQL Server Library of Books including:
- Microsoft SQL Server 2008 Reporting Services ISBN – 0071548084
- Microsoft SQL Server 2008 Integration Services ISBN - 0470496924
- Delivering Business Intelligence with Microsoft SQL Server 2008 ISBN – 0071549447
- The Microsoft Data Warehouse Toolkit: With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset ISBN - 0470640383
- Microsoft Official SQL Server Courseware for:
- 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
- All meals:
- Continental Breakfast
- Lunch
- Dinner
Prerequisites
Participants should be have the following before beginning the course:
- 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 Microsoft SQL Server (SQL Queries, SQL Server Agent, SQL Systems Tables, SQL Accounts)
Boot Camp Outline
Day One: Course 6235 - 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
Day Two: Course 6235 (cont'd)
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
Day Three: Course 6234 - Microsoft SQL Server 2008 Analysis Services
Lesson 1: Creating Multidimensional Analysis Solutions
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
Day Four: Course 6234 (cont'd)
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
Day Five: Course 6236 - 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
Day Six: Course 6236 (cont'd)
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
Exam: 70-448 (Microsoft SQL Server 2008 Business Intelligence - Implementation and Maintenance)