Combining and Filtering Data with T-SQL 2019

Focused View

Tamara Pattinson

3:09:22

38 View

00. Course Overview

00. Course Overview.mp4

01:39

01. Setting up the Environment

00. Setting up the Environment.mp4

05:31

02. Shaping Data in a Query with SELECT

00. Introduction.mp4

02:01

01. Anatomy of the Select Statement.mp4

06:44

02. Concatenation.mp4

06:54

03. Cast() & Convert().mp4

07:42

04. Formatting and Calculating Dates.mp4

08:15

05. Formatting Using CASE WHEN.mp4

11:34

06. Summary.mp4

00:42

03. Combining Data From Two or More Tables using JOINS

00. Introduction.mp4

01:24

01. Primary and Foreign Keys.mp4

05:53

02. Inner Join.mp4

05:43

03. Left and Right Joins.mp4

04:36

04. Full Join.mp4

01:43

05. Self Join.mp4

06:26

06. Summary.mp4

00:33

04. Filtering the Results using WHERE

00. Introduction.mp4

01:36

01. Analyzing and Validating using WHERE.mp4

05:32

02. Expressions and Comparison Operators.mp4

06:10

03. Nested Select Statements.mp4

09:00

04. Summary.mp4

00:28

05. Limiting the Results with SQL Functions

00. Introduction.mp4

01:28

01. TOP(n) and TOP(n) PERCENT.mp4

06:37

02. Offset and Fetch.mp4

05:33

03. Using Variables to Limit Results.mp4

04:14

04. Summary.mp4

00:48

06. Using T-SQL Operators

00. Introduction.mp4

01:13

01. Difference Between Joins and Set Operators.mp4

00:48

02. Union All and Set Operator Rules.mp4

06:10

03. Union.mp4

02:49

04. Intersect.mp4

01:46

05. Except.mp4

02:34

06. Summary.mp4

01:04

07. Aggregating Data in a SELECT Query

00. Introduction.mp4

01:49

01. Count.mp4

07:54

02. Sum.mp4

05:52

03. Average.mp4

08:57

04. Min and Max.mp4

03:55

05. Aggregate Summary.mp4

01:01

08. Simplifying Queries with Intermediary Tables

00. Introduction.mp4

01:53

01. Common Table Expressions.mp4

09:56

02. Temporary Tables.mp4

06:45

03. Cursors.mp4

04:35

04. Summary.mp4

00:31

09. Summary

00. Summary.mp4

01:04

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

SQL

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.