In this accelerated learning environment, you will build your skills and prepare for the MCSA: SQL Server 2012/2014 certification exams. This extended-hours boot camp led by senior Global Knowledge instructors includes targeted lectures using Microsoft Learning recommended content as well as 12 months of access to more than 40 hands-on remote labs. This boot camp includes all the exam vouchers required for certification, along with one free retake voucher if needed. It also includes access to our Microsoft Boot Camp Exclusives, providing indispensable certification exam prep. This course incorporates content from Microsoft Official Courses (MOC):

Querying Microsoft SQL Server 2014 (M20461)

Administering Microsoft SQL Server 2014 Databases (M20462)

Implementing a Data Warehouse with Microsoft SQL Server 2014 (M20463)

Note: To reflect the inclusion of SQL Server 2014 content in exams 461, 462, and 463, Microsoft Learning has rebranded the MCSA certification to MCSA: SQL Server 2012/2014. As changes to each individual exam are modest in size and SQL Server 2012 skills remain relevant, all current MCSA: SQL Server 2012 certification holders will have their transcripts updated accordingly to reflect the new credential name.

IT professionals with at least two years of hands-on experience implementing and administering database systems Database administrators, systems engineers, systems analysts, and technical consultants who want to prepare for their MCSA: SQL Server 2012/2014 credential in an accelerated format

The technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012

The knowledge and skills to maintain Microsoft SQL Server 2012 databases

Create a data warehouse with SQL Server 2012

Implement ETL with SQL Server Integration Services

Validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services

Key topics and concepts addressed on the MCSA: SQL Server 2012 exams