SQL Server 2012/2014 Boot Camp

Session Detail:    Classroom, Virtual 9 Day

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

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

Who Can Benefit

  • 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

Session Outline

Class Outline

Module 1: Querying Microsoft SQL Server 2014

  • Lesson 1: SQL Server Architecture
  • Lesson 2: SQL Server Editions and Versions
  • Lesson 3: SQL Server Management Studio

Module 2: Introduction to T-SQL Querying

  • Lesson 1: T-SQL
  • Lesson 2: Sets
  • Lesson 3: Predicate Logic
  • Lesson 4: Logical Order of Operations in SELECT Statements

Module 3: Writing SELECT Queries

  • Lesson 1: Writing Simple SELECT Statements
  • Lesson 2: Eliminating Duplicates with DISTINCT
  • Lesson 3: Using Column and Table Aliases
  • Lesson 4: Writing Simple CASE Expressions

Module 4: Querying Multiple Tables

  • Lesson 1: Joins
  • Lesson 2: Querying with Inner and Outer Joins
  • Lesson 3: Querying with Cross Joins and Self Joins

Module 5: Sorting and Filtering Data

  • Lesson 1: Sorting Data
  • Lesson 2: Filtering Data with a WHERE Clause
  • Lesson 3: Filtering with the TOP and OFFSET-FETCH Options
  • Lesson 4: Working with Unknown and Missing Values

Module 6: Working with SQL Server 2014 Data Types

  • Lesson 1: SQL Server 2014 Data Types
  • Lesson 2: Working with Character Data
  • Lesson 3: Working with Date and Time Data

Module 7: DML to Modify Data

  • Lesson 1: Insert Data
  • Lesson 2: Modify and Delete Data

Module 8: Using Built-In Functions

  • Lesson 1: Writing Queries with Built-In Functions
  • Lesson 2: Using Conversion Functions
  • Lesson 3: Using Logical Functions
  • Lesson 4: Using Functions to Work with NULL

Module 9: Grouping and Aggregating Data

  • Lesson 1: Using Aggregate Functions
  • Lesson 2: Using the GROUP BY Clause
  • Lesson 3: Filtering Groups with HAVING

Module 10: Subqueries

  • Lesson 1: Writing Self-Contained Subqueries
  • Lesson 2: Writing Correlated Subqueries
  • Lesson 3: Using the EXISTS Predicate with Subqueries

Module 11: Using Table Expressions

  • Lesson 1: Using Derived Tables
  • Lesson 2: Using Common Table Expressions
  • Lesson 3: Using Views
  • Lesson 4: Using Inline Table-Valued Functions

Module 12: Using Set Operators

  • Lesson 1: Writing Queries with the UNION Operator
  • Lesson 2: Using EXCEPT and INTERSECT
  • Lesson 3: Using APPLY

Module 13: Using Window Ranking, Offset, and Aggregate Functions

  • Lesson 1: Creating Windows with OVER
  • Lesson 2: Exploring Window Functions

Module 14: Pivoting and Grouping Sets

  • Lesson 1: Writing Queries with PIVOT and UNPIVOT
  • Lesson 2: Working with Grouping Sets

Module 15: Query Data with Stored Procedures

  • Lesson 1: Querying Data with Stored Procedures
  • Lesson 2: Passing Parameters to Stored Procedures
  • Lesson 3: Creating Simple Stored Procedures
  • Lesson 4: Working with Dynamic SQL

Module 16: Programming with T-SQL

  • Lesson 1: T-SQL Programming Elements
  • Lesson 2: Controlling Program Flow

Module 17: Implementing Error Handling

  • Lesson 1: Using TRY/CATCH Blocks
  • Lesson 2: Working with Error Information

Module 18: Implementing Transactions

  • Lesson 1: Transactions and the Database Engine
  • Lesson 2: Controlling Transactions

Module 19: Improve Query Performance

  • Lesson 1: Factors in Query Performance
  • Lesson 2: Display Query Performance Data

Module 20: Query SQL Server Metadata

  • Lesson 1: Query System Catalog Views and Functions
  • Lesson 2: Execute System Stored Procedures
  • Lesson 3: Query Dynamic Management Objects

Need to train your team?

All of our sessions can be customized to meet your team’s specific need. Build the perfect program by picking and choosing topics from any of the courses in our catalog. A personalized private session gives you the ultimate flexibility and helps maximize your team’s valuable time!

Requesting Team Training
DateTimeTypePriceAdd To Cart

SQL Server 2012/2014 Boot Camp

9 Day
Classroom, Virtual

$6595.00

Chat with a Coach

Chat with a Coach

Have a more immediate need? Why spend the next hour searching online for answers when you can spend just 15 minutes with one of our experts and get accurate and personalized answers to all of your questions. 

$9.99 | 15 Minutes

Book Now