Updating your Database Skills to Microsoft SQL Server 2012

Course details

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

Lesson 1: Introducing SQL Server 2012

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

Lesson 2: Installing SQL Server 2012

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

Lesson 3: Managing SQL Server 2012

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

Lesson 4: Developing SQL Server 2012 Databases

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

Lesson 5: Performance and Tuning Enhancements

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

Lesson 6: High Availability and Data Recovery Enhancements

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

Lesson 7: Implementing Security in Microsoft SQL Server 2012

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

Lesson 8: Extending Data Solutions to the Cloud

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

Lesson 9: Overview of BI Enhancements in SQL Server 2012

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

Prerequisites

Before attending this course, students must have:

• Experience of creating and managing database solutions in SQL Server, including basic Transact-SQL programming.