SQL Server 2012 Launch - Show me the training!

New release of Microsoft SQL Server has training ready to go...

On the eve of the launch of Microsoft SQL Server 2012 we are getting ready for the demand of training for the new features. I have been testing out the new VMs for the 5 new courses using Hyper-V. I must admit I am impressed. Normally, training is an after-thought with software, as vendors try to get the product out the door, but not this time. We have all the Microsoft official courses ready to go and on the GK schedule. Let's take a look...

Of course, the most popular class is likely to be "Administering Microsoft SQL Server 2012 Databases" which includes the usual suspects: Install, Configure, Backup, Restore and Troubleshoot but also new 2012 features like "AlwaysOn" for High Availability. This combines the best of both Database Mirroring and Log Shipping with a viable HA/DR solution that includes load balancing and automatic failover. Some people are already calling this "Mirroring++".

Then if you want to learn how to query using Transact-SQL there is always "Querying Microsoft SQL Server 2012". Previously this course was a 3 dayer including Joins, Subqueries and aggregation but it's been elongated to include new features such as OFFSET-FETCH, Sequencing and the TRY_CATCH function among others.

To enhance your database developer skills there is "Developing Microsoft SQL Server 2012 Databases" which includes Database Design, Stored Procedures, Triggers, Functions et al but also the new Column Store Index for high performance.

"Implementing a Data Warehouse with Microsoft SQL Server 2012" includes Data Warehouse design and architecture along with population technigues using the new version of SSIS. Integration Services is now greatly improved; for instance, the new SSIS Catalog gives us a central repository which was sadly lacking in previous releases. The new Data Quality Services (DQS) tool for data cleansing is included along with incremental updates using Change Data Capture (CDC) to make this a very interesting new class.

However, my favorite 2012 course has got to be: "Implementing Data Models and Reports with Microsoft SQL Server 2012". This course includes the classic Business Intelligence features included in Analysis Services such as multi-dimensional cubes and MDX scripting but also the new BISM Tabular Model, PowerPivot and DAX scripts. The new self-service reporting tool PowerView is also covered with its cool new animation features to make your web-based reports really come alive.

You can check out the new features of SQL Server 2012 on the Global Knowledge web site along with all the new courses at http://www.globalknowledge.com/training/whitepaperdetail.asp?pageid=502&wpid=944 .



Join the Network World communities on Facebook and LinkedIn to comment on topics that are top of mind.

Copyright © 2012 IDG Communications, Inc.

IT Salary Survey: The results are in