SQl Server Integration Servers (SSIS)
- Over view of Integration Services Solutions
- Integration Services Tools
- Developing Integration Services Solution
- Creating an integration services solution
- Using Variables
- Building and Running a Solution
- Implementing Control Flow
- Control flow Tasks
- Control Flow Precedence Constraints
- Control Flow Containers
- Implementing Data Flow
- Data Flow Sources and Destinations
- Data Flow Transformations
- Data Flow Paths
- Implementing Logging Debugging and Error Handling
- Overview of Integration Services Logging
- Implementing Logging
- Debugging a package
- Implementing Error Handling
- Implementing Checkpoints & Transactions
- Implementing Checkpoints
- Implementing Transactions
- Deploying Packages
- Package Configurations
- Deploying Packages
- Managing and Securing Packages
- Managing Packages
- Securing Packages
- Scheduling Jobs
SQL Server Analysis Services (SSAS)
- Overview of Data Analysis Solutions
- Overview of SQL server 205 Analysis Services
- Creating Multidimensional Analysis Solutions
- Developing Analysis Services Solutions
- Data Sources and Data Source Views
- Creating a Cube
- Working with Dimensions
- Configuring Dimensions
- Defining Hierarchies
- Sorting and Grouping Attributes
- Working with Measures
- Working with Measure groups
- Analytical MDX
- Analytical MDX Introduction
- MDX queries MDx vs.SQl
- MDX Stored Procedures
- Adding Calculations to a Cube
- Customizing Cube Functionality
- Implementing key Performance Indicator
- Implementing Actions
- Implementing Perspectives
- Implementing Translations
- Deploying and Securing an Analysis Services Database
- Maintaining a Multidimensional Solution
- Configuring Processing Settings
- Logging ,Monitoring and Optimizing an Analysis Services Solution
- Backing Up and Restoring an Analysis
- Services Database
SQL Server Reporting Services (SSRS)
- Overview of SQL Server Reporting Services
- Installing Reporting Services
- Reporting Services Tools
- Authoring Basic Reports
- Creating a Basic Table Report
- Formatting Report Pages
- Calculating Values
- Enhancing Basic Reports
- Interactive Navigation
- Displaying Data
- Manipulating Data Sets
- Defining Report Data
- Using Parameters and Filters
- Using parameter lists
- Using report models
- Creating report models
- Using report builder
- Publishing and executing reports
- Publishing report
- Executing reports
- Creating cached instances
- Creating snapshots and report history
- Using subscriptions to distribute reports
- Introduction to report subscriptions
- Creating report subscriptions
|