This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for implementing a database.
• 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.
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.
Слушателям выдаются учебные материалы, авторизованные Microsoft.
По окончании курса слушатели получают сертификат компании Microsoft международного образца.
Module 1: Creating Databases and Database Files |
 | Creating Databases.
Creating Filegroups.
Creating Schemas.
Creating Database Snapshots.
|
|
Module 2: Creating Data Types and Tables |
| Creating Data Types.
Creating Tables.
Creating Partitioned Tables.
|
|
Module 3: Using XML |
| Retrieving XML by Using FOR XML.
Shredding XML by Using OPENXML.
Introducing XQuery. Using the xml Data Type.
|
|
Module 4: Creating and Tuning Indexes |
| Planning Indexes.
Creating Indexes.
Optimizing Indexes.
Creating XML Indexes.
|
|
Module 5: Implementing Data Integrity by Using Constraints |
| Data Integrity Overview.
Implementing Constraints.
|
|
Module 6: Implementing Data Integrity by Using Triggers and XML Schemas |
| Implementing Triggers. Implementing XML Schemas. |
|
Module 7: Implementing Views |
| Introduction to Views.
Creating and Managing Views.
Optimizing Performance by Using Views.
|
|
Module 8: Implementing Stored Procedures |
| Implementing Stored Procedures.
Creating Parameterized Stored Procedures.
Working With Execution Plans.
Handling Errors.
|
|
Module 9: Implementing Functions |
| Creating and Using Functions. Working with Functions. Controlling Execution Context. |
|
Module 10: Implementing Managed Code in the Database |
| Introduction to the SQL Server Common Language Runtime.
Importing and Configuring Assemblies.
Creating Managed Database Objects.
|
|
Module 11: Managing Transactions and Locks |
| Overview of Transactions and Locks. Managing Transactions. Understanding SQL Server Locking Architecture. Managing Locks. |
|
Module 12: Using Service Broker |
| Service Broker Overview.
Creating Service Broker Objects.
Sending and Receiving Messages.
|
|
Module 13: Using Notification Services (Optional) |
| Introduction to Notification Services. Developing Notification Services Solutions. |
|
