Toutes nos formations sont désormais disponibles en "Live Virtual classes". Contactez-nous pour plus d’informations : formation@oxiane.luToutes nos formations sont désormais disponibles en "Live Virtual classes". Contactez-nous pour plus d’informations : formation@oxiane.lu

Updating your DBA skills to Microsoft SQL Server 2012

Accueil » Formations » Data » Updating your DBA skills to Microsoft SQL Server 2012

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.

1500 € HT 3 jours SQL-S2012UG

Prochaines sessions

    Formulaire d'inscription

    Télécharger le programme

    Contactez nous pour un devis

    Programme

    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.
    Google+
    LinkedIn
    Viadeo