|
|
|
Implementing a Microsoft
SQL Server 2005 Database
Course 2779: Three days; Instructor-Led
Introduction
This three-day instructor-led course
provides students with product knowledge and skills needed to implement a
Microsoft SQL Server 2005 database. The course focuses on teaching individuals
how to use SQL Server 2005 product features and tools related to implementing a
database.
Audience
This course is intended for IT
Professionals wanting to become skilled on SQL Server 2005 product features and
technologies for implementing a database.
Objectives
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 2005.
•
Plan, create, and optimize indexes.
•
Implement data integrity in
Microsoft SQL Server 2005 databases by using constraints, triggers, and XML
schemas.
•
Implement views.
•
Implement stored procedures and functions.
•
Implement managed code in the
database.
•
Use Service Broker to build a
messaging-based solution.
Prerequisites
Before attending this course,
students must have:
•
Basic knowledge of the Microsoft
Windows operating system and its core functionality.
•
Working knowledge of Transact-SQL.
•
Working knowledge of relational
databases.
•
Some experience with database
design.
Course Outline
Module 1: Creating Databases and
Database Files
This module explains how to create
databases, filegroups, schemas, and database snapshots.
Module 2: Creating Data Types and TablesThis module explains how to create data types and tables. It
also describes how to create partitioned tables.
Module 3: Using XML
This module explains how to use the
FOR XML clause and the OPENXML function. It also describes how to use the xml
data type and its methods.
Module 4: Creating and Tuning
Indexes
This module explains how to plan,
create, and optimize indexes. It also describes how to create XML indexes.
Module 5: Implementing Data
Integrity
This module explains how to
implement constraints, triggers, and XML schemas.
Module 6: Implementing Views
This module explains how to create
views.
Module 7: Implementing Stored
Procedures and Functions
This module explains how to create
stored procedures and functions.
Module 8: Implementing Managed Code
in the Database
This module explains how to
implement managed database objects.
Module 9: Using Service Broker
This module explains how to build a
messaging-based solution with Service Broker.