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

6232 Implementing a Microsoft SQL Server 2008 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 the knowledge and skills to implement a Microsoft SQL Server 2008 database

Workshop Description/Agenda

Overview :
This course provides students with the knowledge and skills to implement a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to implementing a database.

Objective :
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 2008. - Plan, create, and optimize indexes. - Implement data integrity in Microsoft SQL Server 2008 databases by using constraints. - Implement data integrity in Microsoft SQL Server 2008 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.

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: Creating and Tuning Indexes
Planning Indexes
Creating Indexes
Optimizing Indexes

Lesson 4: Implementing Data Integrity by Using Constraints and Triggers
Data Integrity Overview
Implementing Constraints
Implementing Triggers

Lesson 5: Using XML
Using the XML Data Type
Retrieving XML by Using FOR XML
Shredding XML by Using OPENXML
Introducing XQuery
Creating XML Indexes
Implementing XML Schemas

Lesson 6: Implementing Views
Introduction to Views
Creating and Managing Views
Optimizing Performance by Using Views

Lesson 7: Implementing Stored Procedures
Implementing Stored Procedures
Creating Parameterized Stored Procedures
Working With Execution Plans
Handling Errors

Lesson 8: Implementing Functions
Creating and Using Functions
Working with Functions
Controlling Execution Context

Lesson 9: Implementing Managed Code in the Database
Introduction to the SQL Server Common Language Runtime
Importing and Configuring Assemblies
Creating Managed Database Objects

Lesson 10: Managing Transactions and Locks
Overview of Transactions and Locks
Managing Transactions
Understanding SQL Server Locking Architecture
Managing Locks

Lesson 11: Using Service Broker
Service Broker Overview
Creating Service Broker Objects
Sending and Receiving Messages

Who Should Attend

Database professionals who plan to implement a Microsoft SQL Server 2008

Additional Information

Training Provider: New Horizons Computer Learning Center

Course Topics: Computers / IT Training > Database

Training Course Summary: This course provides students with the knowledge and skills to implement a Microsoft SQL Server 2008 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: