Five Day Course

Course Description

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.

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

• 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.
• Plan, create, and optimize indexes.
• 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.

Prerequisites

This course is intended for IT Professionals who administer and maintain SQL Server databases.

Course Content

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
• Obtain Connections to a Database
• Sending and Receiving Messages

For more information on Acumen Classes
Please contact Deb Wagnon 314.333.3330
or This e-mail address is being protected from spambots. You need JavaScript enabled to view it

1750 South Brentwood Blvd.
Suite 200
Saint Louis, MO 63119