Updating your Database Skills to Microsoft® SQL Server® 2012 Training Course


Microsoft Official Curriculum Course Number: 40008
Printer Friendly Printer Friendly

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.
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.

Current User's Login:


Fill out the information as a first time user:
Name:
(First/Last)
 
Email:
(UserName)
Confirm Email:
Company:
(if applicable)
Title:
Address 1:
Address 2:
City:
State/Province:
Postal Code:
Country:
Phone:
Discount Code:
Comments:
To Redeem SATV vouchers please have your voucher redemption number ready


Live Instructor-led Updating your Database Skills to Microsoft® SQL Server® 2012 Training Dates

SATV Eligible
Filter By...
Providers:       Location:      
Date Range:  
 to 
Provider Location Date Type Duration Price 0 course(s)
  << Prev  Next >> 

Online Self-Paced Updating your Database Skills to Microsoft® SQL Server® 2012 Training Options

SATV Eligible
No online results

Request Training Assistance

Please complete the form below and a TrainUp.com support specialist will send you information on the course you've selected. Our staff typically responds to your requests within 30 minutes or less. You can also reach us toll-free at 1-866-540-9677

Request Training Assistance

Please complete the form below and a TrainUp.com support specialist will send you information on the course you've selected. Our staff typically responds to your requests within 30 minutes or less. You can also reach us toll-free at 1-866-540-9677

//