Updating your Database Skills to Microsoft SQL Server 2012 - Course 40008

3 Days

Description

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 Profile:

This course is intended for database professionals with experience of using SQL Server 2008 R2.

At Course Completion

After completing this course, students will be able to:

  • Describe key new and enhanced features in SQL Server 2012.
  • Install SQL Server 2012.
  • Use enhanced tools and PowerShell support to manage SQL Server 2012.
  • Use enhanced Transact-SQL and storage capabilities to develop SQL Server 2012 databases.
  • Use new and enhanced performance capabilities to optimize a SQL Server 2012 database.
  • Use new availability and data recovery technologies to provide high availability.
  • Use new and enhanced security capabilities in SQL Server 2012.
  • Use SQL Azure.
  • Describe new Business Intelligence (BI) capabilities in SQL Server 2012.

No Upcoming Public Classes

There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a Updating your Database Skills to Microsoft SQL Server 2012 - Course 40008 class.

Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Course Overview

  • 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
    • Lab : Using a Data-Tier Application in a Private Cloud Scenario
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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.

No Upcoming Public Classes

There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a Updating your Database Skills to Microsoft SQL Server 2012 - Course 40008 class.

Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Prerequisites

Before attending this course, students must have:

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

No Upcoming Public Classes

There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a Updating your Database Skills to Microsoft SQL Server 2012 - Course 40008 class.

Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date