6232 Implementing a Microsoft SQL Server 2008 R2 Database

This course is intended for Microsoft SQL Server database developers who are responsible for implementing a database on SQL Server 2008 R2. In this course, students learn the skills and best practices on how to use SQL Server 2008 R2 product features.

Lesson 1: Introduction to SQL Server and its Toolset

• Introduction to SQL Server Platform
• Working with SQL Server Tools
• Configuring SQL Server Services
• Lab : Introduction to SQL Server and its Toolset

Lesson 2: Working with Data Types

• Using Data Types
• Working with Character Data
• Converting Data Types
• Working with Specialized Data Types
• Lab : Working with Data Types

Lesson 3: Designing and Implementing Tables

• Designing Tables
• Working with Schemas
• Creating and Altering Tables
• Lab : Designing and Implementing Tables

Lesson 4: Designing and Implementing Views

• Introduction to Views
• Creating and Managing Views
• Performance Considerations for Views
• Lab : Designing and Implementing Views

Lesson 5: Planning for SQL Server Indexing

• Core Indexing Concepts
• Data Types and Indexes
• Single Column and Composite Indexes
• Lab : Planning for SQL Server Indexing

Lesson 6: Implementing Table Structures in SQL Server

• SQL Server Table Structures
• Working with Clustered Indexes
• Designing Effective Clustered Indexes
• Lab : Implementing Table Structures in SQL Server

Lesson 7: Reading SQL Server Execution Plans

• Execution Plan Core Concepts
• Common Execution Plan Elements
• Working with Execution Plans
• Lab : Reading SQL Server Execution Plans

Lesson 8: Improving Performance through Nonclustered Indexes

• Designing Effective Nonclustered Indexes
• Implementing Nonclustered Indexes
• Using the Database Engine Tuning Advisor
• Lab : Improving Performance through Nonclustered Indexes

Lesson 9: Designing and Implementing Stored Procedures

• Introduction to Stored Procedures
• Working With Stored Procedures
• Implementing Parameterized Stored Procedures
• Controlling Execution Context
• Lab : Designing and Implementing Stored Procedures

Lesson 10: Merging Data and Passing Tables

• Using the MERGE Statement
• Implementing Table Types
• Using Table Types as Parameters
• Lab : Merging Data and Passing Tables

Lesson 11: Creating Highly Concurrent SQL Server Applications

• Introduction to Transactions
• Introduction to Locks
• Management of Locking
• Transaction Isolation Levels
• Lab : Creating Highly Concurrent SQL Server Applications

Lesson 12: Handling Errors in T-SQL Code

• Designing T-SQL Error Handling
• Implementing T-SQL Error Handling
• Implementing Structured Exception Handling
• Lab : Handling Errors in T-SQL Code

Lesson 13: Designing and Implementing User-Defined Functions

• Designing and Implementing Scalar Functions
• Designing and Implementing Table-valued Functions
• Implementation Considerations for Functions
• Alternatives To Functions
• Lab : Designing and Implementing User-Defined Functions

Lesson 14: Ensuring Data Integrity through Constraints

• Enforcing Data Integrity
• Implementing Domain Integrity
• Implementing Entity and Referential Integrity
• Lab : Ensuring Data Integrity through Constraints

Lesson 15: Responding to Data Manipulation via Triggers

• Designing DML Triggers
• Implementing DML Triggers
• Advanced Trigger Concepts
• Lab : Responding to Data Manipulation via Triggers

Lesson 16: Implementing Managed Code in SQL Server

• Introduction to SQL CLR Integration
• Importing and Configuring Assemblies
• Implementing SQL CLR Integration
• Lab : Implementing Managed Code in SQL Server

Lesson 17: Storing XML Data in SQL Server

• Introduction to XML and XML Schemas
• Storing XML Data and Schemas in SQL Server
• Implementing the XML Data Type
• Lab : Storing XML Data in SQL Server

Lesson 18: Querying XML Data in SQL Server

• Using the T-SQL FOR XML Statement
• Getting Started with XQuery
• Shredding XML
• Lab : Querying XML Data in SQL Server

Lesson 19: Working with SQL Server Spatial Data

• Introduction to Spatial Data
• Working with SQL Server Spatial Data Types
• Using Spatial Data in Applications
• Lab : Working with SQL Server Spatial Data

Lesson 20: Working with Full-Text Indexes and Queries

• Introduction to Full-Text Indexing
• Implementing Full-Text Indexes in SQL Server
• Working with Full-Text Queries
• Lab : Working with Full-Text Indexes and Queries

• Chattanooga, TN - April 23, 2012
• Greensboro, NC - April 23, 2012
• Mechanicsburg, PA - April 23, 2012
• West Valley City, UT - April 23, 2012
• Houston, TX - May 7, 2012
• Carmel, IN - May 7, 2012
• Culver City, CA - May 14, 2012
• Las Vegas, NV - May 14, 2012
• Sacramento, CA - May 14, 2012
• Reno, NV - May 14, 2012
• Charleston, SC - May 21, 2012
• Columbia, SC - May 21, 2012
• Greenville, SC - May 21, 2012
• Greensboro, NC - May 21, 2012
• Charleston, WV - May 21, 2012
• Mechanicsburg, PA - May 21, 2012
• Orlando, FL - June 4, 2012
• Tampa, FL - June 11, 2012
• Garfield Heights, OH - June 11, 2012
• Urbandale, IA - June 11, 2012
• Charleston, SC - June 25, 2012
• Columbia, SC - June 25, 2012
• Greenville, SC - June 25, 2012
• Las Vegas, NV - June 25, 2012
• Charleston, WV - June 25, 2012
• Sacramento, CA - June 25, 2012
• Reno, NV - June 25, 2012
• Burbank, CA - July 9, 2012
• Urbandale, IA - July 16, 2012
• Charleston, SC - July 23, 2012