Skip Navigation Links

SQL Server 2012 for the DBA - Course Details
Video
Sorry a video will be coming soon
Snapshot of what you will learn

Click here for more info

Schedule
Cost
Instructor
Registration
07/23/2012 - 07/26/2012 9:00AM - 12:00PM$795Gareth SwanepoelRegister

Overview
SQL Server 2012 is the newest version of SQL Server available from Microsoft. This four day (half-day) course is designed to introduce SQL Server DBA’s to the new and exciting features available in that version. We use a variety of lab exercises to ensure lecture sessions are backed up by hands-on experience. With the hands-on labs, you will experience how the new features can be utilized in your everyday DBA work. This course will cover topics such as AlwaysOn, column store indexes, SQL Server Data Tools, the FileTable feature, Azure and administering the BI platform within the context of SQL Server 2012.

Duration
4 Days

Location
Online

Prerequisites
The target of this class is SQL Server DBA’s, developers, architects or IT professionals who have average to good T-SQL skills already. This class assumes that you have a good understanding of SQL Server fundamentals. For example, you should know and use the SQL Server Management Studio (SSMS) interface and associated toolbox items before attending this class. It is not mandatory but some experience using the Business Intelligence Design Studio (BIDS) interface will be an advantage to you.

Cancelation Policy

Description

Day 1 - Administration and Performance:

  • Deprecated and Discontinued features
    • Discontinued features
    • Features not supported in the next version of SQL Server (after 2012)
    • Features not supported in a future version of SQL Server
  • Column Store Indexes
  • DMV's & Extended Events
  • Security
    • Contained databases
    • Custom database roles
    • Auditing
  • SQLOS
    • Full-text search
    • Table partitioning
  • Central Management
  • DRU

Day 2 AlwaysOn and DR:

  • Availability Groups Setup
  • Using Availability Groups
    • Usage
    • Mirrored databases
    • Types of target databases
  • Clustering enhancements
  • DR Enhancements

Day 3 - Programmability & Azure:

  • SSDT (SQL Server Data Tools)
  • DAC Pac’s
  • T-SQL
  • FileTable
  • Azure

Day 4 - Administering the BI platform:

  • SSIS (IS Pac, etc)
  • SSAS Security
  • SSAS admin
    • Deploy
    • Configuration
    • Backup
  • SharePoint Admin
    • Content databases
    • Tuning
    • DR
  • Azure Reporting