Combining and Filtering Data with T-SQL

Following along with the exercise files, this course takes you from setting up the environment through writing more advanced queries using T-SQL functions, expressions, and logic.

Take your skills beyond the basics of T-SQL by learning how to apply the functionality T-SQL has to offer. In this course, Combining and Filtering Data with T-SQL, you will learn foundational knowledge of how to work with data and T-SQL. First, you will learn how to format and calculate data, and about logic functions. Next, you will discover how to join data from two or more tables. Finally, you will explore how to aggregate data to find the sum, minimum, maximum, count, and average values, as well as learn about intermediary tables. When you are finished with this course, you will have the skills and knowledge to write queries, validate results from a query, and work with variables.

• Course Overview 2mins
• Setting up the SQL Server Environment 22mins
• Shaping Data in a Query 48mins
• Querying Data from Multiple Tables Using JOINS 26mins
• Filtering and Controlling Flow 31mins
• Limiting the Results with T-SQL Functions 15mins
• Aggregating Data in a Query 27mins
• Using T-SQL Set Operators 13mins
• Simplifying with Intermediate Tables and Common Table Expressions 19mins
• Summary 0mins