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.
Author Name: Tamara Pattinson
Author Description:
Tamara Pattinson is a software developer, business consultant, and instructor with over 20 years of experience in Information Technology She has a passion for teaching and is the former Dean of Computer Science at a private college where she taught the full gamut of software development languages, SQL, database administration and design, and project management. In 2007, Tamara founded JET Technical located in beautiful Cache Valley Utah. While initially started to provide graduate students a… more

Table of Contents

• 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