Filtering Data

SQL Server 2016    |    Intermediate
  • 8 videos | 48m 14s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 86 users Rating 4.5 of 86 users (86)
SQL Server 2016 offers various clauses that work in conjunction with SELECT statements. Discover how to sort and filter data, use predicates and operators, and use NULL in queries.

WHAT YOU WILL LEARN

  • Describe the order by clause in sql server 2016
    Demonstrate how to sort data in sql server 2016 using the order by clause
    Recognize how to filter data in sql server 2016
    Demonstrate how to filter data in sql server 2016 using the where clause
  • Describe how to use predicates and operators in sql server 2016
    Describe three-valued logic in sql server 2016
    Work with null in queries in sql server 2016
    Describe how to test for null in sql server 2016

IN THIS COURSE

  • 7m 5s
    After completing this video, you will be able to describe the ORDER BY clause in SQL Server 2016. FREE ACCESS
  • 6m 32s
    In this video, you will learn how to sort data in SQL Server 2016 using the ORDER BY clause. FREE ACCESS
  • Locked
    3.  Filtering Data
    5m 33s
    After completing this video, you will be able to recognize how to filter data in SQL Server 2016. FREE ACCESS
  • Locked
    4.  WHERE Clause
    7m 51s
    In this video, you will learn how to filter data in SQL Server 2016 using the WHERE clause. FREE ACCESS
  • Locked
    5.  Predicates and Operators
    8m 42s
    Upon completion of this video, you will be able to describe how to use predicates and operators in SQL Server 2016. FREE ACCESS
  • Locked
    6.  Three-valued Logic
    4m 3s
    After completing this video, you will be able to describe three-valued logic in SQL Server 2016. FREE ACCESS
  • Locked
    7.  NULL in Queries
    4m 21s
    Learn how to work with NULL values in Queries in SQL Server 2016. FREE ACCESS
  • Locked
    8.  Testing for NULL
    4m 6s
    After completing this video, you will be able to describe how to test for NULL 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

Book SQL Server 2022 Query Performance Tuning: Troubleshoot and Optimize Query Performance, 6th Edition
Course CompTIA Data+: Query Optimization
Rating 5.0 of 4 users Rating 5.0 of 4 users (4)
Course Querying SQL Databases: Learning SQL Using Prompt Engineering
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Subqueries & the EXISTS Predicate
Rating 4.7 of 53 users Rating 4.7 of 53 users (53)
Course Functions
Rating 4.5 of 43 users Rating 4.5 of 43 users (43)
Course Using Aggregate Functions
Rating 4.7 of 46 users Rating 4.7 of 46 users (46)