Microsoft SQL Server 2012 Administration

CloudLabs

Projects

Assignment

24x7 Support

Lifetime Access

.

Course Overview

SQL Server 2012 is Microsoft’s latest cloud-ready information platform. Organizations can use SQL Server 2012 to efficiently protect, unlock, and scale the power of their data across the desktop, mobile device, datacenter, and either a private or public cloud.

At the end of the training, participants will be able to:

Pre-requisite

  1. Attendees should be comfortable with Windows server architecture.
  2. Experience of programming and/or XML.

Duarion

5  days

Course Outline

  • Introduction to SQL Server 2012
  • SQL Server 2012 Editions & Capacity Planning
  • Pages & Extents
  • Files and File groups
  • Thread and Task Architecture
  • Memory Architecture
  • T-Log Architecture
  • SQL server 2012 Installation
  • Upgrading to SQL server 2008 R2/2012
  • Managing services
  • Configuring SQL Server 2012
  • Migrating SQL server
  • Automating Administrative Tasks
  • Monitoring SQL Server
  • Security
  • Backup & Restore
  • Log Shipping
  • Database Mirroring
  • AlwaysOn Availability Groups
  • Replication
  • Windows Server 2012 Clustering
  • Installing SQL Server 2012 Fail-Over Clustering
  • Administering a SQL Server 2012 Failover Cluster
  • High Availability: Interoperability and Coexistence
  • Optimizing SQL server
  • Indexing
  • Locking & Concurrency
  • Performance Tuning

Reviews