Introduction
Welcome
()
What you should know before viewing this course
()
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
()
Understand processing stages
()
2. Query the Database
Query a table with SELECT
()
Using aliases in your SELECT statement
()
Using string concatenation
()
Using CASE expressions
()
3. Filtering Results
Filter duplicates with DISTINCT
()
Introducing the WHERE clause
()
WHERE clause relational operators
()
Filtering text
()
Working with NULL
()
4. Query 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
()
Implement transactions
()
Handling errors
()
9. Query Performance
Introducing query execution plans
()
Interpret performance data
()
Ex_Files_QueryingSQL2012.zip
(21 KB)