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.

Next, you’ll discover how to filter based on partial field values and patterns, such as finding all names that begin with a certain letter or contain a specific substring.

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.