MS SQL Server 2008 Online Training Course content

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

Security

Automating Administrative Tasks

Monitoring SQL Server

Module: 4
High Availability and Replication

T-Log Architecture

Backup & Restore:

Log Shipping

Database Mirroring

Replication

Clustering SQL server

Module: 5
Performance Tuning & Indexing

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