Filter and Sort Data with TSQL

Filter and Sort Data with T-SQL
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch

What you’ll learn
Organizing large datasets into meaningful, manageable pieces is foundational to successful data analysis.
In this course, Filter and Sort Data with T-SQL, you’ll gain the ability to filter and sort data effectively to uncover insights and improve query performance.
First, you’ll explore how to filter data using specific parameters, ranges, and NULL values, including special considerations when working with NULL.
Finally, you’ll learn how to return subsets of data, a key technique for paging through large record sets in applications and websites.
When you’re finished with this course, you’ll have the skills and knowledge of filtering and sorting data with T-SQL needed to organize and refine datasets, analyze data validity, and write dynamic queries that return targeted portions of your data.