Total Hours: 40

SQL Server Integration Services (SSIS)

Module 1: Introduction to SQL Server Integration Services
  • Overview of SQL Server Integration Services
  • Using Integration Services Tools

Module 2: Developing Integration Services Solutions
  • Creating an Integration Services Solution
  • Using Variables
  • Building and Running a Solution

Module 3: Implementing Control Flow
  • Control Flow Tasks
  • Control Flow Precedent Constraints
  • Control Flow Containers

Module 4: Implementing Data Flow
  • Data Flow Sources and Destinations
  • Basic Data Flow Transformations
  • Advanced Data Flow Transformations
  • Data Flow Paths

Module 5: Implementing Logging
  • Overview of Integration Services Logging
  • Enabling and Configuring Logging

Module 6: Debugging and Error Handling
  • Debugging a Package
  • Implementing Error Handling

Module 7: Implementing Checkpoints and Transactions
  • Implementing Checkpoints
  • Implementing Transactions

Module 8: Configuring and Deploying Packages
  • Package Configurations
  • Deploying Packages

Module 9: Managing and Securing Packages
  • Managing Packages
  • Securing Packages

SQL Server Analysis Services (SSAS)

Module 1: Introduction to Microsoft SQL Server Analysis Services
  • Overview of Data Analysis Solutions
  • Overview of SQL Server Analysis Services
  • Installing SQL Server Analysis Services

Module 2: Creating Multidimensional Analysis Solutions
  • Developing Analysis Services Solutions
  • Creating Data Sources and Data Source Views
  • Creating a Cube

Module 3: Working with Cubes and Dimensions
  • Configuring Dimensions
  • Defining Attribute Hierarchies
  • Sorting and Grouping Attributes

Module 4: Working with Measures and Measure Groups
  • Working with Measures
  • Working with Measure Groups

Module 5: Querying Multidimensional Analysis Solutions
  • MDX Fundamentals
  • Adding Calculations to a Cube

Module 6: Customizing Cube Functionality
  • Implementing Key Performance Indicators
  • Implementing Actions
  • Implementing Perspectives
  • Implementing Translations

Module 7: Deploying and Securing an Analysis Services Database
  • Deploying an Analysis Services Database
  • Securing an Analysis Services Database

Module 8: Maintaining a Multidimensional Solution
  • Configuring Processing
  • Logging, Monitoring, and Optimizing an Analysis Services Solution
  • Backing Up and Restoring an Analysis Services Database

Module 9: Introduction to Data Mining
  • 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
  • Overview of SQL Server Reporting Services
  • Installing Reporting Services
  • Reporting Services Tools

Module 2: Authoring Basic Reports
  • Creating a Basic Table Report
  • Formatting Report Pages
  • Calculating Values

Module 3: Enhancing Basic Reports
  • Interactive Navigation
  • Displaying Data

Module 4: Manipulating Data Sets
  • Defining Report Data
  • Using Parameters and Filters
  • Using Parameter Lists

Module 5: Using Report Models
  • Creating Report Models
  • Using Report Builder

Module 6: Publishing and Executing Reports
  • Publishing Reports
  • Executing Reports
  • Creating Cached Instances
  • Creating Snapshots and Report History

Module 7: Using Subscriptions to Distribute Reports
  • Introduction to Report Subscriptions
  • Creating Report Subscriptions
  • Managing Report Subscriptions

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

Module 9: Programming Reporting Services
  • Querying for Server Information Using a Web Service
  • Automating Report Management
  • Rendering Reports
  • Creating Custom Code