Subqueries and Predicate


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/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.

Target Audience
Database administrators, database developers, and BI professionals

Prerequisites
None

Expected Duration (hours)
1.6

Lesson Objectives

Subqueries and Predicate

  • 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
  • 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
  • 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
  • use subqueries in SQL Server 2016

    • Course Number:
    df_sqlq_a06_it_enus

    Expertise Level
    Expert