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
    FREE ACCESS
  • Locked
    4. 
    Multi-valued Subqueries
    6m 47s
    FREE ACCESS
  • Locked
    5. 
    Correlated Subqueries Overview
    4m 21s
    FREE ACCESS
  • Locked
    6. 
    Writing Correlated Subqueries
    9m 11s
    FREE ACCESS
  • Locked
    7. 
    Correlated Subqueries with Aliases
    5m 23s
    FREE ACCESS
  • Locked
    8. 
    Correlated Subqueries with Comparison Operators
    11m
    FREE ACCESS
  • Locked
    9. 
    Correlated Subqueries within a HAVING Clause
    7m 8s
    FREE ACCESS
  • Locked
    10. 
    EXISTS Predicate Overview
    2m 44s
    FREE ACCESS
  • Locked
    11. 
    Writing Queries That Use EXISTS with Subqueries
    5m 13s
    FREE ACCESS
  • Locked
    12. 
    EXISTS and NULLs
    4m 1s
    FREE ACCESS
  • Locked
    13. 
    EXISTS and INNER JOINs
    7m 13s
    FREE ACCESS
  • Locked
    14. 
    NOT EXISTS and OUTER JOINs
    4m 41s
    FREE ACCESS
  • Locked
    15. 
    Exercise: Using Subqueries in SQL Server 2016
    6m 12s
    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 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

COURSE Modifying Data
Likes 20 Likes 20  
COURSE Index Design Guidelines
Likes 33 Likes 33  
COURSE Optimizing Statisitics & Indexes
Likes 26 Likes 26  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Optimizing Statisitics & Indexes
Likes 26 Likes 26  
COURSE Modifying Data
Likes 20 Likes 20  
COURSE Using Functions
Likes 32 Likes 32