Introduction to SQL Server Management Studio

• Objects in a SQL Server Database
• Database Diagrams
• Components of a SQL Server Database Table
• Native SQL Server Data Types

Introduction to SQL and Transact-SQL (T-SQL)

• Categories of SQL Statements
• T-SQL Scripts
• Adding Comments to T-SQL Code
• Working with Variables
• Conditional Statements

Using the SELECT Statement to Retrieve Data

• Examine the Basic Syntax of the SELECT Statement
• Retrieving Columns of Data from a Table
• Using Aliases for Column Names
• Using Aliases for Table Names

Retrieving Specific Rows of Data Using the WHERE Clause

• How to Use the WHERE Clause
• Overview of Operators
• Filter Data by Using Comparison Operators
• Filter Data by Using String Comparisons
• Filter Data by Using Logical Operators
• Filter Data Using a Range of Values
• Filter Data Using a List of Values
• Working with NULL Values
• Introducing Native SQL Server Functions
• Functions Relating to NULL Values

Formatting and Sorting Result Sets

• Sorting Data Using the ORDER BY Clause
• Eliminating Duplicate Rows
• Using String Literals
• Using Expressions

Querying Data from Multiple Tables by Using Joins

• Introduction to Joins
• Using Inner Joins
• Using Outer Joins
• Joining More than Two Tables
• Joining a Table to Itself (Self Join)

Summarizing Data Using Aggregate Functions

• Using Aggregate Functions Native to SQL Server
• Using Aggregate Functions with NULL Values
• Grouping Summarized Data with GROUP BY
• Filtering Grouped Data Using the HAVING Clause

Ranking Grouped Data

• Ranking Data Using Ranking Functions
• Using ROW_NUMBER
• Using RANK
• Using DENSE_RANK
• Using NTILE
• Summary of Ranking Functions Based on Their Functionality

Combining and Limiting Result Sets

• Combining Result Sets Using the UNION Operator
• Limiting Result Sets Using the TOP Operator

Working with Subqueries

• Introduction to Subqueries
• Using Subqueries as Expressions and Derived Tables
• Using Correlated Subqueries
• Using the EXISTS Clause with Correlated Subqueries

Performance Considerations for Writing Queries

• How SQL Server Processes Queries
• How the Query Optimizer Processes Search Arguments
• Writing Efficient Search Arguments

Working with SQL Server Date and Time Data

• Data Type Precedence
• Implicit and Explicit Data Type Conversion
• Querying Date and Time Data

Implementing Stored Procedures

• Overview of Stored Procedures
• How Stored Procedures Are Executed by SQL Server
• Creating and Using a Stored Procedure
• Parameterizing Stored Procedures

Implementing User Defined Functions

• Overview of User Defined Functions (UDFs)
• Creating and Modifying UDFs
• Restrictions When Creating UDFs
• Implementing Different Types of UDFs