SQL 2014 & Power BI Hands on Technical Training


With the commercial availability of SQL Server 2014 comes a new set of technologies that can transform your data platform and business intelligence projects. Technologies such as in-memory OLTP, updateable column store, resource governor, Power BI on O365 and Azure are a leap forward in enabling data insights and mission critical scenarios.


To help you build your expertise on these technologies we are delivering a Level 300 three day course for data platform and business intelligence technology partners. You will leave this training with news skills to implement the latest features of the expanding product set. The 3 days cover the following technologies:

  • Microsoft SQL Server 2014
  • Power BI
  • Microsoft Azure

What Will You Learn?

During this 3-day, instructor-led course we will help students understand how to put the latest technologies to work with hands-on labs as well as instructor lead materials including:

  • SQL 2014 in-memory OLTP (overview, management & development)
  • Always-On enhancements
  • Resource governor and other mission critical enhancements
  • Azure scenarios such as backup to cloud, SQL in IaaS, HA on for SQL 2014 on Azure
  • Updateable column store
  • Power BI including Power Query and Pivot as well as the Data Management Gateway and Administration


This course is targeted at technologists with data platform and business intelligence expertise as well as Pre-sales Engineers who are interested in updating and expanding their skills. Familiarity with SQL Server is required as this is not an introductory course. Some familiarity with Windows Azure will aid the attendee.


  • Please bring your laptop to the training.
  • You will access the internet via LAN connection.
  • Please bring adapters if applicable (e.g. Ethernet, Mini Display to VGA, power Adapter)

COST: $499 per person

COURSE LEVEL: 300 (Technical)


  • Location: Saxons Melbourne
  • Date: 5 – 7 November
  • Time: 9:00 – 17:00
  • Location: Saxons Perth
  • Date: 24 – 26 November
  • Time: 9:00 – 17:00
  • Location: Microsoft North Ryde
  • Date: 8 – 10 December
  • Time: 9:00 – 17:00

For the best training experience, please come with your Windows Azure account. We will demonstrate the latest features for Virtual Machines, HDInsight (Hadoop on Azure) and PowerShell for Azure.

Also, feel free to explore Power BI prior to attendance to get more from the deep technical view we'll be providing by going to http://www.powerbi.com

Questions: If you have any questions, please send an email to msaupr@microsoft.com