Subqueries & the EXISTS Predicate
SQL 2016
| Intermediate
- 15 videos | 1h 28m 20s
- Includes Assessment
- Earns a Badge
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 29sAfter completing this video, you will be able to recognize when and where to use subqueries in SQL Server 2016. FREE ACCESS
-
2m 45sAfter completing this video, you will be able to describe the benefits of using scalar subqueries. FREE ACCESS
-
3. Writing Effective Scalar Subqueries5m 13sIn this video, you will learn how to write scalar subqueries in SQL Server 2016. FREE ACCESS
-
4. Multi-valued Subqueries6m 47sAfter completing this video, you will be able to recognize how to write multi-valued subqueries in SQL Server 2016. FREE ACCESS
-
5. Correlated Subqueries Overview4m 21sFind out how to work with correlated subqueries in SQL Server 2016. FREE ACCESS
-
6. Writing Correlated Subqueries9m 11sAfter completing this video, you will be able to describe how to write subqueries that are correlated. FREE ACCESS
-
7. Correlated Subqueries with Aliases5m 23sAfter completing this video, you will be able to recognize how to write correlated subqueries with aliases. FREE ACCESS
-
8. Correlated Subqueries with Comparison Operators11mAfter completing this video, you will be able to describe how to write subqueries that are correlated with aliases. FREE ACCESS
-
9. Correlated Subqueries within a HAVING Clause7m 8sAfter completing this video, you will be able to describe how to write correlated subqueries in a HAVING clause. FREE ACCESS
-
10. EXISTS Predicate Overview2m 44sAfter completing this video, you will be able to describe how the EXISTS predicate evaluates data in SQL Server 2016. FREE ACCESS
-
11. Writing Queries That Use EXISTS with Subqueries5m 13sAfter completing this video, you will be able to describe how to write queries using EXISTS with subqueries. FREE ACCESS
-
12. EXISTS and NULLs4m 1sIn this video, you will learn how to use EXISTS and NULLs in SQL Server 2016. FREE ACCESS
-
13. EXISTS and INNER JOINs7m 13sUpon completion of this video, you will be able to describe how to use EXISTS and INNER JOINS in SQL Server 2016. FREE ACCESS
-
14. NOT EXISTS and OUTER JOINs4m 41sIn this video, you will learn how to use NOT EXISTS with LEFT JOINs. FREE ACCESS
-
15. Exercise: Using Subqueries in SQL Server 20166m 12sIn 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.
