MCSA SQL Server 2012/2014

Modality: Instructor Led-Training

Location: Puerto Rico Science, Technology & Research Trust Center

Time Schedule: 8:00 a.m. to 5:00 p.m.


Course Description

The MCSA: SQL Server 2012 boot camp is 9 days of an intense deep dive into every aspect of SQL Server 2012 including query, administration and data warehousing. This program incorporates Microsoft Courses: 20461: Querying Microsoft SQL Server; 20462: Administering Microsoft SQL Server Databases; and 20463: Implementing a Data Warehouse with Microsoft SQL Server. While attending this training program – you take three exams to test and certify for the Microsoft Certified Solutions Associate: SQL Server 2012 official certification. If your goal is to learn how to use SQL Server 2012 and pass the certification exam, this is the training for you. This course is a hybrid of actual hands on learning combined with focused materials mapped to exam objectives.

Audience Profile 

This boot camp is intended for SQL Server database administrators, implementers, system engineers, and developers with two or more years of experience, who are seeking to prove their skills and knowledge in writing queries, installation and maintenance of database systems, as well as, creating business intelligence (BI) solutions including data cleansing, Extract Transform Load (ETL), and Data Warehouse implementation.  It is also for those database professionals who perform installation, maintenance, and configuration tasks. Other responsibilities include setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access. ETL and data warehouse developers who create Business Intelligence (BI) solutions, and whose responsibilities include data cleansing, and Extract Transform Load and data warehouse implementation, are also good candidates.

Exams Included

70-461: Querying Microsoft SQL Server 2012

70-462: Administering a Microsoft SQL Server 2012 Database

70-463: Implementing Data Warehouses with Microsoft SQL Server 2012


Course Outline

Module 1: Create Database Objects

Module 2: Work with Data

Module 3: Modify Data

Module 4: Troubleshoot & Optimize

Module 5: Install and Configure

Module 6: Maintain Instances and Databases

Module 7: Optimize and Troubleshoot

Module 8: Manage Data

Module 9: Implement Security

Module 10: Implement High Availability

Module 11: Design and Implement a Data Warehouse

Module 12: Extract and Transform Data

Module 13: Load Data

Module 14: Configure and Deploy SSIS Solutions

Module 15: Build Data Quality Solutions