Microsoft SQL Server 2016: Query Data

Introduction

• Welcome
• What you should know
• Using the exercise files

1. SQL Query Fundamentals

• A history of SQL and T-SQL
• An introduction to relational theory
• To use standards or not
• Understanding processing stages

2. Query the Database

• Querying a table with SELECT
• Using aliases in your SELECT statements
• Using string concatenation
• Using CASE expressions

3. Filtering Results

• Filtering duplicates with DISTINCT
• Introducing the WHERE clause
• WHERE clause relational operators
• Filtering text
• Working with NULL

4. Querying Multiple Tables

• Understanding normalization
• Understanding table relationships
• Understanding joins
• Using joins in a query

5. Grouping and Sorting

• Understanding order
• Sorting results with ORDER BY
• Grouping results with GROUP BY
• Using the TOP option
• Using aggregates

6. Querying with Data Type Considerations

• Queries using date and time
• Queries using character data types
• Queries using character functions

7. Subqueries and Table Expressions

• Writing subqueries
• Using EXISTS
• Introducing views
• Introducing common table expressions

8. Programming with T-SQL

• Understanding stored procedures
• Understanding T-SQL programming elements
• Implementing transactions
• Error handling

9. Query Performance

• Introducing query execution plans
• Viewing index usage and statistics

Conclusion

• Next steps