IT Online Training and Placements in USA    +1 (703)348 9497

Microsoft Online Training

MS Exchange Server 2003, BizTalk Server, MS Office Sharepoint 2007


Courses » Microsoft Courses » Microsoft SQL Server 2008 Online Training


Microsoft SQL Server 2008 Online Training


Module: 1

SQL Server Architecture

Introduction to SQL Server 2008 Overview on RDBMS and Beyond Relational

SQL Server Component Overview

Pages & Extents

Files and File groups

Memory Architecture

Thread and Task Architecture

Module: 2
Installing, Upgrading, Configuration, Managing services & Migration

SQL server 2005/2008 Installation

Upgrading to SQL server 2005/2008

Configuring SQL Server

Managing services

Migrating SQL server

Module: 3
Security, Automation & Monitoring


Automating Administrative Tasks

Monitoring SQL Server

Module: 4
High Availability and Replication

T-Log Architecture

Backup & Restore:

Log Shipping

Database Mirroring


Clustering SQL server

Module: 5
Performance Tuning & Indexing


Performance Tuning

Practical Trouble shooting on Performance

Case Study A: Performance Counters Setup-Collect-Analyze

Case Study B: Performance Counters- Thresholds

Case Study C: Performance Tuning on OLAP processing

Module: 6
Corporate awareness and Handling the environment