Subqueries & the EXISTS Predicate

SQL 2016    |    Intermediate
  • 15 videos | 1h 28m 20s
  • Includes Assessment
  • Earns a Badge
Likes 38 Likes 38
Subqueries in SQL Server 2016 are nested SELECT statements used to create more effective queries in T-SQL. Explore subqueries and correlated subqueries and the EXISTS predicate.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • 6m 29s
    After completing this video, you will be able to recognize when and where to use subqueries in SQL Server 2016. FREE ACCESS
  • 2m 45s
    After completing this video, you will be able to describe the benefits of using scalar subqueries. FREE ACCESS
  • Locked
    3.  Writing Effective Scalar Subqueries
    5m 13s
    In this video, you will learn how to write scalar subqueries in SQL Server 2016. FREE ACCESS
  • Locked
    4.  Multi-valued Subqueries
    6m 47s
    After completing this video, you will be able to recognize how to write multi-valued subqueries in SQL Server 2016. FREE ACCESS
  • Locked
    5.  Correlated Subqueries Overview
    4m 21s
    Find out how to work with correlated subqueries in SQL Server 2016. FREE ACCESS
  • Locked
    6.  Writing Correlated Subqueries
    9m 11s
    After completing this video, you will be able to describe how to write subqueries that are correlated. FREE ACCESS
  • Locked
    7.  Correlated Subqueries with Aliases
    5m 23s
    After completing this video, you will be able to recognize how to write correlated subqueries with aliases. FREE ACCESS
  • Locked
    8.  Correlated Subqueries with Comparison Operators
    11m
    After completing this video, you will be able to describe how to write subqueries that are correlated with aliases. FREE ACCESS
  • Locked
    9.  Correlated Subqueries within a HAVING Clause
    7m 8s
    After completing this video, you will be able to describe how to write correlated subqueries in a HAVING clause. FREE ACCESS
  • Locked
    10.  EXISTS Predicate Overview
    2m 44s
    After completing this video, you will be able to describe how the EXISTS predicate evaluates data in SQL Server 2016. FREE ACCESS
  • Locked
    11.  Writing Queries That Use EXISTS with Subqueries
    5m 13s
    After completing this video, you will be able to describe how to write queries using EXISTS with subqueries. FREE ACCESS
  • Locked
    12.  EXISTS and NULLs
    4m 1s
    In this video, you will learn how to use EXISTS and NULLs in SQL Server 2016. FREE ACCESS
  • Locked
    13.  EXISTS and INNER JOINs
    7m 13s
    Upon completion of this video, you will be able to describe how to use EXISTS and INNER JOINS in SQL Server 2016. FREE ACCESS
  • Locked
    14.  NOT EXISTS and OUTER JOINs
    4m 41s
    In this video, you will learn how to use NOT EXISTS with LEFT JOINs. FREE ACCESS
  • Locked
    15.  Exercise: Using Subqueries in SQL Server 2016
    6m 12s
    In this video, find out how to use subqueries in SQL Server 2016. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Querying & Manipulating Data
Likes 112 Likes 112  
Book PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries
Book Querying MySQL: Make your MySQL Database Analytics Accessible with SQL Operations, Data extraction, and Custom Queries

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Using Functions
Likes 52 Likes 52  
Course SQL Databases Using SQLAlchemy: Using Triggers, Stored Procedures, & Transactions
Likes 21 Likes 21  
Course Managing Database Integrity
Likes 37 Likes 37