|
|
|
Module 1: Creating Databases and Database Files
- This module explains how to create databases, filegroups, schemas, and database snapshots.
- Creating Databases
- Creating Filegroups
- Creating Schemas
- Creating Database Snapshots
- Lab: Creating Databases and Database Files
Skills
- Create databases.
- Create filegroups.
- Create schemas.
- Create database snapshots.
Top |
|
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.
- Creating Data Types
- Creating Tables
- Creating Partitioned Tables
- Lab: Creating Data Types and Tables
Skills
- Create new data types.
- Create new tables.
- Create partitioned tables.
Top |
|
|
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.
- Retrieving XML with FOR XML
- Shredding XML with OPENXML
- Introducing XQuery
- Using the xml Data Type
- Lab: Using XML
Skills
- Retrieve XML by using the FOR XML clause.
- Shred XML by using the OPENXML function.
- Use XQuery expressions.
- Use the xml data type.
Top |
|
Module 4: Creating and Tuning Indexes
- This module explains how to plan, create, and optimize indexes. It also describes how to create XML indexes.
- Planning Indexes
- Creating Indexes
- Optimizing Indexes
- Creating XML Indexes
- Lab: Creating and Tuning Indexes
Skills
- Plan indexes.
- Create indexes.
- Optimize indexes.
- Create XML indexes.
Top |
|
|
Module 5: Implementing Data Integrity by Using Contraints
- This module explains how to implement constraints and provides an overview of data integrity.
- Data Integrity Overview
- Implementing Constraints
- Lab: Implementing Data Integrity by Using Constraints
Skills
- Describe the options for enforcing data integrity in SQL Server 2005.
- Implement data integrity in SQL Server 2005 databases by using constraints.
Top |
|
Module 6: Implementing Data Integrity by Using Triggers and XML Schemas
- This module explains how to implement triggers and XML schemas.
- Implementing Triggers
- Implementing XML Schemas
- Lab: Implementing Data Integrity by Using Triggers and XML Schemas
Skills
- Implement data integrity in SQL Server 2005 databases by using triggers.
- Implement data integrity in SQL Server 2005 databases by using XML schemas.
Top |
|
|
Module 7: Implementing Views
- This module explains how to create views.
- Introduction to Views
- Creating and Managing Views
- Optimizing Performance by Using Views
- Lab: Implementing Views
Skills
- Describe the purpose of views.
- Create and manage views.
- Explain how to optimize query performance by using views.
Top |
|
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.
- Implementing Stored Procedures
- Creating Parameterized Stored Procedures
- Working With Execution Plans
- Handling Errors
- Lab: Implementing Stored Procedures
Skills
- Implement stored procedures.
- Create parameterized stored procedures.
- Work with execution plans.
- Handle errors in stored procedures.
- Send and receive Service Broker messages.
Top |
|
|
Module 9: Implementing Functions
- This module explains how to create functions. It also describes how to control the execution context.
- Creating and Using Functions
- Working with Functions
- Controlling Execution Context
- Lab: Implementing Functions
Skills
- Create and use functions.
- Work with functions.
- Control execution context.
Top |
|
Module 10: Implementing Managed Code in the Database
- This module explains how to implement managed database objects.
- Introduction to the SQL Server Common Language Runtime
- Importing and Configuring Assemblies
- Creating Managed Database Objects
- Lab: Implementing Managed Code in the Database
Skills
- Identify appropriate scenarios for managed code in the database.
- Import and configure assemblies.
- Create managed database objects.
Top |
|
|
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.
- Overview of Transactions and Locks
- Managing Transactions
- Understanding SQL Server Locking Architecture
- Managing Locks
- Lab: Managing Transactions and Locks
Skills
- Describe how SQL Server 2005 transactions use locks.
- Execute and cancel a transaction.
- Describe concurrency issues and SQL Server 2005 locking mechanisms.
- Manage locks.
Top |
|
Module 12: Using Service Broker
- This module explains how to build a messaging-based solution with Service Broker.
- Service Broker Overview
- Creating Service Broker Objects
- Sending and Receiving Messages
- Lab: Using Service Broker (Optional)
Skills
- Describe Service Broker functionality and architecture.
- Create Service Broker objects.
- Send and receive Service Broker messages.
Top |
|
|
Module 13: Using Notification Services (Optional)
- This module explains how to develop applications that generate and send timely messages to subscribers.
- Introduction to Notification Services
- Developing Notification Services Solutions
Skills
- Describe how Notification Services operates.
- Develop a Notification Services application.
Top |
|
|
|
|
Exams:
|
|
Price Options ex VAT:
Classroom Training
? |
Distance Learning
? |
eLearning Options
? |
Book Learning
? |
£
1550
(€2202)
|
£
995.00
(€1413)
|
- |
No Books Supported for Course at present
|
|
|
Call Free on 0800 169 1890
Print 2 Page Flyer
Last Modified 01 May 2008
|
|
