Font size:

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


Highlights:
  • 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

Prerequisites:
  • 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


Audience:
  • 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

Querying Microsoft SQL Server 2014 (M20461)

1. Introduction to Microsoft SQL Server 2014

  • SQL Server Architecture
  • SQL Server Editions and Versions
  • SQL Server Management Studio

2. Introduction to T-SQL Querying

  • T-SQL
  • Sets
  • Predicate Logic
  • Logical Order of Operations in SELECT Statements

3. Writing SELECT Queries

  • Writing Simple SELECT Statements
  • Eliminating Duplicates with DISTINCT
  • Using Column and Table Aliases
  • Writing Simple CASE Expressions

4. Querying Multiple Tables

  • Joins
  • Querying with Inner and Outer Joins
  • Querying with Cross Joins and Self Joins

5. Sorting and Filtering Data

  • Sorting Data
  • Filtering Data with a WHERE Clause
  • Filtering with the TOP and OFFSET-FETCH Options
  • Working with Unknown and Missing Values

6. Working with SQL Server 2014 Data Types

  • SQL Server 2014 Data Types
  • Working with Character Data
  • Working with Date and Time Data

7. DML to Modify Data

  • Insert Data
  • Modify and Delete Data

8. Using Built-In Functions

  • Writing Queries with Built-In Functions
  • Using Conversion Functions
  • Using Logical Functions
  • Using Functions to Work with NULL

9. Grouping and Aggregating Data

  • Using Aggregate Functions
  • Using the GROUP BY Clause
  • Filtering Groups with HAVING

10. Subqueries

  • Writing Self-Contained Subqueries
  • Writing Correlated Subqueries
  • Using the EXISTS Predicate with Subqueries

11. Using Table Expressions

  • Using Derived Tables
  • Using Common Table Expressions
  • Using Views
  • Using Inline Table-Valued Functions

12. Using Set Operators

  • Writing Queries with the UNION Operator
  • Using EXCEPT and INTERSECT
  • Using APPLY

13. Using Window Ranking, Offset, and Aggregate Functions

  • Creating Windows with OVER
  • Exploring Window Functions

14. Pivoting and Grouping Sets

  • Writing Queries with PIVOT and UNPIVOT
  • Working with Grouping Sets

15. Query Data with Stored Procedures

  • Querying Data with Stored Procedures
  • Passing Parameters to Stored Procedures
  • Creating Simple Stored Procedures
  • Working with Dynamic SQL

16. Programming with T-SQL

  • T-SQL Programming Elements
  • Controlling Program Flow

17. Implementing Error Handling

  • Using TRY/CATCH Blocks
  • Working with Error Information

18. Implementing Transactions

  • Transactions and the Database Engine
  • Controlling Transactions

19. Appendix 1: Improve Query Performance

  • Factors in Query Performance
  • Display Query Performance Data

20. Appendix 2: Query SQL Server Metadata

  • Query System Catalog Views and Functions
  • Execute System Stored Procedures
  • Query Dynamic Management Objects

 

Administering Microsoft SQL Server Databases 2014 (M20462)

1. Introduction to SQL Server 2014 Database Administration

  • Database Administration Overview
  • Introduction to the SQL Server Platform
  • Database Management Tools and Techniques

2. Installing and Configuring SQL Server 2014

  • Plan SQL Server Installation
  • Install SQL Server 2014 and Post-Installation Configuration

3. Work with Databases and Storage

  • Introduction to Data Stora
Find a class and register in three easy steps:
  • 1. Select Location:
  • 2. Select Date Range:
    to
  • 3. Select Class Type:
    • All Types
    • C Classroom
    • V Virtual Live
    • Cv In-Class Virtual
    • O Online
TX DALLAS11/27/2017 8:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>9 days6595.001862604
Virtual Live11/27/2017 8:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>9 days6495.001869417
Virtual Live1/8/2018 8:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>9 days6495.001869421
GA Atlanta1/8/2018 8:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>9 days6595.001862596
Virtual Live1/22/2018 11:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>9 days6495.001869423
Virtual Live2/12/2018 8:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>9 days6495.001869426
NC Cary2/19/2018 8:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>9 days6595.001862602
IL Schaumburg3/12/2018 8:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>9 days6595.001862598
Virtual Live3/19/2018 8:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>9 days6495.001869416
Virtual Live4/16/2018 8:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>9 days6495.001869420
NJ MORRISTOWN4/23/2018 8:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>9 days6595.001862597
Virtual Live4/30/2018 11:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>9 days6495.001869422
TX DALLAS5/7/2018 8:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>9 days6595.001862595
Virtual Live5/14/2018 8:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>9 days6495.001869425
seek-warrow-w
  • 1
arrow-eseek-eitems per page1 - 14 of 14 items