2779 Implementing a Microsoft SQL Server 2005 Database - Class Outline

Print Preview \| E-Mail Outline

2779 Implementing a Microsoft SQL Server 2005 Database Duration: Traditional Instructor Led Learning - 5.00 Day(s) Online Live - 5.00 Sessions Mentored Learning - Flexible 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. Who Should Attend: This course is intended for IT Professionals who want to become skilled on SQL Server 2005 product features and technologies for 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 2005. - Plan, create, and optimize indexes. - Implement data integrity in Microsoft SQL Server 2005 databases by using constraints. - Implement data integrity in Microsoft SQL Server 2005 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. - Use Notification Services to generate and send notifications.
Prerequisite(s) or equivalent knowledge:
50027 Querying and Processing SQL Server Data with SQL Statements
Prerequisite Comments:
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.

Outline:	Top
Lesson 1: Creating Databases and Database Files
Creating Databases. Creating Filegroups. Creating Schemas. Creating Database Snapshots.	Top
Lesson 2: Creating Data Types and Tables
Creating Data Types. Creating Tables. Creating Partitioned Tables.
Lesson 3: Using XML
Retrieving XML by Using FOR XML Shredding XML by Using OPENXML Introducing XQuery Using the xml Data Type
Lesson 4: Creating and Tuning Indexes
Planning Indexes. Creating Indexes. Optimizing Indexes. Creating XML Indexes.
Lesson 5: Implementing Data Integrity by Using Constraints
Data Integrity Overview Implementing Constraints	Top
Lesson 6: Implementing Data Integrity by Using Triggers and XML Schemas
Implementing Triggers Implementing XML Schemas
Lesson 7: Implementing Views
Introduction to Views Creating and Managing Views Optimizing Performance by Using Views
Lesson 8: Implementing Stored Procedures
Implementing Stored Procedures Creating Parameterized Stored Procedures Working With Execution Plans Handling Errors
Lesson 9: Implementing Functions
Creating and Using Functions Working with Functions Controlling Execution Context	Top
Lesson 10: Implementing Managed Code in the Database
Introduction to the SQL Server Common Language Runtime Importing and Configuring Assemblies Creating Managed Database Objects
Lesson 11: Managing Transactions and Locks
Overview of Transactions and Locks Managing Transactions Understanding SQL Server Locking Architecture Managing Locks
Lesson 12: Using Service Broker
Service Broker Overview Creating Service Broker Objects Sending and Receiving Messages
Lesson 13: Using Notification Services (Optional)
Introduction to Notification Services Developing Notification Services Solutions	Top

*Content, days, and times vary depending on your location. Please view the outline on the checkout page prior to purchase or
contact the local center for more information.