Home > Courses Certifications > Data Management > Course 6232 synopsis

6232 - Implementing a Microsoft SQL Server 2008 Database

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

Duration: 5 days

 

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: Using XML

• Introduction to Views
• Creating and Managing Views
• Optimizing Performance by Using Views

Module 7: Implementing Stored Procedures

• Using Stored Procedures
• Creating Parameterized Stored Procedures
• Working With Execution Plans
• Handling Exceptions

Module 8: Implementing Functions

• Introducing 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