MSSQL Server 2008: Developer

SQL Server 2008: Developer

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

• The students will learn to use Service Broker to create secure, reliable, and scalable applications.

Lessons

• Service Broker Overview
• Creating Service Broker Objects
• Sending and Receiving Messages

Top