The Microsoft Certified Solutions Associate (MCSA): SQL Server 2012 course will teach you how to create database objects, like tables and design views. It will also teach you how to create and modify constraints, and create and alter DML triggers. You will learn to query data using select statements, implement sub-queries and data types, aggregate queries, and manage XML data. Modify data by creating and altering stored procedures, using statements like insert, update, and delete, combining datasets, and working with functions. Finally, troubleshoot and optimize SQL Server 2012 by optimizing queries, managing transactions, evaluating row-based operations, and implementing error handling.
Learn the steps involved in installing, managing, monitoring, and maintaining SQL Servers. You will also explore maintenance and management of the SQL server network and application. Learn how to design and implement a data warehouse, extract and transform data, load data, configure and deploy SSIS solutions, and build data-quality solutions. This course offers enrollment with or without a voucher. The voucher is prepaid access to sit for the certifying exam upon eligibility.