Overview
-
Discover how to query tables in Microsoft SQL Server 2016. Learn how to use SELECT statements, filter, group, and sort results, and more.
Syllabus
-
Introduction
- Welcome
- What you should know
- Using the exercise files
- A history of SQL and T-SQL
- An introduction to relational theory
- To use standards or not
- Understanding processing stages
- Querying a table with SELECT
- Using aliases in your SELECT statements
- Using string concatenation
- Using CASE expressions
- Filtering duplicates with DISTINCT
- Introducing the WHERE clause
- WHERE clause relational operators
- Filtering text
- Working with NULL
- Understanding normalization
- Understanding table relationships
- Understanding joins
- Using joins in a query
- Understanding order
- Sorting results with ORDER BY
- Grouping results with GROUP BY
- Using the TOP option
- Using aggregates
- Queries using date and time
- Queries using character data types
- Queries using character functions
- Writing subqueries
- Using EXISTS
- Introducing views
- Introducing common table expressions
- Understanding stored procedures
- Understanding T-SQL programming elements
- Implementing transactions
- Error handling
- Introducing query execution plans
- Viewing index usage and statistics
- Next steps
