SQL Server 2005 for Developers Training Class

1. Creating Databases and Database Files

• 
  Create Databases


• 
  Create Filegroups


• 
  Create Schemas


• 
  Create Database Snapshots

2. Creating Data Types and Tables

• 
  Create Data Types


• 
  Create Tables


• 
  Create Partitioned Tables

3. Using Transact-SQL and XML

• 
  Basic Select Statement and Select Operators


• 
  Table Joins and Sub-queries


• 
  Insert, Update, and Delete


• 
  Aggregate Functions and Group By


• 
  Compute, Compute By, Cube, and Rollup


• 
  New Recursive Capabilities (CTEs)


• 
  Pivot and Unpivot Operations


• 
  Error Handling


• 
  Retrieving XML by using FOR XML


• 
  Shredding XML by using OPENXML


• 
  Introducing XQuery


• 
  Using the XML Data Type


• 
  XML Web Services

4. Creating and Tuning Indexes

• 
  Create Indexes


• 
  Define Clustered, Non-Clustered, and Unique Indexes


• 
  Define Index Creation Fill Factors


• 
  Tune Indexes


• 
  Optimize Indexes


• 
  Use Online Index Operations


• 
  Utilize Physical Storage


• 
  Create XML Indexes

5. Implementing Data Integrity by Using Constraints

• 
  Data Integrity Overview


• 
  Implementing Constraints

6. Implementing Data Integrity by Using Triggers and XML Schemas

• 
  Implementing Triggers


• 
  Implementing XML Schemas

7. Implementing Views

• 
  Introduction to Views


• 
  Creating and Managing Views


• 
  Optimizing Performance by Using Views

8. Implementing Stored Procedures

• 
  Implementing Stored Procedures


• 
  Creating Parameterized Stored Procedures


• 
  Working with Execution Plans


• 
  Handling Errors

9. Implementing Functions

• 
  Create and Use Functions


• 
  Work with Functions


• 
  Control Execution Context

10. Implementing Managed Code in the Database

• 
  Introduction to the SQL Server Common Language Runtime


• 
  Import and Configure Assemblies


• 
  Create Managed Database Objects


• 
  Compare T-SQL and Managed Code

11. Managing Transactions and Locks

• 
  Using Transactions


• 
  Managing Locks

12. Using Service Broker and ADO.Net

• 
  Service-Oriented Architecture (SOA)


• 
  Service Broker Overview


• 
  Create Service Broker Objects


• 
  Send and Receive Messages


• 
  Asynchronous Processing


• 
  Example Application


• 
  Explore ADO.Net 2.0


• 
  Multiple Active Result Sets (MARS)


• 
  Transparent Client Redirection

13. Using Notification Services

• 
  Introduction to Notification Services


• 
  Developing Notification Services Solutions


• 
  Example Notification Services Application

14. Security - Native Data Encryption

• 
  Object-Level Security


• 
  New Schema Object


• 
  Enable Native Data Encryption


• 
  Example Application of Data Encryption

• Basic knowledge of the Microsoft Windows operating system and its core
  functionality


• Basic knowledge of relational databases


• Some experience with database design


• Familiarity with basic Transact-SQL is helpful