Querying Microsoft SQL Server 2022

Focused View

Adam Wilbert

4:28:20

259 View

01 - Introduction

01 - Turn data into information with queries.mp4

00:49

02 - What you should know.mp4

00:53

03 - Download the sample database.mp4

02:51

02 - 1. Introduction to T-SQL Queries

01 - What is Transact SQL.mp4

03:22

02 - The SQL querying environment.mp4

08:06

03 - Return records with SELECT and FROM.mp4

08:45

04 - Filter records with WHERE.mp4

04:42

05 - Sort records with ORDER BY.mp4

02:57

06 - Column aliases.mp4

02:24

07 - Create values with constants and math.mp4

04:22

08 - Challenge Write a SELECT query.mp4

01:15

09 - Solution Write a SELECT query.mp4

04:14

03 - 2. Additional Filter Techniques

01 - Limit results with TOP.mp4

04:39

02 - Remove duplicates with DISTINCT.mp4

02:53

03 - Comparison operators.mp4

03:43

04 - Understand NULL values.mp4

04:42

05 - Match text with LIKE and wildcards.mp4

04:36

06 - Challenge Retrieve matching text strings.mp4

00:49

07 - Solution Retrieve matching text strings.mp4

04:52

04 - 3. Retrieve Records from Multiple Tables

01 - Table joins and relationships.mp4

03:42

02 - Inner joins.mp4

08:08

03 - Left, right, and full outer joins.mp4

04:37

04 - Cross joins.mp4

04:39

05 - Challenge Return data from multiple tables.mp4

01:06

06 - Solution Return data from multiple tables.mp4

06:12

05 - 4. Group Records

01 - Understand record grouping.mp4

02:44

02 - Use GROUP BY and COUNT.mp4

05:06

03 - Aggregate functions.mp4

03:27

04 - Explore data with SUM.mp4

07:13

05 - Filter groups with HAVING.mp4

03:41

06 - Challenge Obtain order summaries.mp4

01:21

07 - Solution Obtain order summaries.mp4

10:34

06 - 5. Manipulate Data with Functions

01 - Use functions in T-SQL.mp4

03:13

02 - String functions.mp4

03:44

03 - Text concatenation.mp4

03:40

04 - Round with mathematical functions.mp4

03:13

05 - Find the GREATEST or LEAST value.mp4

05:05

06 - Work with date functions.mp4

05:56

07 - FORMAT date and times.mp4

03:36

08 - Group dates into buckets.mp4

06:10

09 - Return random records with NEWID.mp4

02:22

10 - Create a series of values.mp4

05:13

11 - The IIF logical function.mp4

03:39

12 - Write a CASE statement.mp4

04:34

13 - Challenge Use functions in a SQL query.mp4

00:49

14 - Solution Use functions in a SQL query.mp4

13:55

07 - 6. Writing SQL Scripts

01 - Change database context with USE.mp4

03:26

02 - Add comments to a script.mp4

03:43

03 - When to use square brackets.mp4

01:43

08 - 7. SQL Subqueries

01 - What is a subquery.mp4

05:14

02 - Use a subquery in a HAVING clause.mp4

06:26

03 - Correlated subqueries.mp4

06:29

04 - PIVOT the result set.mp4

04:20

05 - Challenge Write a query with a subquery.mp4

01:02

06 - Solution Write a query with a subquery.mp4

08:49

09 - 8. Work with Variables

01 - Create and use variables in a query.mp4

04:46

02 - Create a counter for a looping statement.mp4

05:37

03 - Challenge Use variables in a query.mp4

00:43

04 - Solution Use variables in a query.mp4

05:01

10 - 9. Result Set Operators

01 - Combine results with UNION.mp4

03:07

02 - Return distinct rows with EXCEPT.mp4

04:15

03 - Return common rows with INTERSECT.mp4

03:38

11 - Conclusion

01 - Next steps.mp4

01:28

Description

Want to learn more about how to query data from SQL Server tables? In this course, instructor Adam Wilbert covers how to retrieve information stored in a Microsoft SQL Server database using the Transact-SQL (T-SQL) language and the updated features of SQL Server 2022.

Learn the fundamental structure of a successful query, from ideation to execution. Find out how to manipulate data through the use of built-in functions, operators, filters, and other language features to return a data set, ensuring that it’s properly formatted and applicable to a wide variety of needs and perspectives. Along the way, Adam gives you tips and pointers on how to get the most out of your queries. Upon completing this course, you'll be equipped with the commands and keywords you need to know to analyze your data more effectively.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL Server

Adam Wilbert

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.