Microsoft SQL Server T-SQL 2012 Training Course

• The Client/Server System
• The Relational Database Model
• SQL and SQL-Based Systems
• Transact-SQL Statements
• Working with Other Database Objects
• Using SQL from an Application Program

The Management Studio

• Managing the Database Files
• Viewing and Modifying The Database
• Working with Queries
• Using Books Online

Retrieving Data From a Single Table

• The SELECT Statement
• The SELECT Clause
• The WHERE Clause
• The ORDER BY Clause

Retrieving Data from Two or More Tables

• Inner Joins
• Outer Joins
• Other Skills for Working with Joins
• Unions

Summary Queries 

• Aggregate Functions
• Grouping and Summarizing Data
• Summarizing Data Using SQL Server Extensions

Subqueries 

• Subqueries in Search Conditions
• Other Ways to Use Subqueries
• Guidelines for Working With Complex Queries
• Common Table Expressions

Inserting, Updating, and Deleting Data

• Creating Test Tables
• Inserting New Rows
• Modifying Existing Rows
• Deleting Existing Rows
• Merging Rows

Working With Data Types 

• SQL Data Types
• Converting Data

Advanced Data Types 

• Introduction
• The HierarchyID Data Type
• Sparse Columns and Column Sets
• FILESTREAM Storage
• Spatial Data

Functions 

• String Data
• Numeric Data
• Date/Time Data
• Other Functions

Views

• Creating and Managing Views
• Using Views
• Using The View Designer

Creating User-Defined Functions 

• User-Defined Function Overview
• Scalar Functions
• Inline Table-Valued Functions
• Multi-Statement Table-Valued Functions
• Using Functions, Views, and Stored Procedures

Complex Querying 

• Working with NULL Values
• Ranking Grouped Data
• Writing Correlated Subqueries
• Using Common Table Expressions

Coding Scripts 

• Variables and Temporary Tables
• Controlling the Execution of a Script
• Advanced Scripting Techniques

Creating Stored Procedures and Triggers

• Creating Stored Procedures
• Creating Triggers

Advanced Query Techniques 

• Full-Text Search
• Advanced T-SQL Techniques
• Executing Dynamic SQL

Transactions and Error Handling

• Transaction Concepts
• Applications and Transactions
• Creating Explicit Transactions
• Using TRY/CATCH Error Handling