Subqueries & the EXISTS Predicate

SQL 2016    |    Intermediate
  • 15 Videos | 1h 35m 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

  • Playable
    1. 
    Subqueries Overview
    6m 29s
    UP NEXT
  • Playable
    2. 
    Scalar Subqueries
    2m 45s
  • Locked
    3. 
    Writing Effective Scalar Subqueries
    5m 13s
  • Locked
    4. 
    Multi-valued Subqueries
    6m 47s
  • Locked
    5. 
    Correlated Subqueries Overview
    4m 21s
  • Locked
    6. 
    Writing Correlated Subqueries
    9m 11s
  • Locked
    7. 
    Correlated Subqueries with Aliases
    5m 23s
  • Locked
    8. 
    Correlated Subqueries with Comparison Operators
    11m
  • Locked
    9. 
    Correlated Subqueries within a HAVING Clause
    7m 8s
  • Locked
    10. 
    EXISTS Predicate Overview
    2m 44s
  • Locked
    11. 
    Writing Queries That Use EXISTS with Subqueries
    5m 13s
  • Locked
    12. 
    EXISTS and NULLs
    4m 1s
  • Locked
    13. 
    EXISTS and INNER JOINs
    7m 13s
  • Locked
    14. 
    NOT EXISTS and OUTER JOINs
    4m 41s
  • Locked
    15. 
    Exercise: Using Subqueries in SQL Server 2016
    6m 12s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 20 Likes 20  
Likes 33 Likes 33  
Likes 26 Likes 26  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 26 Likes 26  
Likes 20 Likes 20  
Likes 32 Likes 32