New Horizons Lexington KY Computer Training
New Horizons Computer Learning Center presents
 

6232 Implementing a Microsoft SQL Server 2008 Database On-Site Training

This on-site training class is also available as Public Schedule Seminar.

This course provides students with the knowledge and skills to implement a Microsoft SQL Server 2008 database

Course 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

 

More Seminar Information

New Horizons Computer Learning Center
New Horizons Lexington KY Computer Training

Delivery Method

 On-Site Training On-Site Training

Also Available As

 Seminar Seminar

  		Add to favorites Add to favorites
Email Email this page
 

On-Site Training
Information Request Form

Please complete the form for more information and/or a quote for this on-site class.

Name:

Email

Phone:

City and State

Company:

Number of students:
(at least 10 for consideration)

When do you want to hold the
seminar?

How long would you like for the
seminar?

Additional comments to trainer:

We value your privacy!