Dear Professional,
AS part of OnoSoft's Corporate trainings,We cover the below mentioned content of SQL Server 2005.Our experts are continuous learners and adding daily new contents to this
SQL-SERVER-2005 Level - I Contents
New Features in SQL Server 2005
New Enhancements in Programming Constructs
Stored Procedures, Triggers, Cursors
Tools to work with MS SQL Server 2005
Using .NET Code in SQL Server 2005
SQL-SERVER-2005 Level - II Contents
Advanced Query Techniques
Full-Text Search
Generating XML with FOR XML
Creating Recursive Queries
Creating Pivot Queries
Executing Dynamic SQL
Understanding and Implementing Security
Analyzing and Tuning Performance
Monitoring and trouble shooting SQL Server performance using SQL Profiler
--Programming Replication
Overview of SQL Server Replication
Replication Programming Interfaces
Configuring Replication
Synchronizing Data
-- Clustering
-- Database Mirroring
-- Database Tuning
-- Log Shipping
--About SSIS
-- Dataflow Elements
-- Error Handling and Login
-- SSIS Tools
Business Intelligence Development Studio
Solution Explore Windows
Package Designer
-- SSIS Tasks
Execute SQL Task
Data Flow Task
Script and ActiveX Tasks
Web Service Task
WMI Data Reader and Event Watcher Task
XML Task...
-- Creating an END-to-End Package
-- Scripting in SSIS
-- Integration Services Engine
-- Programming and Extending SSIS
--About SSRS
Reporting Lifecycle
Designing Reports
Application and Reporting Technology
Reporting Solution Alternatives
Formatting
Pagination Control
Reporting Services Integration
Reporting Services Web Services