SQl Server 2005 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 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
• Managing  report  subscriptions

SQL Server 2005 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

• Deploying an Analysis Services Database
• 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

Administering reporting services

• Server administration
• Performance and reliability monitoring
• Administering  report server databases
• Security administration

Programming reporting services

• Querying for server information using a web service
• Automating report management
• Rendering reports
• Creating custom code

SQL Server

o    Introduction to SQL server

o    Introduction to T-SQL

o    Constraints

o    Joins

o    Functions

o    Views

o    Indexes

o    Stored Procedures

o    Cursors

o    Triggers

Difference Between ORACLE & SQL Server

SQL Queries