Demo classes

Timings

Course contents

Remote Access

Fee Structure

Special discounts for Corporate/ Groups

Training from Ten plus years of SQL SERVER Expert and MCDBA and MCITP Certified

Training Highlights

Free Remote SERVERS ACCESS

3 Months free Tech Support for your job

Shared SQL Server resources

Free material

Free paid website access

Placement assistance

Resume preparation

Interview questions

Production DBA scripts

FTP site with full materials

Video Material and Quizzes

SQL SERVER 2005/2008 DBA Course Highlights

» SQL SERVER 2005/2008 PRODUCTION CLUSTER SETUP

» REPLICATION TECHNOLOGIES

» DISASTER RECOVERY SETUP

» SQL SERVER 2008 MIRRORING

» REALTIME PRODUCTION CRITICAL SCENARIOS

» REALTIME PRODUCTION PERFORMANCE AND TUNING ISSUES

» REBUILD MASTER AND RECOVER PRODUCTION DATABASES

» SQL SERVER INTEGRATION SERVICES (SSIS)

» SQL SERVER REPORTING SERVICES (SSRS)

» SQL SERVER ANALYSIS SERVICES (SSAS)

TSQL BI Developer Course Highlights

» FULL DEVELOPMENT CYCLE EXAMPLES

» Database Design and SQL SERVER 2008 PROGRAMMING FOR BACKEND DEVELOPER

» Data Modeling

» MORE THAN 50 SQL SERVER SCRIPTS

» SQL SERVER INTEGRATION SERVICES

» SQL SERVER REPORTING SERVICES

» project work for SSIS , SSRS and SSAS

SQL SERVER INTEGRATION SERVICES

» Introduction to the SSIS environment

» Tasks

» Drilling into the Data Flow

» Expressions and Variables

» Containers

» Advanced Tasks

» Event Handling and Logging in SSIS

» Migration from DTS

» Administrating SSIS

» Enterprise package development.

SQL SERVER REPORTING SERVICES

» SSRS Architecture and components

» Installation and Setup

» BIDS environment and the Report Designer IDE

» Report Development Lifecycle

» Reporting Services Report Designer

» Designing and Developing Reports with Reporting Services

» Report Deployment

» Report Builder

» Grouping and Sorting