Hours: 40
Short Description
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.
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.
Course Outline
|
Lesson 1: Creating Databases and Database FilesCreating
Databases.
Creating Filegroups.
Creating Schemas.
Creating
Database Snapshots.
Lesson 2: Creating Data Types and
TablesCreating Data Types.
Creating Tables.
Creating
Partitioned Tables.
Lesson 3: Using XMLRetrieving XML
by Using FOR XML
Shredding XML by Using OPENXML
Introducing
XQuery
Using the xml Data Type
Lesson 4: Creating
and Tuning IndexesPlanning Indexes.
Creating Indexes.
Optimizing
Indexes.
Creating XML Indexes.
Lesson 5: Implementing
Data Integrity by Using ConstraintsData Integrity Overview
Implementing Constraints
Lesson 6: Implementing
Data Integrity by Using Triggers and XML Schemas
Implementing
Triggers
Implementing XML Schemas
|
Lesson 7: Implementing
ViewsIntroduction to Views
Creating and Managing Views
Optimizing Performance by Using Views
Lesson 8: Implementing Stored ProceduresImplementing Stored Procedures
Creating Parameterized Stored Procedures
Working With
Execution Plans
Handling Errors
Lesson 9: Implementing
FunctionsCreating and Using Functions
Working with Functions
Controlling Execution Context
Lesson 10: Implementing Managed Code in the
DatabaseIntroduction to the SQL Server Common Language Runtime
Importing and Configuring Assemblies
Creating Managed
Database Objects
Lesson 11: Managing Transactions and
LocksOverview of Transactions and Locks
Managing Transactions
Understanding SQL Server Locking Architecture
Managing Locks
Lesson 12: Using Service BrokerService Broker Overview
Creating Service Broker Objects
Sending and Receiving
Messages
Lesson 13: Using Notification Services
(Optional)Introduction to Notification Services
Developing
Notification Services Solutions
|
