Querying Data Using T-SQL

Focused View

Ami Levin

2:06:45

22 View

00. Course Overview

00. Course Overview.mp4

02:37

01. What Is T-SQL -

00. Module Introduction.mp4

00:28

01. What Is T-SQL - .mp4

04:10

02. A Little SQL Server Architecture.mp4

05:22

03. Tools.mp4

02:21

04. Demo - Tools.mp4

03:29

05. Module Review.mp4

01:31

02. Our First SELECT

00. Module Introduction.mp4

00:34

01. What Is a SQL Query - .mp4

03:01

02. More Terminology.mp4

04:59

03. Demo - First SELECT.mp4

05:20

04. Module Review.mp4

00:53

03. The FROM Clause

00. Module Introduction.mp4

00:24

01. TSQL Demo Database.mp4

04:35

02. Demo - FROM Single Table.mp4

03:13

03. Introduction to Multiple Tables in FROM.mp4

04:49

04. Demo - Multiple Tables.mp4

04:58

05. Module Review.mp4

01:11

04. Filtering with WHERE

00. Module Introduction.mp4

00:31

01. Understanding NULLs.mp4

02:21

02. 3VL (Ternary) Logic.mp4

04:33

03. Logical Predicates and Operators.mp4

05:40

04. Filtering with WHERE.mp4

04:59

05. Module Review.mp4

01:05

05. Grouping Rows

00. Module Introduction.mp4

00:30

01. What Is Grouping Good For - .mp4

03:52

02. Grouping Rows.mp4

06:02

03. Group Filtering with HAVING.mp4

02:25

04. Module Review.mp4

02:13

06. Evaluating SELECT Expressions

00. Module Introduction.mp4

00:29

01. Evaluating SELECT Expressions.mp4

03:59

02. Dealing with NULLs.mp4

01:51

03. Using DISTINCT.mp4

03:10

04. Module Review.mp4

00:45

07. Ordering and Paging

00. Module Introduction.mp4

00:38

01. Law of Order.mp4

03:06

02. ORDER BY.mp4

01:54

03. Determinism and Tiebreakers.mp4

01:43

04. Paging Result Sets.mp4

02:49

05. Demo - Ordering and Paging.mp4

06:20

06. Module Review.mp4

02:10

08. Wrapping Up

00. Module Introduction.mp4

00:29

01. Course Review.mp4

03:04

02. Takeaway.mp4

02:01

03. Feedback.mp4

00:54

04. Next Steps.mp4

01:37

05. Additional Resources and Conclusion.mp4

01:40

Description

Whether you are just starting with SQL Server, or an experienced SQL developer looking to make a switch to T-SQL, this course will provide solid foundations and essential understanding of how SQL\T-SQL work, to query data and troubleshoot effectively.

What You'll Learn?

SQL can seem simple enough to the unsuspecting eye, but without a solid grasp on its core concepts, you can quickly get lost. In this course, Querying Data Using T-SQL, you will gain the ability to query data with T-SQL. More importantly, you will understand exactly how the database processes your queries. This will allow you to write elegant queries, troubleshoot code effectively, and save you months of frustration as you advance on your SQL path. First, you will learn what SQL and T-SQL are, where they came from, and where they are heading. Next, you will discover query execution processing and how everything in SQL revolves around it. Finally, you will explore how to use every clause of the SELECT query, and you will be able to quickly query data yourself, understand exactly how your queries work, and therefore be able to troubleshoot and optimize them. When you’re finished with this course, you will have the skills and knowledge to query data effectively in T-SQL and feel right at home with it!

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

Ami Levin

Instructor's Courses

Ami has been teaching, consulting, and mentoring data professionals for over 20 years. Ami's broad theoretical knowledge in data management is complemented by extensive hands-on experience working as a data tier architect, performance tuning expert, and a SQL developer, while at the same time directing and teaching others how to get the most value from their data. Ami owns a US patent for an automatic solution for optimizing database performance. Ami has been highly involved in the SQL community, leading the Silicon Valley Microsoft Data Platform User Group, speaking at user groups, conferences, online events, and is a contributor to online forums. He was honored by the Microsoft MVP award for 11 years. In his free time, Ami likes to take care of his 4 rescue cats, listen to music on his audiophile stereo system, and volunteer at animal shelters. Naturally, Ami is also a strict vegetarian. He loves riding his motorcycle on long trips across the country.

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.