Summer-Ready Savings: Find the Training Course You Need at a Price You'll Love

closeClose

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

  • Tuition USD $3,095 Save $310
  • Reviews star_rate star_rate star_rate star_rate star_half 338 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 enroll?

A comprehensive listing of ExitCertified courses can be found here. You can register directly for the required course/location when you select "register". If you have any questions or prefer to speak with an ExitCertified education consultant directly, please submit your query here. A representative will contact you shortly.

How do I pay for a class?

You can pay at the time of registration using credit card (Mastercard/Visa/American Express) cheque or PO.

What if I have training credits?

ExitCertified honors all savings programs from the partners we work with. ExitCertified also offers training credits across multiple partners through our FLEX Account.

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Lunchtime?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

Facility was well laid out. Well stocked break room & bathroom within close walk. Also, the woman working the front desk/professional support was very helpful and professional, and responsive to our requests.

I would certainly go through ExitCertified again for future trainings.

Very clean, great cafeteria and well sorted, very kind staff. The bathrooms have to be expanded as they might get crowded sometimes

I just finished the 3 days training on AWS Solution Architect course instructed by Seid. He is very knowledgeable. He engaged the students and he is very friendly. The labs were well planned. I strongly suggest people to take the course.

The course material was laid out logically. There are a lot of aws services and concepts to cover in the three days but overall was a good learning experience.

I am overall very impressed with ExitCertified/Tech Data regarding the Spring Core class outline and iMVP delivery format.

0 options found

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