• Online, Self-Paced
Course Description

SQL Server 2016 delivers many new features and enhancements. This course provides an overview of the SQL Server 2016 architecture, as well as the functions and capabilities available in each edition. The fundamentals of T-SQL querying is covered in this course, as well as topics such as sets and predicate logic. This course is one of a series of SkillSoft courses that cover the objectives for 70-761: Querying Data with Transact-SQL exam.

Learning Objectives

Introduction to Microsoft SQL Server 2016

  • start the course
  • recognize features of SQL Server 2016
  • list SQL Server 2016 editions and components
  • identify SQL Server 2016 functions and capabilities
  • list features of SQL Server Management Studio

T-SQL Querying

  • configure T-SQL statements in SQL Server 2016
  • work with T-SQL Language functions in SQL Server 2016
  • create T-SQL Variables in SQL Server 2016
  • demonstrate how to implement T-SQL expressions in SQL Server 2016
  • work with T-SQL control of flow, errors, and transactions in SQL Server 2016
  • use T-SQL comments in SQL Server 2016
  • work with T-SQL batch separators

SQL Server 2016 Sets

  • describe the characteristics of sets in SQL Server 2016
  • describe the set theory and how it relates to SQL Server 2015
  • describe applying set theory to SQL server queries

Predicate Logic

  • define predicate logic in SQL Server 2016
  • recognize the elements of a SELECT statement in SQL Server 2016
  • define the logical order of operations
  • demonstrate the logical order of operations when writing SELECT statements

Practice: Implementing and Querying Data

  • demonstrate querying data in SQL Server 2016

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.