What is SQL?
What is SQL? What is the difference between SQL the language and SQL the server?
SQL Server
Writing a SELECT statement
What are the basics in writing a T-SQL SELECT? How to return columns and records from a table in SQL Server.
Sort Records using ORDER BY
How to use the ORDER BY statement to sort records in a T-SQL statement in both ascending and descending order.
Filtering Records by Numbers
How to use the WHERE statement to filter records when the value is a number or integer data type in a T-SQL statement.
Query Optimizer Phases
The SQL Server Query Optimizer uses cost-based optimization to create an execution plan with the least cost.
Opportunities for Query Optimization
Optimize your SQL Server queries for maximum performance. Learn how to troubleshoot query plans and identify optimization opportunities.
Task Execution Model
How the SQLOS manages worker threads in the SQL Server Execution Model and the different wait queues in SQL Server to manage threads used by the CPU.
Transactions and Errors
SQL Transaction and Error Handling? What is the difference between Auto-Commit and Explicit Transactions and how transaction affect Errors and Exception Handling?
Table Constraints
Restricting data by using Table Constraints in SQL Server. What are the different table constraints in SQL Server?
What is a Schema?
The term schema could mean several different things. What are the different meanings and how are schemas are used in SQL Server.