IT Online Training and Placements in USA    info@verizontechit.com   +1 (512) 515 9015

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

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