About this Workshop
This workshop provides participants with the knowledge and skills how to use SQL Server 2008 product features and tools related to database design and implementation.
Duration
5 days
Upon Completion
· 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
Workshop Agenda
1: Creating Databases and Database Files
· Creating Databases
· Creating Filegroups
· Creating Schemas
· Creating Database Snapshots
2: Creating Data Types and Tables
· Creating Data Types
· Creating Tables
· Creating Partitioned Tables
3: Creating and Tuning Indexes
· Planning Indexes
· Creating Indexes
· Optimizing Indexes
4: Implementing Data Integrity by Using Constraints and Triggers
· Data Integrity Overview
· Implementing Constraints
· Implementing Triggers
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
6: Implementing Views
· Introduction to Views
· Creating and Managing Views
· Optimizing Performance by Using Views
7: Implementing Stored Procedures
· Using Stored Procedures
· Creating Parameterized Stored Procedures
· Working With Execution Plans
· Handling Exceptions
8: Implementing Functions
· Introducing Functions
· Working with Functions
· Controlling Execution Context
9: Implementing Managed Code in the Database
· Introduction to the SQL Server Common Language Runtime
· Importing and Configuring Assemblies
· Creating Managed Database Objects
10: Managing Transactions and Locks
· Overview of Transactions and Locks
· Managing Transactions
· Understanding SQL Server Locking Architecture
· Managing Locks
11: Using Service Broker
· Service Broker Overview
· Creating Service Broker Objects
· Sending and Receiving Messages
