Operators & Expressions

SQL Server 2016    |    Intermediate
  • 16 Videos | 1h 29m 56s
  • Includes Assessment
  • Earns a Badge
Likes 34 Likes 34
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 2016
    demonstrate how to write SQL Server 2016 queries that use the UNION operator
    demonstrate how to write SQL Server 2016 queries that use the UNION ALL operator
    demonstrate how to use the UNION and UNION ALL operators together
    recognize when to use the EXCEPT operator in SQL Server 2016
    demonstrate how to use the EXCEPT and INTERSECT operators in SQL Server 2016
    determine the results of reversing the order of input with the EXCEPT operator
    determine the effect of NULL values on the INTERSECT operator
  • recognize when to use the APPLY operator in SQL Server 2016
    use APPLY statements that return given data based on supplied data in SQL Server 2016
    use CROSS APPLY operators in SQL Server 2016
    use OUTER APPLY operators in SQL Server 2016
    recognize the basic components of table expressions in SQL Server 2016
    describe the difference between table expressions and temporary tables
    create recursive table expressions in SQL Server 2016
    use operators in SQL Server 2016

IN THIS COURSE

  • Playable
    1. 
    UNION vs. UNION ALL Operators
    4m 38s
    UP NEXT
  • Playable
    2. 
    Writing Queries That Use the UNION Operator
    7m 44s
  • Locked
    3. 
    Writing Queries That Use the UNION ALL Operator
    3m 20s
    FREE ACCESS
  • Locked
    4. 
    Mixed UNION and UNION ALL Operators
    3m 37s
    FREE ACCESS
  • Locked
    5. 
    EXCEPT and INTERSECT Operators
    3m 35s
    FREE ACCESS
  • Locked
    6. 
    Using EXCEPT and INTERSECT Operators
    5m 29s
    FREE ACCESS
  • Locked
    7. 
    Order of Input Using the EXCEPT Operator
    7m 1s
    FREE ACCESS
  • Locked
    8. 
    NULL Values with the INTERSECT Operator
    4m 14s
    FREE ACCESS
  • Locked
    9. 
    APPLY Operator Overview
    4m 12s
    FREE ACCESS
  • Locked
    10. 
    Writing APPLY Statements
    6m 34s
    FREE ACCESS
  • Locked
    11. 
    CROSS APPLY Operator
    9m 37s
    FREE ACCESS
  • Locked
    12. 
    OUTER APPLY Operator
    3m 38s
    FREE ACCESS
  • Locked
    13. 
    Basic Components of Table Expressions
    5m
    FREE ACCESS
  • Locked
    14. 
    Table Expressions vs. Temporary Tables
    6m 46s
    FREE ACCESS
  • Locked
    15. 
    Recursive Table Expressions
    8m 31s
    FREE ACCESS
  • Locked
    16. 
    Exercise: Using Operators in SQL Server 2016
    5m 59s
    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 Filtering Data
Likes 31 Likes 31  
COURSE Oracle Database 12c R2 SQL: Using the Set Operators
Likes 28 Likes 28  
COURSE Database Programmability Objects & Non-relational Data
Likes 22 Likes 22  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Querying & Manipulating Data
Likes 61 Likes 61  
COURSE SQL 2016 Tables
Likes 166 Likes 166  
COURSE Using GROUP BY, PIVOT, & UNPIVOT
Likes 25 Likes 25