Querying Microsoft SQL Server 2019

Course details

Discover how to query data from SQL Server tables. In this course, Adam Wilbert covers how to retrieve information stored in a Microsoft SQL Server database using the Transact-SQL (T-SQL) language. Learn the fundamental structure of a query and see how to manipulate data through the use of built-in functions, operators, filters, and other language features to return a dataset that's formatted to meet a wide variety of needs and perspectives. Upon wrapping up this course, you'll be equipped with the commands and keywords you need to know to effectively analyze your data.

Learning objectives
Writing SELECT queries
Removing duplicates with DISTINCT
Matching text with LIKE and wildcards
Retrieving records from multiple tables
Grouping records
Using functions in T-SQL
Writing SQL scripts
Using subqueries
Creating and using variables in a query

Concepts

0. Introduction

01 - Turn data into information with queries
02 - What you should know
03 - Download the sample database

1. Introduction to T-SQL Queries

04 - What is Transact SQL
05 - The SQL querying environment
06 - Return records with SELECT and FROM
07 - Filter records with WHERE
08 - Sort records with ORDER BY
09 - Column aliases
10 - Create values with constants

2. Additional Filter Techniques

11 - Limit results with TOP
12 - Remove duplicates with DISTINCT
13 - Comparison operators
14 - Understand NULL values
15 - Match text with LIKE and wildcards

3. Retrieve Records from Multiple Tables

16 - Table joins and relationships
17 - Inner joins
18 - Left, right, and full outer joins
19 - Cross joins

4. Grouping Records

20 - Understand record grouping
21 - Use GROUP BY and COUNT
22 - Aggregate functions
23 - Explore data with SUM
24 - Filter groups with HAVING

5. Manipulate Data with Functions

25 - Use functions in T-SQL
26 - String functions
27 - Text concatenation
28 - Round with mathematical functions
29 - Work with date functions
30 - FORMAT date and times
31 - Return random records with NEWID
32 - The IIF logical function

6. Writing SQL Scripts

33 - Change database context with USE
34 - Add comments to a script
35 - When to use square brackets

7. SQL Subqueries

36 - What is a subquery
37 - Use a subquery in a WHERE clause
38 - Correlated subqueries
39 - PIVOT the result set

8. Work with Variables

40 - Create and use variables in a query
41 - Create a counter for a looping statement

9. Result Set Operators

42 - Combine results with UNION
43 - Return distinct rows with EXCEPT
44 - Return common rows with INTERSECT

Conclusion

45 - Next steps