Updating your Database Skills to Microsoft SQL Server 2012 Training Course

Course 40008
3 Days

Instructor-Led Live: $1,795
Instructor-Led Remote: $1,295 - Learn more
Course Overview
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.
Audience
Course 40008: Updating your Database Skills to Microsoft SQL Server 2012 is intended for database professionals with experience of using SQL Server 2008 R2.
Course Outline
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.

    Registration

Have a Microsoft Voucher?
Alexandria  |  Atlanta  |  Austin  |  Baltimore  |  Birmingham  |  Buffalo  |  Boise  |  Boston  |  Boulder  |  Charleston  |  Charlotte  |  Chicago  |  Cincinnati  |  Cleveland  |  Columbus  |  Dallas  |  Denver  |  Des Moines  |  Detroit  |  Hartford  |  Houston  |  Indianapolis  |  Jacksonville  |  Kalamazoo  |  Las Vegas  |  Los Angeles  |  Melville  |  Nashville  |  New Orleans  |  New York  |  Orlando  |  Overland Park   |  Palm Beach Gardens  |  Philadelphia  |  Phoenix  |  Pittsburgh  |  Princeton  |  Providence  |  Raleigh  |  Reno  |  Salt Lake City  |  San Antonio  |  San Diego  |  San Francisco  |  Savannah  |  Scottsdale  |  Seattle  |  St. Louis  | Tallahassee  |  Tampa  |  Toronto  |  Washington DC  |  Wichita