6232 - Implementing a Microsoft SQL Server 2008 Database

Voor wie?

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

Resultaat

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.

Inhoud

Module 1: Creating Databases and Database Files: Creating Databases Creating Filegroups Creating Schemas Creating Database Snapshots Module 2: Creating Data Types and Tables: Creating Data Types Creating Tables Creating Partitioned Tables Module 3: Creating and Tuning Indexes: Planning Indexes Creating Indexes Optimizing Indexes Module 4: Implementing Data Integrity by Using Constraints and Triggers: Data Integrity Overview Implementing Constraints Implementing Triggers Module 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 Module 6: Implementing Views: Introduction to Views Creating and Managing Views Optimizing Performance by Using Views Module 7: Implementing Stored Procedures Implementing Stored Procedures Creating Parameterized Stored Procedures Working With Execution Plans Handling Errors Module 8: Implementing Functions: Creating and Using Functions Working with Functions Controlling Execution Context Module 9: Implementing Managed Code in the Database: Introduction to the SQL Server Common Language Runtime Importing and Configuring Assemblies Creating Managed Database Objects Module 10: Managing Transactions and Locks: Overview of Transactions and Locks Managing Transactions Understanding SQL Server Locking Architecture Managing Locks Module 11: Using Service Broker: Service Broker Overview Creating Service Broker Objects Sending and Receiving Messages

Examen

De cursussen MS 6231 + MS 6232 bereiden u voor op het examen 70-432: TS: Microsoft SQL Server 2008 - Implementation and Maintenance. Met het behalen van dit examen bent u MCTS (Microsoft Certified Technology Specialist) MS SQL Server 2008- Implementation and Maintenance. Het examen is niet in de prijs opgenomen.

Extra informatie

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.