Implementing a Microsoft SQL Server 2005 Database
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.
At Course Completion
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
- 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.
Lessons
• Creating Databases.
• Creating Filegroups.
• Creating Schemas.
• Creating Database Snapshots.
Module 2:
Creating Data Types and Tables
This module explains how to create data types and tables. It also describes how to create partitioned tables.
Lessons
• Creating Data Types.
• Creating Tables.
• Creating 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.
Lessons
• Retrieving XML by Using FOR XML.
• Shredding XML by Using OPENXML.
• Using the xml Data Type.
Module 4: Creating and Tuning Indexes
This module explains how to plan, create, and optimize indexes. It also describes how to create XML indexes.
Lessons
Planning Indexes
• Creating Indexes
• Optimizing Indexes
• Creating XML Indexes
Module 5: Implementing Data Integrity
This module explains how to implement constraints, triggers, and XML schemas.
Lessons
• Data Integrity Overview.
• Implementing Constraints.
• Implementing Triggers.
• Implementing XML Schemas.
Module 6: Implementing Views
This module explains how to create views.
Lessons
• Introduction to Views.
• Creating and Managing Views.
• Optimizing Performance by Using Views.
Module 7: Implementing Stored Procedures and Functions
This module explains how to create stored procedures and functions.
Lessons
• Implementing Stored Procedures.
• Creating Parameterized Stored Procedures.
• Creating Functions.
• Handling Errors.
• Controlling Execution Context.
• Create Table Valued Functions.
• Control Execution Context.
Module 8: Implementing Managed Code in the Database
This module explains how to implement managed database objects.
Lessons
• Introduction to the SQL Server Common Language Runtime.
• Importing and Configuring Assemblies.
• Creating Managed Database Objects.
Module 9: Using Service Broker
This module explains how to build a messaging-based solution with Service Broker.
Lessons
• Service Broker Overview.
• Creating Service Broker Objects.
• Sending and Receiving Messages.
Return to Database Development
and Administration
Training Courses
|
