About this Course

This five-day instructor-led 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. 

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 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. 

Course Outline

Module 1: Creating Databases and Database Files 

Module 2: Creating Data Types and Tables

Module 3: Creating and Tuning Indexes

Module 4: Implementing Data Integrity by Using Constraints and Triggers 

Module 5: Using XML 

Module 6: Implementing Views 

Module 7: Implementing Stored Procedures

Module 8: Implementing Functions 

Module 9: Implementing Managed Code in the Database 

Module 10: Managing Transactions and Locks 

Module 11: Using Service Broker 

TARGET AUDIENCE

This course is intended for IT Professionals who administer and maintain SQL Server databases.

PRE-REQUISITE

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.
  

5 days

Rate this course:

Log in to submit

Comments