This 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. Who Should Attend:
This course is intended for IT Professionals who want 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. - Implement data integrity in Microsoft SQL Server 2005 by using triggers. - Implement views. - Implement stored procedures. - Implement functions. - Implement managed code in the database. - Manage transactions and locks. - Use Service Broker to build a messaging-based solution. - Use Notification Services to generate and send notifications. |
Prerequisite(s) or equivalent knowledge: |
| 50027 Querying and Processing SQL Server Data with SQL Statements |
| |
| Outline: | |
| Lesson 1: Creating Databases and Database Files |
Creating Databases.
Creating Filegroups.
Creating Schemas.
Creating Database Snapshots. | |
| Lesson 2: Creating Data Types and Tables |
Creating Data Types.
Creating Tables.
Creating Partitioned Tables. |
| Lesson 3: Using XML |
Retrieving XML by Using FOR XML
Shredding XML by Using OPENXML
Introducing XQuery
Using the xml Data Type |
| Lesson 4: Creating and Tuning Indexes |
Planning Indexes.
Creating Indexes.
Optimizing Indexes.
Creating XML Indexes. |
| Lesson 5: Implementing Data Integrity by Using Constraints |
Data Integrity Overview
Implementing Constraints | |
| Lesson 6: Implementing Data Integrity by Using Triggers and XML Schemas |
Implementing Triggers
Implementing XML Schemas |
| Lesson 7: Implementing Views |
Introduction to Views
Creating and Managing Views
Optimizing Performance by Using Views |
| Lesson 8: Implementing Stored Procedures |
Implementing Stored Procedures
Creating Parameterized Stored Procedures
Working With Execution Plans
Handling Errors |
| Lesson 9: Implementing Functions |
Creating and Using Functions
Working with Functions
Controlling Execution Context | |
| Lesson 10: Implementing Managed Code in the Database |
Introduction to the SQL Server Common Language Runtime
Importing and Configuring Assemblies
Creating Managed Database Objects |
| Lesson 11: Managing Transactions and Locks |
Overview of Transactions and Locks
Managing Transactions
Understanding SQL Server Locking Architecture
Managing Locks |
| Lesson 12: Using Service Broker |
Service Broker Overview
Creating Service Broker Objects
Sending and Receiving Messages |
| Lesson 13: Using Notification Services (Optional) |
Introduction to Notification Services
Developing Notification Services Solutions |
Add to favorites
Email this page
On-Site Training
Seminar
