SQl Server 2005 Integration Servers (SSIS)
o Over view of Integration Services Solutions
o Integration Services Tools
Developing Integration Services Solution
o Creating an integration services solution
o Using Variables
o Building and Running a Solution
Implementing Control Flow
o Control flow Tasks
o Control Flow Precedence Constraints
o Control Flow Containers
Implementing Data Flow
o Data Flow Sources and Destinations
o Data Flow Transformations
o Data Flow Paths
Implementing Logging Debugging and Error Handling
o Overview of Integration Services Logging
o Implementing Logging
o Debugging a package
o Implementing Error Handling
Implementing Checkpoints & Transactions
o Implementing Checkpoints
o Implementing Transactions
Deploying Packages
o Package Configurations
o Deploying Packages
Managing and Securing Packages
o Managing Packages
o Securing Packages
Scheduling Jobs
SQL Server Reporting Services (SSRS)
o Overview of SQL Server Reporting Services
o Installing Reporting Services
o Reporting Services Tools
Authoring Basic Reports
o Creating a Basic Table Report
o Formatting Report Pages
o Calculating Values
Enhancing Basic Reports
o Interactive Navigation
o Displaying Data
Manipulating Data Sets
o Defining Report Data
o Using Parameters and Filters
o Using parameter lists
Using report models
o Creating report models
o Using report builder
Publishing and executing reports
o Publishing report
o Executing reports
o Creating cached instances
o Creating snapshots and report history
Using subscriptions to distribute reports
o Introduction to report subscriptions
o Creating report subscriptions
o Managing report subscriptions
SQL Server 2005 Analysis Services (SSAS)
o Overview of Data Analysis Solutions
o Overview of SQL server 205 Analysis Services
Creating Multidimensional Analysis Solutions
o Developing Analysis Services Solutions
o Data Sources and Data Source Views
o Creating a Cube
Working with Dimensions
o Configuring Dimensions
o Defining Hierarchies
o Sorting and Grouping Attributes
o Working with Measures
o Working with Measure groups
Analytical MDX
o Analytical MDX Introduction
o MDX queries MDx vs.SQl
o MDX Stored Procedures
o Adding Calculations to a Cube
Customizing Cube Functionality
o Implementing key Performance Indicator
o Implementing Actions
o Implementing Perspectives
o Implementing Translations
Deploying and Securing an Analysis Services Database
o Deploying an Analysis Services Database
o Securing an Analysis Services Database
Maintaining a Multidimensional Solution
o Configuring Processing Settings
o Logging ,Monitoring and Optimizing an Analysis Services Solution
o Backing Up and Restoring an Analysis
o Services Database
Administering reporting services
o Server administration
o Performance and reliability monitoring
o Administering report server databases
o Security administration
Programming reporting services
o Querying for server information using a web service
o Automating report management
o Rendering reports
o 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
e-Care technologies
The Director
No-24, 1st Floor, 2nd Main Cross Road,
Vinayaka Layout,
Near Multiplex, Munnekolala
OPP: SGR Dental College
Marthahalli, Bangalore - 37.
Contact no: +91 9844752189, 9845642721
