Are you interested in, or working towards your MCSA: SQL Server 2012? If so, there are three free online courses (Jump Starts) from Microsoft Virtual Academy that can help prepare you for each exam required so you can become Microsoft certified.
Exam Prep 70-461: Querying Microsoft SQL Server 2012 Databases – Jump Start
This Jump Start is ideal if you’re already familiar with database fundamentals and working with SQL Server and you’re ready to take your skills to the next level.
If you just want to understand the process better or you want to be able to retrieve, insert, or update your database information, this is the course for you. You’ll learn about data manipulation statements and how to alter tables – and you’ll see it all put into action in the demos. This course will help you prepare for Exam 70-461.
Exam Prep 70-462: Administering SQL Server 2012 – Jump Start
This Jump Start will help you understand the process of administering SQL Server 2012 databases. It focuses on security, data management, and disaster recovery/high availability and their implications for the configuration of the enterprise.
Watch the live demos to learn about storage design and capacity configuration, security configuration, optimization of the instance, and automation. This course helps prepare you for the MCSA 70-462 certification exam.
This Jump Start is the prerequisite for the Implementing a Data Warehouse with SQL Server Jump Start course.
Exam Prep 70-463: Implementing a Data Warehouse with SQL Server
Are you a SQL Server professional looking to expand your understanding of SQL Server 2012 data warehousing concepts and implementation?
This Jump Start course focuses on the design of Dimensions to support BI in the organization, the implementation of extract, transform, and load (ETL) processes, and the implementation of enterprise-level master data and data quality.
Watch the demos to learn about building dimension tables in a data warehouse, implementing an ETL process with control flow and data flow definitions, configuring logging and event handling, deploying an ETL solution, and implementing master data and data quality solutions. This course helps prepare you for the MCSA 70-463 certification exam.
And if you’re a Microsoft Partner in Canada, there’s currently an offer that you might want to take advantage of, but hurry because time and quantities are limited.