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