Sets & Predicate Logic

SQL Server 2016    |    Intermediate
  • 8 videos | 47m 35s
  • Includes Assessment
  • Earns a Badge
Rating 4.8 of 22 users Rating 4.8 of 22 users (22)
SQL Server 2016 delivers many new features and enhancements. Explore an overview of the SQL Server 2016 architecture, from topics such as sets and predicate logic.

WHAT YOU WILL LEARN

  • Describe the characteristics of sets in sql server 2016
    Describe the set theory and how it relates to sql server 2015
    Describe applying set theory to sql server queries
    Define predicate logic in sql server 2016
  • Recognize the elements of a select statement in sql server 2016
    Define the logical order of operations
    Demonstrate the logical order of operations when writing select statements
    Demonstrate querying data in sql server 2016

IN THIS COURSE

  • 6m 53s
    After completing this video, you will be able to describe the characteristics of sets in SQL Server 2016. FREE ACCESS
  • 5m 57s
    After completing this video, you will be able to describe set theory and how it relates to SQL Server 2015. FREE ACCESS
  • Locked
    3.  Set Theory and SQL Server 2016 Queries
    2m 27s
    After completing this video, you will be able to describe how to apply set theory to SQL server queries. FREE ACCESS
  • Locked
    4.  Predicate Logic Overview
    5m 50s
    In this video, you will learn how to define predicate logic in SQL Server 2016. FREE ACCESS
  • Locked
    5.  Elements of a SELECT Statement
    6m 16s
    After completing this video, you will be able to recognize the elements of a SELECT statement in SQL Server 2016. FREE ACCESS
  • Locked
    6.  Logical Order of Operations
    7m 21s
    In this video, you will learn how to define the order of operations. FREE ACCESS
  • Locked
    7.  Applying Logical Order of Operations
    7m 36s
    Learn how to apply the standard order of operations when writing SELECT statements. FREE ACCESS
  • Locked
    8.  Exercise: Querying Data with Transact-SQL
    5m 17s
    In this video, you will learn how to query data 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

Journey How to Transform Tables with SQL
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)
Book Querying MySQL: Make your MySQL Database Analytics Accessible with SQL Operations, Data extraction, and Custom Queries
Book Pro T-SQL 2022: Toward Speed, Scalability, and Standardization for SQL Server Developers, 2nd Edition

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Filtering Data
Rating 4.5 of 86 users Rating 4.5 of 86 users (86)
Course Subqueries & the EXISTS Predicate
Rating 4.7 of 53 users Rating 4.7 of 53 users (53)
Course Implementation, Creation, & Troubleshooting
Rating 4.3 of 3 users Rating 4.3 of 3 users (3)