• Online, Self-Paced
Course Description

Subqueries in SQL Server 2016 are nested SELECT statements used to created more effective queries in T-SQL. This course will introduce subqueries and correlated subqueries, and cover the EXISTS predicate, a mechanism used in SQL Server 2016 to check whether any results will be returned from a specific query. This course is one of a series of courses that cover the objectives for 70-761: Querying Data with Transact-SQL exam.

Learning Objectives

Working with Subqueries

  • start the course
  • recognize when and where to use subqueries in SQL Server 2016
  • describe the benefits of using scalar subqueries
  • demonstrate how to write scalar subqueries in SQL Server 2016
  • recognize how to write multi-valued subqueries in SQL Server 2016

Correlated Subqueries

  • work with correlated subqueries in SQL Server 2016
  • describe how to write correlated subqueries
  • recognize how to write correlated subqueries with aliases
  • describe how to write correlated subqueries with aliases
  • describe how to write correlated subqueries in a HAVING clause

EXISTS Predicate

  • describe how the EXISTS predicate evaluates data in SQL Server 2016
  • describe how to write queries using EXISTS with subqueries
  • demonstrate how to use EXISTS and NULLs in SQL Server 2016
  • describe how to use EXISTS and INNER JOINS in SQL Server 2016
  • demonstrate how to use NOT EXISTS with OUTER JOINs

Practice: Creating Subqueries in SQL Server 2016

  • use subqueries in SQL Server 2016

Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Data Administration
  • Systems Administration