Microsoft Course 6232 - Implementing a Microsoft SQL Server 2008 Database — A 5 day course

contact usEnquire about this course

Synopsis

The Microsoft M6232 course is intended for Microsoft SQL Server database developers who are responsible for implementing a database on SQL Server 2008 R2.

In the Microsoft M6232 course, candidates learn the skills and best practices on how to use SQL Server 2008 R2 product features and tools related to implementing a database server.

Objectives

Contents

Introduction to SQL Server and its Toolset

This module introduces you to the entire SQL Server platform and its major tools. This module also covers editions, versions, basics of network listeners, and concepts of services and service accounts.

Working with Data Types

Designing and Implementing Tables

This module describes the design and implementation of tables.

Designing and Implementing Views

This module describes the design and implementation of views.

Planning for SQL Server Indexing

This module describes the concept of an index and discusses selectivity, density, and statistics. It covers appropriate data type choices and choices around composite index .structures.

Implementing Table Structures in SQL Server

This module covers clustered indexes and heaps.

Reading SQL Server Execution Plans

This module introduces the concept of reading execution plans.

Improving Performance through Nonclustered Indexes

This module explains nonclustered indexes, covering indexes and included columns.

Designing and Implementing Stored Procedures

This module describes the design and implementation of stored procedures.

Merging Data and Passing Tables

This module covers table types, table valued parameters and the MERGE statement as used in stored procedures.

Creating Highly Concurrent SQL Server Applications

This module covers transactions, isolation levels, and designing for concurrency.

Handling Errors in T-SQL Code

This module describes structured exception handling and gives solid examples of its use within the design of stored procedures.

Designing and Implementing User-Defined Functions

This module describes the design and implementation of functions, both scalar and table-valued.

Ensuring Data Integrity through Constraints

This module describes the design and implementation of constraints.

Responding to Data Manipulation via Triggers

This module describes the design and implementation of triggers.

Implementing Managed Code in SQL Server

This module describes the implementation of and target use-cases for SQL CLR integration.

Storing XML Data in SQL Server

This module covers the XML data type, schema collections, typed and untyped columns and appropriate use cases for XML in SQL Server.

Querying XML Data in SQL Server

This module covers the basics of FOR XML and XPath Queries.

Working with SQL Server Spatial Data

This module describes spatial data and how this data can be implemented within SQL Server.

Working with Full-Text Indexes and Queries

This module covers full text indexes and queries.

Publicly scheduled dates, locations, and prices

A schedule of dates for this subject is not currently available. Please call 0333 210 0140 or use our contact form to enquire about places and availability.

Suitable For

The Microsoft MS6232 course is intended for IT Professionals who administer and maintain SQL Server databases.

Follow-On Courses

M6234 - Implementing and Maintaining Microsoft SQL Server 2008 Analysis Service

M6235 - Implementing and Maintaining Microsoft SQL Server 2008 Integration Services

M6236 - Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services

Related Course

M6231 - Maintaining a Microsoft SQL Server 2008 R2 Database

Prerequisites

Basic knowledge of the Microsoft Windows Server operating system and its core functionality.

Working knowledge of Transact-SQL (ability to write Transact-SQL queries) or attendance on M2778 - Writing Queries Using Microsoft SQL Server 2008 Transact-SQL course.

Working knowledge of relational databases.

Some experience with database design.

Basic programming language.

Examination

The Microsoft 6232 course helps candidates prepare for Exam 70-433.

When you pass Exam 70-433: TS: Microsoft SQL Server 2008, Database Development, you complete the requirements for the following certification(s):

Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development.