Module 1: Introduction to SQL Server 2008 Integration Services
- Overview of SQL Server Integration Services
- Using Integration Services Tools
- Using the Import and Export Wizard
- Running an Integration Services Package
- Creating an Integration Services Solution
- Using Variables
- Building and Running a Solution
- Control Flow Tasks
- Control Flow Precedent Constraints
- Control Flow Containers
- Data Flow Sources and Destinations
- Basic Data Flow Transformations
- Advanced Data Flow Transformations
- Data Flow Paths
- Overview of Integration Services Logging
- Enabling and Configuring Logging
- Debugging a Package
- Implementing Error Handling
- Implementing Checkpoints
- Implementing Transactions
- Package Configurations
- Package Parameters
- Deploying Packages
- Managing Packages
- Securing Packages
- What is Analysis Services Tabular Model?
- How to create Azure Analysis Service Tabular model project
- What is Workspace Database?
- Import Data
- Direct Query Mode
- Tables and Columns
- Relationships
- Calculations
- Measures
- KPIs
- Hierarchies
- Partitions
- Perspectives
- Translations
- Roles
- Deployment of Tabular Project
- What is Analysis Services Tabular Model?
- How to create Azure Analysis Service Tabular model project
- What is Workspace database
- Import Data
- Direct Query Mode
- Tables and Columns
- Relationships
- Calculations
- Measures
- KPIs
- Hierarchies
- Partitions
- Perspectives
- Translations
- Roles
- Deployment of Tabular Project
Module 1: Introduction to Microsoft SQL Server Reporting Services
- Overview of SQL Server Reporting Services
- Installing Reporting Services
- Reporting Services Tools
- Creating a Basic Table Report
- Formatting Report Pages
- Calculating Values
- Interactive Navigation
- Displaying Data
- Defining Report Data
- Using Parameters and Filters
- Using Parameter Lists
- Creating Report Models
- Using Report Builder
- Publishing Reports
- Executing Reports
- Creating Cached Instances
- Creating Snapshots and Report History
- Introduction to Report Subscriptions
- Creating Report Subscriptions
- Managing Report Subscriptions
- Reporting Server Administration
- Performance and Reliability Monitoring
- Administering Report Server Databases
- Security Administration
- Upgrading to Reporting Services 2008
- Querying for Server Information Using a Web Service
- Automating Report Management
- Rendering Reports
- Duration 30 Hours
- Students 21
- Days 40 Days
- Resume Preparation Yes
- Interview Guidance Yes