Querying Microsoft SQL Server 2012

Learn how to query data from SQL Server tables.

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

Conclusion

• Goodbye