MCSA SQL 2012 / 2014 Certification

9 days

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 2012 / 2014 environment.



Course Description

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 official certification. If your goal is to learn how to use SQL Server 2012 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.  Click CertificationCamps – Microsoft SQL 2012 MCSA 9 Day to download complete course 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