Scheda corso MOC6232

Implementing a Microsoft SQL Server 2008 Database

This 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.

Obiettivi

After completing 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.

• Implement data integrity in Microsoft SQL Server 2008 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.

Prerequisiti

Contenuti

Module 1: Creating Databases and Database Files

• Lesson 1: Creating Databases

• Lesson 2: Creating Filegroups

• Lesson 3: Creating Schemas

• Lesson 4: Creating Database Snapshots

Module 2: Creating Data Types and Tables

• Lesson 1: Creating Data Types

• Lesson 2: Creating Tables

• Lesson 3: Creating Partitioned Tables

Module 3: Creating and Tuning Indexes

• Lesson 1: Planning Indexes

• Lesson 2: Creating Indexes

• Lesson 3: Optimizing Indexes

Module 4: Implementing Data Integrity by Using Constraints and Triggers

• Lesson 1: Data Integrity Overview

• Lesson 2: Implementing Constraints

• Lesson 3: Implementing Triggers

Module 5: Using XML

• Lesson 1: Using the XML Data Type

• Lesson 2: Retrieving XML by Using FOR XML

• Lesson 3: Shredding XML by Using OPENXML

• Lesson 4: Introducing XQuery

• Lesson 5: Creating XML Indexes

• Lesson 6: Implementing XML Schemas

Module 6: Implementing Views

• Lesson 1: Introduction to Views

• Lesson 2: Creating and Managing Views

• Lesson 3: Optimizing Performance by Using Views

Module 7: Implementing Stored Procedures

• Lesson 1: Implementing Stored Procedures

• Lesson 2: Creating Parameterized Stored Procedures

• Lesson 3: Working With Execution Plans

• Lesson 4: Handling Errors

Module 8: Implementing Functions

• Lesson 1: Creating and Using Functions

• Lesson 2: Working with Functions

• Lesson 3: Controlling Execution Context

Module 9: Implementing Managed Code in the Database

• Lesson 1: Introduction to the SQL Server Common Language Runtime

• Lesson 2: Importing and Configuring Assemblies

• Lesson 3: Creating Managed Database Objects

Module 10: Managing Transactions and Locks

• Lesson 1: Overview of Transactions and Locks

• Lesson 2: Managing Transactions

• Lesson 3: Understanding SQL Server Locking Architecture

• Lesson 4: Managing Locks

Module 11: Using Service Broker

• Lesson 1: Service Broker Overview

• Lesson 2: Creating Service Broker Objects

• Lesson 3: Sending and Receiving Messages