Course Description
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.
- 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.
Agenda
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
Audience
This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries.
Comments
Virtual Microsoft SQL Server 2008 Business Intelligence Bootcamp Online Live training option
Imagine an industry-leading classroom training experience from wherever you have access to the Internet.
The Virtual Online Live events listed here gives you an effective and proven online virtual learning experience with the freedom to attend virtually from anywhere.
There is also an option of experiencing Online Live from one of the many national partner centers where a computer and headset will be provided for you.
This rich and engaging virtual classroom environment lets you conveniently interact with instructors and other students.
You will hear and see your instructor as they teach the course and answer your questions via voice or text.
Choose the online live virtual training option and you can access the recorded version even after the class has finished.
The onDemand labs give you access to the same client and server technologies covered in class so you can test, apply and hone your skills by accessing the labs before and even after the class.
Technical Requirements: a computer or laptop with a modern browser and high speed internet access along with one or two monitors.