40008AC: Updating your Database Skills to Microsoft SQL Server 2012

Module 1: Introducing SQL Server 2012
This module provides an overview of SQL Server 2012.
Lessons
• Overview of SQL Server 2012
• SQL Server 2012 Editions and Components
After completing this module, students will be able to:
• Describe SQL Server 2012.
• List SQL Server 2012 Editions and Components.
Module 2: Installing SQL Server 2012
This module describes how to install SQL Server 2012.
Lessons
• Installation Options and Requirements
• Installing SQL Server
• Deploying SQL Server in a Private Cloud
Lab : Installing SQL Server
• Installing a SQL Server 2012 Named Instance
• Performing Post-Installation Setup and Checks
Lab : Using a Data-Tier Application in a Private Cloud Scenario
• Creating a Data-Tier Application
• Deploying a Data-Tier Application
After completing this module, students will be able to:
• List the installation options and requirements for SQL Server 2012.
• Install SQL Server 2012.
• Describe considerations for provisioning database servers in a private cloud.
Module 3: Managing SQL Server 2012
This module describes new and enhanced features that make it easier to manage SQL Server databases.
Lessons
• Enhancements to SQL Server Management Studio
• New and Enhanced Dynamic Management Views
• Using PowerShell to Manage SQL Server
Lab : Managing SQL Server
• Using SQL Server Management Studio
• Using SQL Server Management Studio
After completing this module, students will be able to:
• Use enhancements to SQL Server Management Studio
• Use new and enhanced Dynamic Management Views
• Use PowerShell to Manage SQL Server.
Module 4: Developing SQL Server 2012 Databases
This module describes new Transact-SQL and data storage capabilities that you can use to develop databases.
Lessons
• Transact-SQL Enhancements
• New and Enhanced Transact-SQL Functions
• Enhancements to Spatial Data Support
• Storing and Querying Documents
Lab : Developing SQL Server Databases
• Using Sequence Objects
• Using the THROW Statement
• Implementing Paging
• Querying Documents
After completing this module, students will be able to:
• Describe enhancements to Transact-SQL.
• Describe new and enhanced Transact-SQL functions.
• Describe Enhancements to Spatial Data Support.
• Explain how to store and query documents with SQL Server 2012.
Module 5: Performance and Tuning Enhancements
This module provides an introduction to new and enhanced performance tuning features in SQL Server 2012.
Lessons
• Performance Optimization Tools
• Enhancements to Indexing
Lab : Optimizing SQL Server Performance
• Creating a Columnstore Index
• Using a Columnstore Index
• Updating a Table with a Columnstore Index
After completing this module, students will be able to:
• Describe enhancements to performance optimization tools.
• Use indexing enhancements to increase query performance.
Module 6: High Availability and Data Recovery Enhancements
This module provides an introduction to new and enhanced features for data recovery and availability.
Lessons
• AlwaysOn High Availability
• Enhancemenst to Data Recovery
Lab : Using AlwaysOn Availability Groups
• Creating an AlwaysOn Availability Group
• Using an AlwaysOn Availability Group
• Observing Availability Group Failover Behavior
After completing this module, students will be able to:
• Use AlwaysOn technologies to support high availability.
• Use enhancements to database restore capabilities.
Module 7: Implementing Security in Microsoft SQL Server 2012
This module describes how to use security enhancements in SQL Server 2012.
Lessons
• Security Management Enhancements
• Contained Databases
Lab : Implementing Security
• Implementing user-Defined Server Roles
• Implementing Contained Databases
After completing this module, students will be able to:
• Describe security management enhancements.
• Implement contained databases.
Module 8: Extending Data Solutions to the Cloud
This module provides an introduction to SQL Azure.
Lessons
• Introduction to SQL Azure
• Working with SQL Azure
Lab : Using SQL Azure
• Creating a Database in SQL Azure
• Using SQL Server Management Studio with SQL Azure
After completing this module, students will be able to:
• Describe key features and benefits of SQL Azure.
• Create and manage SQL Azure databases.
Module 9: Overview of BI Enhancements in SQL Server 2012
This module introduces enhancements to BI support in SQL Server 2012.
Lessons
• SQL Server 2012 for Data Warehousing
• SQL Server 2012 for Business Intelligence
Lab : Exploring BI Features
• Using PowerPivot
• Using Power View
After completing this module, students will be able to:
• Describe enhancements in SQL Server 2012 for data warehousing.
• Describe enhancements in SQL Server 2012 for BI.