MS 2779B Implementing SQL Server 2005 Database
**Please note that CompuWorks will only accept students registering through a company or organization. Please click here for more information**
Description: This five-day instructor-led course provides students with the knowledge and skills 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.
Days: 5
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.
In addition, it is recommended, but not required, that students have completed:
• Course 2778: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL.
• Course 2780: Maintaining a Microsoft SQL Server 2005 Database.
Audience: This course is intended for IT Professionals who want to become skilled on SQL Server 2005 product features and technologies for implementing a database.
Module 1: Overview of Exchange and Active Directory
After completing this module, students will be able to describe how Exchange Server 2007 and Active Directory work together.
Lessons
· Introduction to the Exchange Server 2007 Server Roles
· Installing Exchange Server 2007
· Completing the Exchange Server 2007 Installation
Lab: Overview of How Exchange Server 2007 and Active Directory Work Together
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
Lab 1: Creating Databases and Database Files
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
Lab 2: Creating Data Types and 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
· Introducing XQuery
· Using the xml Data Type
Lab 3: Using XML
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
Lab 4: Creating and Tuning Indexes
Module 5: Implementing Data Integrity by Using Constraints
This module explains how to implement constraints and provides an overview of data integrity.
Lessons
· Data Integrity Overview
· Implementing Constraints
Lab 5: Implementing Data Integrity by Using Constraints
Module 6: Implementing Data Integrity by Using Triggers and XML Schemas
This module explains how to implement triggers and XML schemas.
Lessons
· Implementing Triggers
· Implementing XML Schemas
Lab 6: Implementing Data Integrity by Using Triggers and XML Schemas
Module 7: Implementing Views
This module explains how to create views.
Lessons
· Introduction to Views
· Creating and Managing Views
· Optimizing Performance by Using Views
Lab 7: Implementing Views
Module 8: Implementing Stored Procedures
This module explains how to create stored procedures and functions. It also describes execution plans, plan caching, and query compilation.
Lessons
· Implementing Stored Procedures
· Creating Parameterized Stored Procedures
· Working With Execution Plans
· Handling Errors
Lab 8: Implementing Stored Procedures
Module 9: Implementing Functions
This module explains how to create functions. It also describes how to control the execution context.
Lessons
· Creating and Using Functions
· Working with Functions
· Controlling Execution Context
Lab 9: Implementing Functions
Module 10: 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
Lab 10: Implementing Managed Code in the Database
Module 11: Managing Transactions and Locks
This module explains how to use transactions and the SQL Server locking mechanisms to meet the performance and data integrity requirements of your applications.
Lessons
· Overview of Transactions and Locks
· Managing Transactions
· Understanding SQL Server Locking Architecture
· Managing Locks
Lab 11: Managing Transactions and Locks
Module 12: 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
Lab 12: Using Service Broker (Optional)
Module 13: Using Notification Services (Optional)
This module explains how to develop applications that generate and send timely messages to subscribers.
Lessons
· Introduction to Notification Services
· Developing Notification Services Solutions
Price: $2,249
Group Rate:$10,995
(Up to 12)
Group Rate:
(Up to 12)
