Operators & Expressions

SQL Server 2016    |    Intermediate
  • 16 videos | 1h 29m 56s
  • Includes Assessment
  • Earns a Badge
Rating 4.7 of 45 users Rating 4.7 of 45 users (45)
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

  • 4m 38s
    Find out how to distinguish when to use the UNION and UNION All operators in SQL Server 2016. FREE ACCESS
  • 7m 44s
    In this video, you will learn how to write SQL Server 2016 queries that use the UNION operator. FREE ACCESS
  • Locked
    3.  Writing Queries That Use the UNION ALL Operator
    3m 20s
    In this video, you will learn how to write SQL Server 2016 queries that use the UNION ALL operator. FREE ACCESS
  • Locked
    4.  Mixed UNION and UNION ALL Operators
    3m 37s
    In this video, you will learn how to use the UNION and UNION ALL operators together. FREE ACCESS
  • Locked
    5.  EXCEPT and INTERSECT Operators
    3m 35s
    Upon completion of this video, you will be able to recognize when to use the EXCEPT operator in SQL Server 2016. FREE ACCESS
  • Locked
    6.  Using EXCEPT and INTERSECT Operators
    5m 29s
    In this video, you will learn how to use the EXCEPT and INTERSECT operators in SQL Server 2016. FREE ACCESS
  • Locked
    7.  Order of Input Using the EXCEPT Operator
    7m 1s
    In this video, find out how to determine the results of reversing the order of input with the EXCEPT operator. FREE ACCESS
  • Locked
    8.  NULL Values with the INTERSECT Operator
    4m 14s
    To find out how NULL values affect the INTERSECT operator, determine how the operator is affected by these values. FREE ACCESS
  • Locked
    9.  APPLY Operator Overview
    4m 12s
    After completing this video, you will be able to recognize when to use the APPLY operator in SQL Server 2016. FREE ACCESS
  • Locked
    10.  Writing APPLY Statements
    6m 34s
    During this video, you will learn how to use APPLY statements to return given data based on supplied data in SQL Server 2016. FREE ACCESS
  • Locked
    11.  CROSS APPLY Operator
    9m 37s
    In this video, you will learn how to use CROSS APPLY operators in SQL Server 2016. FREE ACCESS
  • Locked
    12.  OUTER APPLY Operator
    3m 38s
    In this video, find out how to use the OUTER APPLY operators in SQL Server 2016. FREE ACCESS
  • Locked
    13.  Basic Components of Table Expressions
    5m
    After completing this video, you will be able to recognize the basic components of table expressions in SQL Server 2016. FREE ACCESS
  • Locked
    14.  Table Expressions vs. Temporary Tables
    6m 46s
    After completing this video, you will be able to describe the difference between table expressions and temporary tables. FREE ACCESS
  • Locked
    15.  Recursive Table Expressions
    8m 31s
    In this video, you will learn how to create recursive table expressions in SQL Server 2016. FREE ACCESS
  • Locked
    16.  Exercise: Using Operators in SQL Server 2016
    5m 59s
    In this video, you will learn how to use operators 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.

YOU MIGHT ALSO LIKE

Course Introduction to SQL Bootcamp: Session 4 Replay
Rating 4.5 of 151 users Rating 4.5 of 151 users (151)
Book Querying MySQL: Make your MySQL Database Analytics Accessible with SQL Operations, Data extraction, and Custom Queries
Course Math & Optimizations: Introducing Sets & Set Operations
Rating 4.4 of 177 users Rating 4.4 of 177 users (177)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Optimize Locking Behavior
Rating 4.6 of 39 users Rating 4.6 of 39 users (39)
Course Data Access & Permissions
Rating 4.6 of 86 users Rating 4.6 of 86 users (86)
Course Managing Database Integrity
Rating 4.6 of 34 users Rating 4.6 of 34 users (34)