MCSA SQL 2014 Certification - 9 Day Training Class

The MCSA: SQL 2014 certification course is for professionals who implement and administer Microsoft SQL Server 2014 databases. The certification is appropriate for individuals who design databases, develop logical data models, manage databases, maintain databases, configure and manage security, monitor and optimize databases, and install and configure Microsoft SQL Server 2014.


By earning the MCSA: SQL 2014 certification, individuals are demonstrating that they have the necessary skills to lead organizations in the successful design, implementation, and administration of Microsoft SQL Server 2014 databases.


The MCSA: SQL 2014 certification requires candidates to pass three core exams that provide a valid and reliable measure of technical proficiency and expertise in the implementation and administration of Microsoft SQL Server 2014 databases.


After completing this training event, students will be able to:


  • 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


  • Plan and install SQL Server.

  • Describe system databases

  • Explain the concept of the transaction log and the SQL Server recovery models

  • Back up SQL Server databases.

  • Restore SQL Server databases.

  • Import and export data by using wizards, the bulk copy utility, and data-tier applications.

  • Work with SQL Server security models, logins, users, and contained databases.

  • Work with server roles and database roles.

  • Use permissions to secure resources.

  • Use SQL Server audit and Transparent Data Encryption.

  • Work with SQL Server Agent to configure and execute jobs.

  • Implement SQL Server Agent security, proxy accounts, and credentials.

  • Configure database mail, alerts, and notifications.

  • Create database maintenance plans.

  • Use SQL Server Profiler, SQL Trace, and Distributed Relay.

  • Use Distributed Management Views and configure data collection.


  • 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.


Exams Included & Administered During Course:


70-461: Querying Microsoft SQL Server 2014


70-462: Administering a Microsoft SQL Server 2014 Database


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

What's Included


  • Airfare

  • 9 Nights of Hotel Lodging

  • Breakfast and Lunch

  • 3 Microsoft Test Vouchers

  • 3 Retake Vouchers (if needed)

  • Microsoft Courseware

  • Virtual Enviroment for labs

  • Ground Transportation

  • Onsite VUE Testing Center

  • Instructor Led Classroom Training

All-Inclusive Cost:
Length: 9 days


03.12.2016 - 03.20.2016


04.09.2016 - 04.17.2016


05.07.2016 - 05.15.2016


06.11.2016 - 06.19.2016


07.16.2016 - 07.24.2016


08.06.2016 - 08.14.2016


  • LinkedIn Social Icon
  • Facebook Social Icon

 Cage Code 74BJ3 * DUNS # 079365833

© Key Training Solution, LLC  

All Rights Reserved