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

  • 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

BOOK High Performance SQL Server: Consistent Response for Mission-Critical Applications, Second Edition
COURSE SQL Programming with MariaDB: Analyzing Relational Data
Likes 9 Likes 9  
COURSE T-SQL Queries
Likes 173 Likes 173  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Operators & Expressions
Likes 34 Likes 34  
COURSE Sets & Predicate Logic
Likes 29 Likes 29  
COURSE Database Programmability Objects & Non-relational Data
Likes 49 Likes 49