Filtering Data
SQL Server 2016
| Intermediate
- 8 Videos | 52m 14s
- Includes Assessment
- Earns a Badge
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
-
1.ORDER BY Clause7m 5sUP NEXT
-
2.Sorting Data6m 32s
-
3.Filtering Data5m 33s
-
4.WHERE Clause7m 51s
-
5.Predicates and Operators8m 42s
-
6.Three-valued Logic4m 3s
-
7.NULL in Queries4m 21s
-
8.Testing for NULL4m 6s
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.
