Home / Courses / Microsoft Technology / 40008AC: Updating your Database Skills to Microsoft SQL Server 2012

SQL

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.

 

Course Registration

 

3 day
$1,700.00

 

Course Outline

 

Request