Chat with us, powered by LiveChat

For All Enquiries

1300 731 939

Updating your Database Skills to Microsoft SQL Server 2012

  • Course Code:

    40008
  • Course Duration:

    3 Days
  • Course Price:

    $2505
  • Availability:

    Call/Email to register interest
  • Overview & ObjectivesOpen or Close

    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.

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

     

  • Skills GainedOpen or Close
    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.
  • Course ModulesOpen or Close

    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.

     

  • PrerequisitesOpen or Close
    Before attending this course, students must have:
    • Experience of creating and managing database solutions in SQL Server, including basic Transact-SQL programming.
Hav a question

Have a Question?

Give us a Call

Contact Us
PGlmcmFtZSBzcmM9Imh0dHBzOi8vd3d3Lmdvb2dsZS5jb20vbWFwcy9lbWJlZD9wYj0hMW0xNCExbTghMW0zITFkMTMyNTkuMTkzNzAyNTI2ODQzITJkMTUxLjAwMzI1NjYhM2QtMzMuODE3NTE0NiEzbTIhMWkxMDI0ITJpNzY4ITRmMTMuMSEzbTMhMW0yITFzMHgwJTNBMHhlOGI4NWUwZmIzMGQ5MzZmITJzTUlTK0dsb2JhbCtJbnN0aXR1dGUrb2YrVGVjaG5vbG9neSE1ZTAhM20yITFzZW4hMnNhdSE0djE0NDc2Mjg0NjEzMzgiIHdpZHRoPSI0MDAiIGhlaWdodD0iMjUwIiBmcmFtZWJvcmRlcj0iMCIgc3R5bGU9ImJvcmRlcjowIiBhbGxvd2Z1bGxzY3JlZW4+PC9pZnJhbWU+
CONTACT US
Excel 2013 – Level 2
November 26, 2015 25% off
Thank You. We will contact you as soon as possible.
Featured Course: Excel Level 2
Learn to use excel with this intermediate level one day course from MIS Global Technologies and gain the following skills:
  • VLOOKUP
  • Reference functions
  • Use Database Tables
  • Data Validation tools
  • Use Hyperlinks
  • Protect workbooks
CONTACT US
Thank You. We will contact you as soon as possible.
Excel Level 2
Featured Course: Office 365
This is a 5-day Instructor Led Training (ILT) course that targets the needs of IT professionals who take part in evaluating, planning, deploying, and operating Office 365 services. You will learn how to:
  • Implement and Manage Identities by Using DirSync
  • Manage Clients and End-User Devices
  • Provision SharePoint Online Site Collections
  • Configure Exchange Online and Lync Online for End Users
CONTACT US
Thank You. We will contact you as soon as possible.
PGlmcmFtZSBzcmM9Imh0dHBzOi8vd3d3Lmdvb2dsZS5jb20vbWFwcy9lbWJlZD9wYj0hMW0xNCExbTghMW0zITFkMTMyNTkuMTkzNzAyNTI2ODQzITJkMTUxLjAwMzI1NjYhM2QtMzMuODE3NTE0NiEzbTIhMWkxMDI0ITJpNzY4ITRmMTMuMSEzbTMhMW0yITFzMHgwJTNBMHhlOGI4NWUwZmIzMGQ5MzZmITJzTUlTK0dsb2JhbCtJbnN0aXR1dGUrb2YrVGVjaG5vbG9neSE1ZTAhM20yITFzZW4hMnNhdSE0djE0NTU1MTI2NDQyNTAiIHdpZHRoPSI0MDAiIGhlaWdodD0iMjUwIiBmcmFtZWJvcmRlcj0iMCIgc3R5bGU9ImJvcmRlcjowIiBhbGxvd2Z1bGxzY3JlZW4+PC9pZnJhbWU+
CONTACT US
MIS Global Technologies
Phone: 1300 731 939
Suite 513, Level 5 Westfield Office Tower
159-175 Church Street Parramatta NSW 2150
Thank You. We will contact you as soon as possible.
We're happy to answer any questions you may have or provide you with any help you need when choosing the course that's right for you. Please leave a message in the form below and one of our friendly staff will get back to you as soon as possible
Thankyou! Your enquiry has been sent successfully. One of our friendly staff will get back to you soon. For anything urgent you can always call us on 1300 731 939
Featured Course: Excel Level 1
Learn to use excel with our one day course for beginners at MIS Global Technologies and learn about the following:
  • How to enter and edit data
  • How to Insert rows and columns
  • The BEDMAS rule
  • How to format dates
  • How to modify the header or footer
Reserve Your Place Today
Thank You. We will contact you as soon as possible.
Excel Level 2
Please leave a message and let us know which course you are interested in taking with us. One of our friendly staff will contact you as soon as they are available and will help you with your studies.
Thank you for your interest