Microsoft SQL Server 2008: Business Intelligence Bootcamp

Course Overview

Students will learn 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 tools to manage MS SQL Server 2008 BI solutions.

On completion of this Microsoft training course, delegates will be more proficient in SQL Server skills

Related Courses

• Microsoft SQL Server 2008 New Features: Hands-On
• Microsoft SQL Server 2008 Comprehensive Introduction: Hands-On
• Microsoft SQL Server 2008: Database Administration
• Microsoft SQL Server 2008 Training Course UK: Comprehensive DBA & Programming Upgrade
• Microsoft SQL Server 2008 Analysis & Integration Services (SSAS & SSIS) - (Business Intelligence, BI, Data Warehouse, Mining)
• Microsoft SQL Server 2008 Reporting Services (SSRS) - (Business Intelligence, BI)
• Microsoft SQL Server 2008: Business Intelligence with SQL Server 2008 - (Microsoft, BI, SSRS, SSAS, SSIS, Data Warehouse, Mining)
• Microsoft SQL Server 2008: Maintaining a Microsoft SQL Server 2008 Database
• Microsoft SQL Server 2008 Reporting Services: Hands-On
• Microsoft SQL Server 2008: Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services

Audience

This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries.

Skills Gained

At Course Completion:

After completing this course, students will be able to: - Describe the uses of and ways to execute the Transact-SQL language. - Use querying tool. - Write SELECT queries to retrieve data. - Group and summarize data by using Transact-SQL. - Join data from multiple tables. - Write queries that retrieve and modify data by using subqueries. - Modify data in tables. - Query text fields with full-text search. - Describe how to create programming objects. - Use various techniques when working with complex queries.

Course Outline

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

Lesson 10: 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 11: Creating Multidimensional Analysis Solutions

• Developing Analysis Services Solutions
• Creating Data Sources and Data Source Views
• Creating a Cube

Lesson 12: Working with Cubes and Dimensions

• Configuring Dimensions
• Defining Attribute Hierarchies
• Sorting and Grouping Attributes

Lesson 13: Working with Measures and Measure Groups

• Working With Measures
• Working with Measure Groups

Lesson 14: Querying Multidimensional Analysis Solutions

• MDX Fundamentals
• Adding Calculations to a Cube

Lesson 15: Customizing Cube Functionality

• Implementing Key Performance Indicators (KPI)
• Implementing Actions
• Working with Perspectives
• Working with Translations

Lesson 16: Deploying and Securing an Analysis Services Database

• Deploying an Analysis Services Database
• Securing an Analysis Services Database

Lesson 17: Maintaining a Multidimensional Solution

• Configuring Processing
• Logging, Monitoring, and Optimizing an Analysis Services Solution
• Backing Up and Restoring an Analysis Services Database

Lesson 18: Introduction to Data Mining

• Overview of Data Mining
• Creating a Data Mining Solution
• Validating Data Mining Models

Lesson 19: Introduction to Microsoft SQL Server 2008 Reporting Services

• Overview of SQL Server Reporting Services
• Installing Reporting Services
• Reporting Services Tools

Lesson 20: Authoring Basic Reports

• Creating a Basic Table Report
• Formatting Report Pages
• Calculating Values

Lesson 21: Enhancing Basic Reports

• Interactive Navigation
• Displaying Data

Lesson 22: Manipulating Data Sets

• Defining Report Data
• Using Parameters and Filters
• Using Parameter Lists

Lesson 23: Using Report Models

• Creating Report Models
• Using Report Builder

Lesson 24: Publishing and Executing Reports

• Publishing Reports
• Executing Reports
• Creating Cached Instances
• Creating Snapshots and Report History

Lesson 25: Using Subscriptions to Distribute Reports

• Introduction to Report Subscriptions
• Creating Report Subscriptions
• Managing Report Subscriptions

Lesson 26: Administering Reporting Services

• Reporting Server Administration
• Performance and Reliability Monitoring
• Administering Report Server Databases
• Security Administration
• Upgrading to Reporting Services 2008

Lesson 27: Programming Reporting Services

• Querying for Server Information Using a Web Service
• Automating Report Management
• Rendering Reports
• Creating Custom Code