Overview
-
Learn how to query data from SQL Server tables.
Syllabus
-
Introduction
- Welcome
- What you should know before viewing this course
- Using the exercise files
- A history of SQL and T-SQL
- An introduction to relational theory
- To use standards or not
- Understand processing stages
- Query a table with SELECT
- Using aliases in your SELECT statement
- Using string concatenation
- Using CASE expressions
- Filter 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
- Implement transactions
- Handling errors
- Introducing query execution plans
- Interpret performance data
- Goodbye
