M40008 - Updating your Database Skills to Microsoft SQL Server 2012

This module provides an overview of SQL Server 2012.

• Overview of SQL Server 2012
• SQL Server 2012 Editions and Components

This module describes how to install SQL Server 2012.

• Installation Options and Requirements
• Installing SQL Server
• Deploying SQL Server in a Private Cloud
• Lab: Installing SQL Server
• Lab: Using a Data-Tier Application in a Private Cloud Scenario

This module describes new and enhanced features that make it easier to manage SQL Server databases.

• Enhancements to SQL Server Management Studio
• New and Enhanced Dynamic Management Views
• Using PowerShell to Manage SQL Server
• Lab: Managing SQL Server

This module describes new Transact-SQL and data storage capabilities that you can use to develop databases.

• Transact-SQL Enhancements
• New and Enhanced Transact-SQL Functions
• Enhancements to Spatial Data Support
• Storing and Querying Documents
• Lab: Developing SQL Server Databases

This module provides an introduction to new and enhanced performance tuning features in SQL Server 2012.

• Performance Optimization Tools
• Enhancements to Indexing
• Lab: Optimizing SQL Server Performance

This module provides an introduction to new and enhanced features for data recovery and availability.

• AlwaysOn High Availability
• Enhancemenst to Data Recovery
• Lab: Using AlwaysOn Availability Groups

This module describes how to use security enhancements in SQL Server 2012.

• Security Management Enhancements
• Contained Databases
• Lab: Implementing Security

This module provides an introduction to SQL Azure.

• Introduction to SQL Azure
• Working with SQL Azure
• Lab: Using SQL Azure

This module introduces enhancements to BI support in SQL Server 2012.

• SQL Server 2012 for Data Warehousing
• SQL Server 2012 for Business Intelligence
• Lab: Exploring BI Features