2779 - Implementing a Microsoft SQL Server 2005 Database
Overview: This course provides students with product knowledge and skills needed to implement a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to implementing a database.
Prerequisites: Before attending this course, students must have basic knowledge of the Microsoft Windows operating system and its core functionality, Transact-SQL, relational databases, and some experience with database design. In addition, it is recommended, but not required, that students have completed course 2778: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL.
Duration: 5 days
Chapter 1: Creating Databases and Database Files
Creating Databases
Creating Filegroups
Creating Schemas
Creating Database Snapshots
Chapter 2: Creating Data Types and Tables
Creating Data Types
Creating Tables
Creating Partitioned Tables
Chapter 3: Using XML
Retrieving XML by Using FOR XML
Shredding XML by Using OPENXML
Using the XML Data Type
Chapter 4: Creating and Tuning Indexes
Planning Indexes
Creating Indexes
Optimising Indexes
Creating XML Indexes
Chapter 5: Implementing Data Integrity
Data Integrity Overview
Implementing Constraints
Implementing Triggers
Implementing XML Schemas
Chapter 6: Implementing Views
Introduction to Views
Creating and Managing Views
Optimising Performance by Using Views
Chapter 7: Implementing Stored Procedures and Functions
Implementing Stored Procedures
Creating Parameterized Stored Procedures
Creating Functions
Handling Errors
Controlling Execution Context
Chapter 8: Implementing Managed Code in the Database
Introduction to the SQL Server Common Language Runtime
Copyright (c) 2005 New Horizons - All Rights Reserved. Procomp Computer Services CC trading as New Horizons Computer Learning Centre. Registration No. 2002/029621/23
Add to Favourites 
Location
