 |
Courses & Certifications
|
 |
MS2779 Implementing a Microsoft SQL Server 2005 Database
| Course start date: |
01-Dec-2008, 23-Feb-2009, 27-Apr-2009, 25-May-2009 |
| Training Location |
9 Denison St, Newcastle West |
| Duration: |
5 Days |
| Price: | $3,000.00 Inc GST |
Overview
This five-day instructor-led course provides students with the knowledge and
skills 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.
Prerequisites
Before attending this course, students must have:
- 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.
Course Outline
Module 1: Creating Databases and Database Files
This module explains how to create databases, filegroups, schemas, and database snapshots.
Lessons
- Creating Databases
- Creating Filegroups
- Creating Schemas
- Creating Database Snapshots
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.
Lessons
- Creating Data Types
- Creating Tables
- Creating Partitioned Tables
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.
Lessons
- Retrieving XML by Using FOR XML
- Shredding XML by Using OPENXML
- Introducing XQuery
- Using the xml Data Type
Module 4: Creating and Tuning Indexes
This module explains how to plan, create, and optimize indexes. It also describes how to create XML indexes.
Lessons
- Planning Indexes
- Creating Indexes
- Optimizing Indexes
- Creating XML Indexes
Module 5: Implementing Data Integrity by Using Constraints
This module explains how to implement constraints and provides an overview of data integrity.
Lessons
- Data Integrity Overview
- Implementing Constraints
Module 6: Implementing Data Integrity by Using Triggers and XML Schemas
This module explains how to implement triggers and XML schemas.
Lessons
- Implementing Triggers
- Implementing XML Schemas
Module 7: Implementing Views
This module explains how to create views.
Lessons
- Introduction to Views
- Creating and Managing Views
- Creating Partitioned Views
|
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.
Lessons
- Implementing Stored Procedures
- Creating Parameterized Stored Procedures
- Working With Execution Plans
- Handling Errors
Module 9: Implementing Functions
This module explains how to create functions. It also describes how to control the execution context.
Lessons
- Creating and Using Functions
- Working with Functions
- Controlling Execution Context
Module 10: Implementing Managed Code in the Database
This module explains how to implement managed database objects.
Lessons
- Importing an Assembly
- Creating Managed Database Objects
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.
Lessons
- Overview of Transactions and Locks
- Managing Transactions
- Understanding SQL Server Locking Architecture
- Managing Locks
Module 12: Using Service Broker
This module explains how to build a messaging-based solution with Service Broker.
Lessons
- Creating Service Broker Objects
- Implementing the Initiating Service
- Implementing the Target Service
Module 13: Using Notification Services (Optional)
This module explains how to develop applications that generate and send timely messages to subscribers.
Lessons
- Introduction to Notification Services
- Developing Notification Services Solutions
|
|
Forsythes IT & Training provides instructor led computer training on the Microsoft Office and Adobe range of applications.
We service Newcastle, the Hunter Valley, Lake Macquarie and the Central and Northern Coasts of New South Wales (NSW) Australia.
With our mobile training room we can provide a range of courses on-site at your premises.
|
|
|
|
