Operators & Expressions

SQL Server 2016
  • 16 Videos | 1h 37m 26s
  • Includes Assessment
  • Earns a Badge
Likes 23 Likes 23
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
  • Locked
    4. 
    Mixed UNION and UNION ALL Operators
    3m 37s
  • Locked
    5. 
    EXCEPT and INTERSECT Operators
    3m 35s
  • Locked
    6. 
    Using EXCEPT and INTERSECT Operators
    5m 29s
  • Locked
    7. 
    Order of Input Using the EXCEPT Operator
    7m 1s
  • Locked
    8. 
    NULL Values with the INTERSECT Operator
    4m 14s
  • Locked
    9. 
    APPLY Operator Overview
    4m 12s
  • Locked
    10. 
    Writing APPLY Statements
    6m 34s
  • Locked
    11. 
    CROSS APPLY Operator
    9m 37s
  • Locked
    12. 
    OUTER APPLY Operator
    3m 38s
  • Locked
    13. 
    Basic Components of Table Expressions
    5m
  • Locked
    14. 
    Table Expressions vs. Temporary Tables
    6m 46s
  • Locked
    15. 
    Recursive Table Expressions
    8m 31s
  • Locked
    16. 
    Exercise: Using Operators in SQL Server 2016
    5m 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.

YOU MIGHT ALSO LIKE

Likes 20 Likes 20  
Likes 31 Likes 31  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 34 Likes 34  
Likes 32 Likes 32  
Likes 16 Likes 16