Featured resource
pluralsight tech forecast
2025 Tech Forecast

Which technologies will dominate in 2025? And what skills do you need to keep up?

Check it out
Hamburger Icon
  • Course
    • Libraries: If you want this course, consider one of these libraries.
    • Data

Combining and Filtering Data with T-SQL 2019

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.

Tamara Pattinson - Pluralsight course - Combining and Filtering Data with T-SQL 2019
by Tamara Pattinson

What you'll learn

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.

Table of contents

About the author

Tamara Pattinson - Pluralsight course - Combining and Filtering Data with T-SQL 2019
Tamara Pattinson

Tamara Pattinson is the founder of JET Technical (www.jettechnical.com) and has been involved in the IT world and project management for over 20 years. As a former Dean of Computer Science she taught the full gamut of software development languages, SQL, database administration and design, and project management.

More Courses by Tamara