Combining and Filtering Data with T-SQL 2019

Focused View

Tamara Pattinson

3:26:37

76 View

1. Course Overview

1. Course Overview.mp4

02:11

2. Setting up the SQL Server Environment

1. Version Check.mp4

00:15

2. Introduction.mp4

01:49

3. Setting up the SQL Server Environment.mp4

02:42

4. Creating SQL Server Databases.mp4

05:55

5. Using SQL Server Management Studio.mp4

10:39

6. Summary and Resources.mp4

00:38

3. Shaping Data in a Query

1. Introduction.mp4

01:37

2. The SELECT Query Syntax.mp4

01:07

3. Concatenating Values in T-SQL.mp4

04:35

4. Casting and Converting Data Types.mp4

07:30

5. Formatting Strings.mp4

08:59

6. Working with Characters.mp4

12:36

7. Formatting Dates and Numbers.mp4

10:52

8. Review and Resources.mp4

00:55

4. Querying Data from Multiple Tables Using JOINS

1. Introduction.mp4

01:04

2. Understanding Primary and Foreign Keys.mp4

04:06

3. Using the Inner Join.mp4

05:07

4. Left and Right Joins.mp4

03:27

5. Full OUTER Joins.mp4

03:19

6. Self Join.mp4

07:44

7. Review and Resources.mp4

01:37

5. Filtering and Controlling Flow

1. Introduction.mp4

01:28

2. Expressions and Comparison Operators.mp4

09:49

3. Applying T-SQL Logical Operators.mp4

08:14

4. Controlling Flow with T-SQL Logic.mp4

10:29

5. Review and Resources.mp4

01:35

6. Limiting the Results with T-SQL Functions

1. Introduction.mp4

01:42

2. Offset and Fetch.mp4

03:14

3. TOP Functions.mp4

05:19

4. Using Variables to Limit Results.mp4

04:00

5. Review and Resources.mp4

01:21

7. Aggregating Data in a Query

1. Introduction.mp4

00:41

2. Using COUNT in T-SQL.mp4

08:22

3. Using SUM in T-SQL.mp4

03:01

4. Using AVG in T-SQL.mp4

07:06

5. Using MIN and MAX in T-SQL.mp4

07:46

6. Review and Resources.mp4

00:50

8. Using T-SQL Set Operators

1. Introduction.mp4

00:44

2. Difference between Joins and Set Operators.mp4

00:42

3. Union All.mp4

01:49

4. Union.mp4

01:25

5. Intersect.mp4

02:37

6. Except.mp4

03:53

7. Review and Resources.mp4

01:57

9. Simplifying with Intermediate Tables and Common Table Expressions

1. Introduction.mp4

00:55

2. Using Common Table Expressions in T-SQL.mp4

07:52

3. Using Temporary Tables in T-SQL.mp4

04:05

4. Using Cursors in T-SQL.mp4

05:45

5. Review and Resources.mp4

00:48

10. Summary

1. Summary.mp4

00:24

Description

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.

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Database Programming

Microsoft SQL

Tamara Pattinson

Instructor's Courses

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 way to gain real-world experience under the tutelage of seasoned professionals, today, JET Technical is a global software development group comprised of professional software engineers and project management professionals. Tamara has focused on back-end development using tools such as Microsoft .NET technologies, C#, Visual Basic, PHP, database administration, and data science. She is currently a Technical Curriculum Manager at Pluralsight.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.