Operators & Expressions
SQL Server 2016
| Intermediate
- 16 Videos | 1h 29m 56s
- Includes Assessment
- Earns a Badge
Set operators in SQL Server 2016 are used to compare rows between input sets. Explore the UNION, INTERSECT, and EXCEPT set operators, the APPLY operator, and the basic components of common table expressions.
WHAT YOU WILL LEARN
-
distinguish when to use the UNION and UNION All operators in SQL Server 2016demonstrate how to write SQL Server 2016 queries that use the UNION operatordemonstrate how to write SQL Server 2016 queries that use the UNION ALL operatordemonstrate how to use the UNION and UNION ALL operators togetherrecognize when to use the EXCEPT operator in SQL Server 2016demonstrate how to use the EXCEPT and INTERSECT operators in SQL Server 2016determine the results of reversing the order of input with the EXCEPT operatordetermine the effect of NULL values on the INTERSECT operator
-
recognize when to use the APPLY operator in SQL Server 2016use APPLY statements that return given data based on supplied data in SQL Server 2016use CROSS APPLY operators in SQL Server 2016use OUTER APPLY operators in SQL Server 2016recognize the basic components of table expressions in SQL Server 2016describe the difference between table expressions and temporary tablescreate recursive table expressions in SQL Server 2016use operators in SQL Server 2016
IN THIS COURSE
-
1.UNION vs. UNION ALL Operators4m 38sUP NEXT
-
2.Writing Queries That Use the UNION Operator7m 44s
-
3.Writing Queries That Use the UNION ALL Operator3m 20s
-
4.Mixed UNION and UNION ALL Operators3m 37s
-
5.EXCEPT and INTERSECT Operators3m 35s
-
6.Using EXCEPT and INTERSECT Operators5m 29s
-
7.Order of Input Using the EXCEPT Operator7m 1s
-
8.NULL Values with the INTERSECT Operator4m 14s
-
9.APPLY Operator Overview4m 12s
-
10.Writing APPLY Statements6m 34s
-
11.CROSS APPLY Operator9m 37s
-
12.OUTER APPLY Operator3m 38s
-
13.Basic Components of Table Expressions5m
-
14.Table Expressions vs. Temporary Tables6m 46s
-
15.Recursive Table Expressions8m 31s
-
16.Exercise: Using Operators in SQL Server 20165m 59s
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.