Querying Microsoft SQL Server 2019

Introduction

• Turn data into information with queries
• What you should know
• Download the sample database

1. Introduction to T-SQL Queries

• What is Transact SQL?
• The SQL querying environment
• Return records with SELECT and FROM
• Filter records with WHERE
• Sort records with ORDER BY
• Column aliases
• Create values with constants

2. Additional Filter Techniques

• Limit results with TOP
• Remove duplicates with DISTINCT
• Comparison operators
• Understand NULL values
• Match text with LIKE and wildcards

3. Retrieve Records from Multiple Tables

• Table joins and relationships
• Inner joins
• Left, right, and full outer joins
• Cross joins

4. Grouping Records

• Understand record grouping
• Use GROUP BY and COUNT
• Aggregate functions
• Explore data with SUM
• Filter groups with HAVING

5. Manipulate Data with Functions

• Use functions in T-SQL
• String functions
• Text concatenation
• Round with mathematical functions
• Work with date functions
• FORMAT date and times
• Return random records with NEWID
• The IIF logical function

6. Writing SQL Scripts

• Change database context with USE
• Add comments to a script
• When to use square brackets

7. SQL Subqueries

• What is a subquery?
• Use a subquery in a WHERE clause
• Correlated subqueries
• PIVOT the result set

8. Work with Variables

• Create and use variables in a query
• Create a counter for a looping statement

9. Result Set Operators

• Combine results with UNION
• Return distinct rows with EXCEPT
• Return common rows with INTERSECT

Conclusion

• Next steps