MCSA SQL 2012 and 2014 Certification Camp


The MCSA SQL Server 2012 / 2014 certification boot camp is a 9 day comprehensive deep dive into the SQL Server covering topics such as writing queries, administration and data warehousing. This instructor led face to face training camp will teach you the skills needed to support a SQL environment.

The MCSA SQL boot camp incorporates Microsoft Official Courses –

20461 Querying Microsoft SQL Server
20462 Administering Microsoft SQL Server Databases
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 (MCSA): SQL Server 2012 / 2014 official certification. If your goal is to learn how to use SQL Server and pass the certification exams (70-461, 70-462 & 70-463) – you’ve found the right place. This course is a hybrid of actual hands on learning combined with focused materials mapped to exam objectives.

  • Class Dates
  • 09/09/2017 – 17/09/2017Punta Gorda, FL
    07/10/2017 – 15/10/2017Punta Gorda, FL
    28/10/2017 – 05/11/2017Punta Gorda, FL
    02/12/2017 – 10/12/2017Punta Gorda, FL

  • What Is Included
  • transportation,plane,half,user,airplane,transport,account,profile,people,human Airfare to/from Punta Gorda, FL
    lodging 12 Nights of Lodging
    transportation,bus,automobile,vehicle,car,transport Shuttle Transportation from the Airport/Hotel/Facility
    restaurant Breakfast Served at the Hotel and Lunch is Provided by the Facility
    address,book,reading,read Authorized Course Materials, Study Guides, Classroom Handouts. Test Preps
    exam 3 Microsoft Exam Vouchers
    exam 3 Retake Vouchers (if needed)
    Onsite Pearson Vue Testing Center
    exam 180 Days Post Class Virtual Lab Access
    exam 90 Days eLearning Access

Class Outline

Topics covered in this boot camp:

Describe the basic architecture and concepts of Microsoft SQL Server 2014
Understand the similarities and differences between Transact-SQL and other computer languages
Write SELECT queries
Query multiple tables
Sort and filter data
Describe the use of data types in SQL Server
Modify data using Transact-SQL
Use built-in functions
Group and aggregate data
Use subqueries
Use table expressions
Use set operators
Use window ranking, offset and aggregate functions
Implement pivoting and grouping sets
Execute stored procedures
Program with T-SQL
Implement error handling
Implement transactions

Describe core database administration tasks and tools
Install and configure SQL Server 2014
Configure SQL Server databases and storage
Plan and implement a backup strategy
Restore databases from backups
Import and export data
Monitor SQL Server
Trace SQL Server activity
Manage SQL Server security
Audit data access and encrypt data
Perform ongoing database maintenance
Automate SQL Server maintenance with SQL Server Agent Jobs
Configure Database Mail, alerts and notifications

Describe data warehouse concepts and architecture considerations
Select an appropriate hardware platform for a data warehouse
Design and implement a data warehouse
Implement Data Flow in an SSIS Package
Implement Control Flow in an SSIS Package
Debug and Troubleshoot SSIS packages
Implement an ETL solution that supports incremental data extraction
Implement an ETL solution that supports incremental data loading
Implement data cleansing by using Microsoft Data Quality Services
Implement Master Data Services to enforce data integrity
Extend SSIS with custom scripts and components
Deploy and Configure SSIS packages
Describe how BI solutions can consume data from the data warehouse


There are no reviews yet.

Be the first to review “MCSA SQL 2012 and 2014 Certification Camp”

Your email address will not be published. Required fields are marked *