SQL Server Integration Services (SSIS)
Module 1: Introduction to SQL Server 2008 Integration Services
Lessons
- Overview of SQL Server Integration Services
- Using Integration Services Tools
Module 2: Developing Integration Services Solutions
Lessons
- Creating an Integration Services Solution
- Using Variables
- Building and Running a Solution
Module 3: Implementing Control Flow
Lessons
- Control Flow Tasks
- Control Flow Precedent Constraints
- Control Flow Containers
Module 4: Implementing Data Flow
Lessons
- Data Flow Sources and Destinations
- Basic Data Flow Transformations
- Advanced Data Flow Transformations
- Data Flow Paths
Module 5: Implementing Logging
Lessons
- Overview of Integration Services Logging
- Enabling and Configuring Logging
Module 6: Debugging and Error Handling
Lessons
- Debugging a Package
- Implementing Error Handling
Module 7: Implementing Checkpoints and Transactions
Lessons
- Implementing Checkpoints
- Implementing Transactions
Module 8: Configuring and Deploying Packages
Lessons
- Package Configurations
- Deploying Packages
Module 9: Managing and Securing Packages
Lessons
- Managing Packages
- Securing Packages
SQL Server Analysis Services (SSAS)
Module 1: Introduction to Microsoft SQL Server Analysis Services
Lessons
- Overview of Data Analysis Solutions
- Overview of SQL Server Analysis Services
- Installing SQL Server Analysis Services
Module 2: Creating Multidimensional Analysis Solutions
Lessons
- Developing Analysis Services Solutions
- Creating Data Sources and Data Source Views
- Creating a Cube
Module 3: Working with Cubes and Dimensions
Lessons
- Configuring Dimensions
- Defining Attribute Hierarchies
- Sorting and Grouping Attributes
Module 4: Working with Measures and Measure Groups
Lessons
- Working With Measures
- Working with Measure Groups
Module 5: Querying Multidimensional Analysis Solutions
Lessons
- MDX Fundamentals
- Adding Calculations to a Cube
|
Module 6: Customizing Cube Functionality
Lessons
- Implementing Key Performance Indicators
- Implementing Actions
- Implementing Perspectives
- Implementing Translations
Module 7: Deploying and Securing an Analysis Services Database
Lessons
- Deploying an Analysis Services Database
- Securing an Analysis Services Database
Module 8: Maintaining a Multidimensional Solution
Lessons
- Configuring Processing
- Logging, Monitoring, and Optimizing an Analysis Services Solution
- Backing Up and Restoring an Analysis Services Database
Module 9: Introduction to Data Mining
Lessons
- Overview of Data Mining
- Creating a Data Mining Solution
- Validating Data Mining Models
SQL Server Reporting Services (SSRS)
Module 1: Introduction to Microsoft SQL Server Reporting Services
Lessons
- Overview of SQL Server Reporting Services
- Installing Reporting Services
- Reporting Services Tools
Module 2: Authoring Basic Reports
Lessons
- Creating a Basic Table Report
- Formatting Report Pages
- Calculating Values
Module 3: Enhancing Basic Reports
Lessons
- Interactive Navigation
- Displaying Data
Module 4: Manipulating Data Sets
Lessons
- Defining Report Data
- Using Parameters and Filters
- Using Parameter Lists
Module 5: Using Report Models
Lessons
- Creating Report Models
- Using Report Builder
Module 6: Publishing and Executing Reports
Lessons
- Publishing Reports
- Executing Reports
- Creating Cached Instances
- Creating Snapshots and Report History
Module 7: Using Subscriptions to Distribute Reports
Lessons
- Introduction to Report Subscriptions
- Creating Report Subscriptions
- Managing Report Subscriptions
Module 8: Administering Reporting Services
Lessons
- Reporting Server Administration
- Performance and Reliability Monitoring
- Administering Report Server Databases
- Security Administration
- Upgrading to Reporting Services 2008
Module 9: Programming Reporting Services
Lessons
- Querying for Server Information Using a Web Service
- Automating Report Management
- Rendering Reports
- Creating Custom Code
|
