SQL Server Course

SQL Server 2008 Database Administration — 30 hours

Course 6231: Maintaining a Microsoft SQL Server 2008 Database

- Module 1: SQL Server Installation and Configuration

- Module 2: Managing Databases and Files

- Module 3: Disaster Recovery

- Module 4: Security Management

- Module 5: Data Transfer

- Module 6: Automating Administrative Tasks

- Module 7: Implementing Replication

- Module 8: High Availability

- Module 9: Monitoring SQL Server

- Module 10: Troubleshooting and Performance Tuning

SQL Server 2008 Database Development — 30 hours

Course 6232: Implementing a Microsoft SQL Server 2008 Database

- Module 1: Creating Databases and Database Files

- Module 2: Creating Data Types and Tables

- Module 3: Creating and Tuning Indexes

- Module 4: Ensuring Data Integrity Using Constraints and Triggers

- Module 5: Using XML

- Module 6: Views

- Module 7: Stored Procedures

- Module 8: Functions

- Module 9: Code Management in the Database

- Module 10: Transactions and Locks

- Module 11: Using Service Broker