Site map · Advanced search

Offer of courses » Databases » Microsoft SQL Server » Microsoft SQL Server 2008 » Implementing a Microsoft SQL Server 2008 Database

Basic Informations

Courses offering

How to book our courses

MOC 6232 - Implementing a Microsoft SQL Server 2008 Database

This five-day instructor-led course provides students with the knowledge and skills to implement a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to implementing a database.

Who the course is for

This course is intended for IT Professionals who implement and program SQL Server databases.

What we teach you

Create databases and database files.

Create data types and tables.

Use XML–related features in Microsoft SQL Server 2008.

Plan, create, and optimize indexes.

Implement data integrity in Microsoft SQL Server 2008 databases by using constraints.

Implement data integrity in Microsoft SQL Server 2008 databases by using triggers.

Implement views.

Implement stored procedures.

Implement functions.

Implement managed code in the database.

Manage transactions and locks.

Use Service Broker to build a messaging–based solution.

Required skills

SQL Server skills – ability to write Transact–SQL queries or completed Course 2778: Writing Queries Using Microsoft SQL Server 2008 Transact–SQL.

Teaching methods

Expert instruction with practical examples, computer practice

Course syllabus

Creating Databases and Database Files

Creating Databases
Creating Filegroups
Creating Schemas
Creating Database Snapshots

Creating Data Types and Tables

Creating Data Types
Creating Tables
Creating Partitioned Tables

Creating and Tuning Indexes

Planning Indexes
Creating Indexes
Optimizing Indexes

Implementing Data Integrity by Using Constraints and Triggers

Data Integrity Overview
Implementing Constraints
Implementing Triggers

Using XML

Using the XML Data Type
Retrieving XML by Using FOR XML
Shredding XML by Using OPENXML
Introducing XQuery
Creating XML Indexes
Implementing XML Schemas

Implementing Views

Introduction to Views
Creating and Managing Views
Optimizing Performance by Using Views

Implementing Stored Procedures

Using Stored Procedures
Creating Parameterized Stored Procedures
Working With Execution Plans
Handling Exceptions

Implementing Functions

Introducing Functions
Working with Functions
Controlling Execution Context

Implementing Managed Code in the Database

Introduction to the SQL Server Common Language Runtime
Importing and Configuring Assemblies
Creating Managed Database Objects

Managing Transactions and Locks

Overview of Transactions and Locks
Managing Transactions
Understanding SQL Server Locking Architecture
Managing Locks

Using Service Broker

Service Broker Overview
Creating Service Broker Objects
Sending and Receiving Messages

Recommended prior courses

MOC 2778 - Writing Queries Using Microsoft SQL Server 2008 Transact–SQL

Catalog price of course and handbook

Locality Course price ex VAT Price of handbook ex VAT Number IT points

Praha 19500 Kč 6800 Kč 50 items

Brno 19000 Kč 6800 Kč 50 items

Course dates

Course date	Course length	Locality	Price ex VAT	Handbook ex VAT
20.09.2010	5	GOPAS Praha	19500 Kč	6800 Kč
01.11.2010	5	GOPAS Praha	19500 Kč	6800 Kč
13.12.2010	5	GOPAS Praha	19500 Kč	6800 Kč
21.03.2011	5	GOPAS Praha	19500 Kč	6800 Kč
11.10.2010	5	GOPAS Brno	19000 Kč	6800 Kč
29.11.2010	5	GOPAS Brno	19000 Kč	6800 Kč
07.03.2011	5	GOPAS Brno	19000 Kč	6800 Kč
29.11.2010	5	GOPAS Bratislava	650 EUR	262 EUR
21.02.2011	5	GOPAS Bratislava	650 EUR	262 EUR
07.03.2011	5	GOPAS Bratislava	650 EUR	262 EUR

If none of the offered dates suits you, please contact our customer service department on tel. +420 234 064 900-3 (Prague), +420 542 219 935-6 (Brno).