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.


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


Duração: 3 dias


Conteúdo Programático
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


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

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

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

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

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

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

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


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

Download: microsoft.jpg


Solicite mais informação

Inscreva-se neste curso