AUDIENCE:   This course is designed for Administrators and Developers responsibe for maintaining and developing Database systems using Microsoft SQL Server 2005. PREREQUISITES:   It is recommended that before attending this course students possess the following: - An understanding of working in a Microsoft Windows operating system environment. - An understanding of relational databases and design principles. DURATION:   5 days. Hands on. OBJECTIVES:   This course is intended for students who need to learn the skills necessary to maintain a Microsoft SQL Server 2005 database infrastructure. This is a comprehensive, hands-on course aimed at quickly getting students familiar with the Microsoft SQL Server 2005 administration concepts, tools and utilities. COURSE CONTENT:   1. SQL Primer: Querying Data Objects in a SQL Server Database Database Diagrams Retrieving Data with the SELECT Statement Filtering Data with the WHERE Clause Sorting Data Using the ORDER BY Clause Querying Data from Multiple Tables using Joins Summarizing Data Using Aggregate Functions Querying Data with Subqueries 2. SQL Primer: Modifying Data Inserting Data into Tables Deleting Data from Tables Updating Data in Tables 3. Install and Configure SQL Server 2005 Installation Prerequisites The Installation Process Upgrading from Previous Versions Post Install Configuration Options 4. Managing Databases and Files Planning to Implement a Database Creating a Database Configuring and Managing a Database 5. Creating and Managing Tables Creating a Table Native SQL Server Data Types Columns and Column Properties Defining and Managing Constraints User-defined Types 6. Creating and Managing Indexes SQL Server Index Architecture Creating Clustered Indexes Creating Non-Clustered Indexes Included Columns Managing Index Fragmentation Managing Statistics 7. Creating and Managing Partitions Partition Functions Partition Schemes Partitioning Tables and Indexes Query Data in Partitions Managing Partitions 8. SQL Server 2005 Security Overview of SQL Server Security Security at the Server Level Security at the Database Level Encrypting Data 9. Transferring Data Overview of Data Transfer Examining the Data Transfer Utilities Introducing SQL Server Integration Services (SSIS) 10. Backups and Recovery Backup Types and Strategies Backing up a Database Restoring a Database Database Snapshots Recovering System Databases 11. SQL Server Automation Overview of SQL Server Automation The SQL Server Agent Service Creating and Managing Jobs Creating and Managing Operators Creating and Managing Alerts Managing Multiple Servers Managing SQL Server Agent Security 12. Monitoring SQL Server Overview of Performance Monitoring Viewing the Current Activity Using System Monitor Using SQL Server Profiler Using DDL Triggers Using Event Notifications 13. Maintaining High Availability Introduction to High Availability Implementing Server Clustering Implementing Database Mirroring Implementing Log Shipping 14. Introduction to Replication Overview of Replication Replication Types and Models Creating Publications Creating Subscriptions 15. Using Service Broker Service Broker Architecture Message Types and Contracts Queues and Services Conversations Sending and Receiving Messages DA08/02