Microsoft SATVs Are Expiring —Take Full Advantage and Act Now!

closeClose

Updating your Database and Business Intelligence Skills to SQL Server 2012 (M40008, M40009)

  • Tuition USD $2,786 List Price $3,095 GSA  $2,338.79
  • Reviews star_rate star_rate star_rate star_rate star_half 2368 Ratings
  • Course Code 6425
  • Duration 5 days
  • Available Formats Classroom

Upgrade your database and business intelligence (BI) skills to Microsoft SQL Server 2012. In this course, existing SQL Server database professionals will gain the knowledge and skills to use new and enhanced capabilities in SQL Server 2012, including Database and Business Intelligence features.

This course incorporates material from the Official Microsoft Learning Products (OMLPs):

  • 40008: Updating your Database Skills to Microsoft SQL Server 2012
  • 40009: Updating your Business Intelligence Skills to Microsoft SQL Server 2012

Skills Gained

  • 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
  • New BI capabilities in SQL Server 2012
  • Use new and enhanced features in SQL Server Integration Services
  • Manage data quality by using SQL Server Data Quality Services
  • Use new and enhanced features of SQL Server Reporting Services
  • Create tabular data models with PowerPivot and DAX
  • Implement a tabular data model in SQL Server Analysis Services
  • Use Power View to create interactive data visualizations
  • Integrate Microsoft cloud technologies into a BI solution using SQL Azure

Who Can Benefit

Database and BI professionals with experience using SQL Server 2008 R2

Prerequisites

  • Experience creating database solutions in SQL Server, including basic Transact-SQL programming
  • Familiarity with data warehousing and BI solutions, including extract, transform, and load (ETL), data modeling, and reporting

How do I get a Microsoft exam voucher?

Pearson Vue Exam vouchers can be requested and ordered with your course purchase or can be ordered separately by clicking here.

  • Vouchers are non-refundable and non-returnable. Vouchers expire 12 months from the date they are issued unless otherwise specified in the terms and conditions.
  • Voucher expiration dates cannot be extended. The exam must be taken by the expiration date printed on the voucher.

Do Microsoft courses come with post lab access?

Most Microsoft official courses will include post-lab access ranging from 30 to 180 calendar days after instructor led course delivery. A lab training key in class will be provided that can be leveraged to continue connecting to a remote lab environment for the individual course attendee.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour-long after 3-3.5 hours of the class day.

What languages are used to deliver training?

Microsoft courses are conducted in English unless otherwise specified.

The instructor was great and the labs and exercises where very clear and rich

The training and trainer were really brilliant. Very helpful and covered all the topics with real life examples.

I attended a remote learning class from my home and was completely satisfied with the class, instructor, response time, content and lab exercises.

Great content and great delivery. Will definitely like to take more classes with Ruben if possible

The content has been very helpful for me to get upto speed with cloud computing

0 options available

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links above. We can also contact you when the course is scheduled in your area.

Contact Us 1-800-803-3948
Contact Us
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward