Introduction to SQL Server and its Toolset
o Introduction to SQL Server Platform
o Working with SQL Server Tools
o Configuring SQL Server Services
Working with Data Types
o Using Data Types
o Working with Character Data
o Converting Data Types
o Working with Specialized Data Types
Designing and Implementing Tables
o Designing Tables
o Working with Schemas
o Creating and Altering Tables
Designing and Implementing Views
o Introduction to Views
o Creating and Managing Views
o Performance Considerations for Views
Planning for SQL Server Indexing
o Core Indexing Concepts
o Data Types and Indexes
o Single Column and Composite Indexes
Implementing Table Structures in SQL Server
o SQL Server Table Structures
o Working with Clustered Indexes
o Designing Effective Clustered Indexes
Reading SQL Server Execution Plans
o Execution Plan Core Concepts
o Common Execution Plan Elements
o Working with Execution Plans
Improving Performance through Nonclustered Indexes
o Designing Effective Nonclustered Indexes
o Implementing Nonclustered Indexes
o Using the Database Engine Tuning Advisor
Designing and Implementing Stored Procedures
o Introduction to Stored Procedures
o Working With Stored Procedures
o Implementing Parameterized Stored Procedures
o Controlling Execution Context
Merging Data and Passing Tables
o Using the MERGE Statement
o Implementing Table Types
o Using Table Types as Parameters
Creating Highly Concurrent SQL Server Applications
o Introduction to Transactions
o Introduction to Locks
o Management of Locking
o Transaction Isolation Levels
Handling Errors in T-SQL Code
o Designing T-SQL Error Handling
o Implementing T-SQL Error Handling
o Implementing Structured Exception Handling
Designing and Implementing User-Defined Functions
o Designing and Implementing Scalar Functions
o Designing and Implementing Table-valued Functions
o Implementation Considerations for Functions
o Alternatives To Functions
Ensuring Data Integrity through Constraints
o Enforcing Data Integrity
o Implementing Domain Integrity
o Implementing Entity and Referential Integrity
Responding to Data Manipulation via Triggers
o Designing DML Triggers
o Implementing DML Triggers
o Advanced Trigger Concepts
Implementing Managed Code in SQL Server
o Introduction to SQL CLR Integration
o Importing and Configuring Assemblies
o Implementing SQL CLR Integration
Storing XML Data in SQL Server
o Introduction to XML and XML Schemas
o Storing XML Data and Schemas in SQL Server
o Implementing the XML Data Type
Querying XML Data in SQL Server
o Using the T-SQL FOR XML Statement
o Getting Started with XQuery
o Shredding XML
Working with SQL Server Spatial Data
o Introduction to Spatial Data
o Working with SQL Server Spatial Data Types
o Using Spatial Data in Applications
Working with Full-Text Indexes and Queries
o Introduction to Full-Text Indexing
o Implementing Full-Text Indexes in SQL Server
o Working with Full-Text Queries
