Microsoft has released 5 new SQL Server 2012 Microsoft Virtual Academy courses.

Breakthrough Insights using Microsoft SQL Server 2012 - Analysis Services

The 7 modules of this course will introduce you to concepts and practices such as:

• Developing and Managing a Business Intelligent Semantic Model
• Enriching your BI Semantic Models with Data Analysis Expressions (DAX)
• Leveraging Master Data Services (MDS) in your Data Warehouse

Breakthrough Insights using Microsoft SQL Server 2012 – Scalable Data Warehouse

The 7 modules of this course will teach you:

• What's new in Microsoft StreamInsight
• Symmetric Multiprocessing to Parallel Data Warehouse
• Using columnstore technology to revolutionize your query performance
• SQL Server Integration Services
• SQL Server Fast Track for data warehouse for dramatic speed improvements
• Going beyond relational data management into the realm of unstructured and spatial data management

Breakthrough Insights using Microsoft SQL Server 2012 - Reporting Services

The 9 modules of this course will teach you:

• What's new Microsoft SQL Server 2012 Reporting Services
• Introduce you to Self-Service Alerting
• What’s new in Microsoft SQL Server 2012 Analysis Services and PowerPivot
• How to use Power View for insightful visual reports
• How to build great Business Intelligence Semantic Models for Power View
• Deploying and managing PowerPivot in Microsoft SQL Server 2012 for SharePoint
• A Deeper understanding of PowerPivot in Microsoft SQL Server 2012
• How to install and configure Reporting Services in SharePoint Integration mode
• An overview of Reporting Services in Microsoft SQL Azure

Cloud on your terms with Microsoft SQL server 2012: Scale on Demand

The 3 modules of this course will teach you:

• Virtualization in the Private Cloud (two parts)
• Beyond the Hype - Hybrid Solutions for On-Premise and In-Cloud Database Applications

Mission Critical Confidence using Microsoft SQL Server 2012

The 9 modules of this course will teach you:

• Microsoft SQL Server 2012 Security enhancements
• Microsoft SQL Server 2012 High Availability and Disaster Recovery Design Patterns, Architectures and Best Practices using AlwaysOn
• T-SQL Cookbook - Microsoft SQL Server 2012 Enhancements
• Mission Critical application testing with Distributed Replay
• AlwaysOn Failover Cluster Instances and other High Availability enhancements
• Improve Application Availability Using AlwaysOn - A Deep Dive Into Availability Groups
• AlwaysOn - Active Secondary Part 1 - Readable Secondary
• AlwaysOn - Active Secondary Part 2 - Enabling Backup On Secondary Replicas
• Using The Power Of Extended Events For Tracing And Troubleshooting