Levi, Ray & Shoup, Inc.
  • Courses
  • Site Content

MS-40008 - Updating your Database Skills to Microsoft SQL Server 2012

This three-day instructor-led course provides existing SQL Server database professionals with the knowledge and skills to use new and enhanced capabilities in SQL Server 2012.

Click here to print this page »

Prerequisites


Before attending this course, students must have:
  • Experience of creating and managing database solutions in SQL Server, including basic Transact-SQL programming.

Detailed Class Syllabus


Module 1: Introducing SQL Server 2012


Overview of SQL Server 2012
SQL Server 2012 Editions and Components

Module 2: Installing SQL Server 2012


Installation Options and Requirements
Installing SQL Server
Deploying SQL Server in a Private Cloud

Module 3: Managing SQL Server 2012


Enhancements to SQL Server Management Studio
New and Enhanced Dynamic Management Views
Using PowerShell to Manage SQL Server

Module 4: Developing SQL Server 2012 Databases


Transact-SQL Enhancements
New and Enhanced Transact-SQL Functions
Enhancements to Spatial Data Support
Storing and Querying Documents

Module 5: Performance and Tuning Enhancements


Performance Optimization Tools
Enhancements to Indexing

Module 6: High Availability and Data Recovery Enhancements


AlwaysOn High Availability
Enhancemenst to Data Recovery

Module 7: Implementing Security in Microsoft SQL Server 2012


Security Management Enhancements
Contained Databases

Module 8: Extending Data Solutions to the Cloud


Introduction to SQL Azure
Working with SQL Azure

Module 9: Overview of BI Enhancements in SQL Server 2012


SQL Server 2012 for Data Warehousing
SQL Server 2012 for Business Intelligence