Home » Training Courses » Microsoft Certified Training » 6232 - Implementing a Microsoft SQL Server 2008 Database

6232 - Implementing a Microsoft SQL Server 2008 Database

• Book this course
• Email to a friend
• Download PDF

Course code: 6232

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.

Course Objectives:

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 databases 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 Content

• 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

Course Prerequisites:

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

Before attending this course, students must have:

• Working knowledge of Transact-SQL.
• Working knowledge of Relational databases.
• Core Windows Server skills.
• Database design skills.
• SQL Server skills - ability to write Transact-SQL queries or completed Course 2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL.

For full course content and pre-requisites download the 6232 - Implementing a Microsoft SQL Server 2008 Database Course PDF

Share This

Silicon Beach Training

See independent Google Places, Free Index and Qype reviews.