Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

MCSA: SQL Server 2012/2014 Boot Camp

Validate that you have the skills and knowledge necessary to administer Microsoft SQL Server in an enterprise environment.

GK# 6445

$6495 - $6795 CAD

Enroll Request Group Training

Course Overview

TOP

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.

Note: Microsoft Learning has rebranded the MCSA certification to MCSA: SQL Server 2012/2014. Please see https://www.microsoft.com/en-us/learning/mcsa-sql-certification.aspx for certification details.

You will prepare for these exams:

  • 70-461: Querying Microsoft SQL Server 2014
  • 70-462: Administering Microsoft SQL Server 2012/2014 Databases
  • 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012/2014

 

What You'll Learn

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

Labs

TOP
Viewing labs for:

Classroom Live Labs

Querying Microsoft SQL Server (M20461)

Lab 1: SQL Server 2014 Tools

Lab 2: Transact-SQL Querying

Lab 3: Write Basic SELECT statements

Lab 4: Query Multiple Tables

Lab 5: Sort and Filter Data

Lab 6: Work with SQL Server 2014 Data Types

Lab 7: Modify Data using DML

Lab 8: Built-In Functions

Lab 9: Group and Aggregate Data

Lab 10: Subqueries

Lab 11: Table Expressions

Lab 12: Set Operators

Lab 13: Use Window Ranking, Offset, and Aggregate Functions

Lab 14: Pivot and Group Sets

Lab 15: Execute Stored Procedures

Lab 16: Program with T-SQL

Lab 17: Implement Error Handling

Lab 18: Implement Transactions

Lab 19: Improve Query Performance

Lab 20: Query SQL Server Metadata

 

Administering Microsoft SQL Server Databases (M20462)

Lab 1: Use SQL Server Administrative Tools

Lab 2: Install SQL Server 2014

Lab 4: Manage Database Storage

Lab 4: Back Up SQL Server Databases

Lab 5: Restore SQL Server 2014 Databases

Lab 6: Import and Export Data

Lab 7: Monitor SQL Server 2014

Lab 8: Trace SQL Server Workload Activity

Lab 9: Manage SQL Server Security

Lab 10: Audit Data Access and Encrypting Data

Lab 11: Perform Ongoing Database Maintenance

Lab 12: Automate SQL Server Management

Lab 13: Monitor SQL Agent using Alerts and Notifications

 

Implementing a Data Warehouse with Microsoft SQL Server (M20463)

Lab 1: Exploring a Data Warehousing Solution

Lab 2: Planning Data Warehouse Infrastructure

Lab 3: Implementing a Data Warehouse

Lab 4: Implement Data Flow in an SSIS Package

Lab 5A: Implementing Control Flow in an SSIS Package

Lab 5B: Using Transactions and Checkpoints

Lab 6: Debugging and Troubleshooting an SSIS Package

Lab 7: Extracting Modified Data

Lab 8: Loading a Data Warehouse

Lab 9: Cleansing Data and Deduplicating Data

Lab 10: Implementing Master Data Services

Lab 11: Using Custom Scripts

Lab 12: Deploying and Configuring SSIS Packages

Lab 13: Using a Data Warehouse

Prerequisites

TOP
  • Working knowledge of relational databases
  • Two years of hands-on experience working in a SQL Server 2008 or SQL Server 2012 environment
  • Basic knowledge of the Microsoft Windows operating system and its core functionality

Who Should Attend

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

Note: This course, like all Global Knowledge courses, is provided only to individuals sponsored by an employer (business, government agency, non-profit, etc.). Fee-paying members of the general public are not permitted to register. For more information, please contact us at 1-866-716-6688.

Vendor Credits

TOP

SATV Redemption

Redeeming your Microsoft Software Assurance Training Vouchers:

  • (2) 5 Day SATV & (1) 2 Day SATV for a Classroom Live session
  • (2) 5 Day SATV & (1) 2 Day SATV for a Virtual Classroom Live session

Follow-On Courses

TOP
Training Exclusives

This course comes with extended access to the following benefits:

  • 12 months of practice labs
  • 12 months of 24x7 mentoring
  • 12 months access to class recordings
  • 12 months of unlimited retakes
  • Digital Courseware
  • 12 months of Transcender Practice Exams
  • 30 days access to Microsoft E-Reference Library
  • 30 days of recommended reading
  • Power Hours
Find out more
Course Delivery

This course is available in the following formats:

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 9 day

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 9 day

Request this course in a different delivery format.
Enroll