Overview

This five-day instructor-led 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 and tools related to implementing a database server.

Duration

5 Days

Target Audience

This course is intended for IT Professionals who want to become skilled on SQL Server 2008 R2 product features and technologies for implementing a database. To be successful in this course, the student should have knowledge of basic relational database concepts and writing T-SQL queries.

Topics

Introduction to SQL Server and its Toolset

Working with Data Types

Designing and Implementing Tables

Designing and Implementing Views

Planning for SQL Server Indexing

Implementing Table Structures in SQL Server

Reading SQL Server Execution Plans

Improving Performance through Nonclustered Indexes

Designing and Implementing Stored Procedures

Merging Data and Passing Tables

Creating Highly Concurrent SQL Server Applications

Handling Errors in T-SQL Code

Designing and Implementing User-Defined Functions

Ensuring Data Integrity through Constraints

Responding to Data Manipulation via Triggers

Implementing Managed Code in SQL Server

Storing XML Data in SQL Server

Querying XML Data in SQL Server

Working with SQL Server Spatial Data

Working with Full-Text Indexes and Queries

A more comprehensive course outline is available in the Course Download section, to the right of this page.

MTC serves the whole of the North East region, including, Sunderland, Newcastle, Durham Teesside, Tyne and Wear, Cumbria, Northumberland, Darlington, North Yorkshire, Carlisle, Hartlepool. In addition MTC supports many clients nationally within the UK.