"People do not invest in education because they are rich. They become rich because they invest in education."


- Gabriel Verhoef

40008 - Updating your Database Skills to Microsoft SQL Server 2012

This course provides existing SQL Server database professionals with the knowledge and skills to use new and enhanced capabilities in SQL Server 2012.

40008 - Updating your Database Skills to Microsoft SQL Server 2012 course offered at MasterGrade.

Who should attend?

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

40008 - Updating your Database Skills to Microsoft SQL Server 2012

Module 1: Introducing SQL Server 2012

  • Overview of SQL Server 2012
  • SQL Server 2012 Editions and Components

Module 2: Installing SQL Server 2012

  • Installation Options and Requirements
  • Installing SQL Server
  • Deploying SQL Server in a Private Cloud

Module 3: Managing SQL Server 2012

  • 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

  • Transact-SQL Enhancements
  • New and Enhanced Transact-SQL Functions
  • Enhancements to Spatial Data Support
  • Storing and Querying Documents

Module 5: Performance and Tuning Enhancements

  • Performance Optimization Tools
  • Enhancements to Indexing

Module 6: High Availability and Data Recovery Enhancements

  • AlwaysOn High Availability
  • Enhancemenst to Data Recovery

Module 7: Implementing Security in Microsoft SQL Server 2012

  • Security Management Enhancements
  • Contained Databases

Module 8: Extending Data Solutions to the Cloud

  • Introduction to SQL Azure
  • Working with SQL Azure

Module 9: Overview of BI Enhancements in SQL Server 2012

  • SQL Server 2012 for Data Warehousing
  • SQL Server 2012 for Business Intelligence

Duration:

Learning Materials:

Prerequisites:

What course next:

3 Days

All included

SQL Server 2008 »

40009 »
 

Get a Quote today »

 

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

   • Introducing SQL Server 2012
   • Installing SQL Server 2012
   • Managing SQL Server 2012
   • Developing SQL Server 2012 Databases
   • Performance and Tuning Enhancements
   • High Availability and Data Recovery Enhancements
   • Implementing Security in Microsoft SQL Server 2012
   • Extending Data Solutions to the Cloud
   • Overview of BI Enhancements in SQL Server 2012

 

Quick Search
Register Here

Fill in your details below and one of our career specialists will assist you with your study needs

Sorry, your message could not be sent. Please check your details. Please complete all fields.

Name

Email

Phone

Location

Message


Thank you
For your request, one of our career specialists will assist you with your study needs.

It’s very fun and interesting. Love It!!

Shaun2.jpg
- Shaun Brown

I will recommend MasterGrade IT to anyone that is serious about getting certification.

zaheer1.jpg
- Zaheer Isaacs

Very informative; Excel is a great course to start off with. I like the neat classrooms and the personal attention!

rene1.jpg
- René Leandro Borges

I enjoyed doing the course in my own time!

sadia.jpg
- Sadia Abrahams

Already Engaged.

Thousands of companies around the world use and love our training every day.


Meetup
Meetup
Meetup
Meetup
Meetup
Meetup
Meetup
Meetup

Procomp Computer Services CC trading as MasterGrade IT® Computer Learning Centre. Registration No. 2002/029621/23.