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 2016describe the benefits of using scalar subqueriesdemonstrate how to write scalar subqueries in SQL Server 2016recognize how to write multi-valued subqueries in SQL Server 2016work with correlated subqueries in SQL Server 2016describe how to write correlated subqueriesrecognize how to write correlated subqueries with aliasesdescribe how to write correlated subqueries with aliases
-
describe how to write correlated subqueries in a HAVING clausedescribe how the EXISTS predicate evaluates data in SQL Server 2016describe how to write queries using EXISTS with subqueriesdemonstrate how to use EXISTS and NULLs in SQL Server 2016describe how to use EXISTS and INNER JOINS in SQL Server 2016demonstrate how to use NOT EXISTS with OUTER JOINsuse subqueries in SQL Server 2016
IN THIS COURSE
-
1.Subqueries Overview6m 29sUP NEXT
-
2.Scalar Subqueries2m 45s
-
3.Writing Effective Scalar Subqueries5m 13s
-
4.Multi-valued Subqueries6m 47s
-
5.Correlated Subqueries Overview4m 21s
-
6.Writing Correlated Subqueries9m 11s
-
7.Correlated Subqueries with Aliases5m 23s
-
8.Correlated Subqueries with Comparison Operators11m
-
9.Correlated Subqueries within a HAVING Clause7m 8s
-
10.EXISTS Predicate Overview2m 44s
-
11.Writing Queries That Use EXISTS with Subqueries5m 13s
-
12.EXISTS and NULLs4m 1s
-
13.EXISTS and INNER JOINs7m 13s
-
14.NOT EXISTS and OUTER JOINs4m 41s
-
15.Exercise: Using Subqueries in SQL Server 20166m 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.