Advanced SQL Server DBA

SQL server 2008 administration

The primary goal is this course is to prepare the students to administer complex SQL Server databases. This SQL Server DBA course in Chennai is designed to provide SQL Server professionals with an in-depth understanding of the DBA features of SQL Server and T-SQL syntax for the DBA.

Course Content:

Level: 3 High Availability & Capacity Planning (3 Days) SQL Server

               2005 Scale up & Scale out technologies

  • Server Consolidation
  • SQL Server 64-bit
  • Memory Management
  • Linked Servers

Maintaining High Availability

  • Introduction to High Availability
  • Implementing Log Shipping
  • Implementing Database Mirroring
  • Database Snapshot
  • Data Partitioning
  • Online Indexing

Maintaining High Availability with Clustering

  • Hardware and Software Requirements
  • Installing and Configuring SQL Server Cluster
  • Types of Clusters
  • Cluster Groups and Resources
  • Adding a node to existing SQL Server cluster
  • Applying Service Packs and Cumulative Updates

(c) 2013 Sakthi Software Solutions Pvt.Ltd. All Rights Reserved