Need Help? Call us at (281) 541-2807 Visit our Facebook Page Follow us on Twitter Subscribe to our RSS Feeds

2779 Implementing a Microsoft SQL Server 2005 Database On-Site Training

presented by New Horizons Computer Learning Center
View the New Horizons Computer Learning Center Profile and Available Training

There may be public open-enrollment dates/locations for this class near you.

Summary

This course provides students with product knowledge and skills needed to implement a Microsoft SQL Server 2005 database

Workshop Description/Agenda

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

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

Additional Information

Training Provider: New Horizons Computer Learning Center

Course Topics: Computers / IT Training > Database

Training Course Summary: This course provides students with product knowledge and skills needed to implement a Microsoft SQL Server 2005 database

Private Group Training Request

For groups of 10 or more, consider bringing the training to you as a cost effective way to train your workforce. Fill out the following form and we will contact you right away.

 

Enter Your On-Site Training Requirements

 

Name:

Company:

Contact Number:

Email Address:

Your City:

Your State:

Expected Number of Attendees:

When To Hold the Class:

How Many Days of Instruction:
Briefly Describe Your Training Needs: