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.
Course info
Rating
(132)
Level
Beginner
Updated
Jun 17, 2021
Duration
3h 26m
Table of contents
Course Overview
Setting up the SQL Server Environment
Shaping Data in a Query
Querying Data from Multiple Tables Using JOINS
Filtering and Controlling Flow
Limiting the Results with T-SQL Functions
Aggregating Data in a Query
Using T-SQL Set Operators
Simplifying with Intermediate Tables and Common Table Expressions
Summary
Description
Course info
Rating
(132)
Level
Beginner
Updated
Jun 17, 2021
Duration
3h 26m
Your 10-day individual free trial includes:

Expert-led courses

Keep up with the pace of change with thousands of expert-led, in-depth courses.
Description

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.

About the author
About the author

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.

Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone. My name is Tamara Pattinson, and welcome to my course, Combining and Filtering Data with T‑SQL. I've been involved with database management and programming for over 20 years, and I'm a former Associate Dean of Computer Science. So I enjoy teaching, and I have a passion for data, which is why I'm so excited to bring this course to you and help you begin your journey learning how to use the Transact Structured Query language. Some of the major topics we're going to cover are how to set up the SQL Server environment, work with Management Studio, creating databases using scripts and backup files, formatting strings, working with characters, dates, and numeric values, querying data from multiple sources, and understanding primary and foreign keys, how to filter and apply logic to control the execution of your queries, aggregation, set operators, and how to use common table expressions and intermediary tables. I'm also going to introduce you to user‑defined functions that can take the work out of repetitive tasks. And because queries are only as good as they are accurate, this course content will always focus on data integrity and best practices. All of the demonstration queries have been included in the exercise files so that you can follow along, gaining hands‑on experience as we progress through the course, I'm going to provide you with a real‑world example of how queries work in a web‑based table. By the end of this course, you'll have the knowledge you need to write queries for reporting, software applications, and data analytics. From here, you're going to be prepared to dive into the more advanced T‑SQL techniques of creating views, stored procedures, and user‑defined functions. I'm not expecting you to have any prior knowledge of programming or the structured query language. So if you're just starting out, this is a great place to begin. I hope you'll join me on this journey learning T‑SQL at Pluralsight.