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