AUDIENCE:   This course is designed for Administrators and Developers responsibe for maintaining and developing Database systems using Microsoft SQL Server 2005. PREREQUISITES:   Those attending should ideally have some experience of working with Relational Database Management Systems, however no previous knowledge of SQL Server 2005 will be assumed. DURATION:   5 days. Hands on. OBJECTIVES:   On completion of this course delegates will understand: Installation procedures for SQL Server 2005 How to use the SQL Server 2005 client tools to administer databases and create database applications. Administering the database engine. Use SQL Server Integration Services (SSIS) to import, export, and transform data. Use SQL Server Replication to synchronize data between databases. Use SQL Server Reporting Services (SSRS) to create dynamic database reports. Perform complex queries using SQL Server Full-Text Search (SSFTS). Use SQL Server Notification Services (SSNS). Use SQL Server Service Broker. Create database applications. Database Performance and Optimisation monitoring and issues. Use SQL Server Analysis Services (SSAS). Understand SQL Server 2005 security features and concepts. COURSE CONTENT:   Installation and Configuration System Use SQL Server Editions Architectures Landscapes Hardware Configuration Installation Process Architecture and Tools System Architecture Physical Footprint The Query Process The Database Engine Objects Communication Processes Tools SQL Server Configuration Manager SQL Server Management Studio Command-Prompt Utilities SQL Server Profiler Maintenance and Automation Maintenance The Recovery Model Backup Locations Backup Security Restore Restore Types Consistency Checks and Shrinking the Database Checking Consistency Shrinking the Database Index Fragmentation Auditing the Server Service Packs and Hot Fixes Growth Analysis Automation SQL Server Agent Jobs Alerts Operators Creating a Maintenance Plan Security Security and the Data Path Platform Security Securing the Network Securing the Hardware Securing the Operating System Securing SQL Server User Security (Principals) Password and Account Policies User Accounts Roles Principal-Defined Database Roles Application Roles Object Security Permissions The Security Hierarchy Application-Based Security Application Security Methods Encryption, Certificates, Key Management Keys Certificates Monitoring and Optimization Monitoring Baseline Monitor What Tools System Views and Functions System Optimisation Platform Indexes Data Structure Applications High Availability Near-Real-Time Availability Mechanisms Replication Log Shipping Real-Time Availability Mechanisms Database Mirroring Clustering Notification Services and the Service Broker Notification Services Notification Services Architecture Security Monitoring and Performance Tuning Service Broker Post Office Security Monitoring and Performance Tuning Integration Services Integration Services Architecture Integration Services Components Tools Wizards Security Monitoring and Performance Tuning System Monitoring Package Logging Performance Tuning Reporting Services Reporting Services Architecture Deployment Models Report Design and Creation Report Types Design and Development Tools Creating Reports Reporting System Management Reporting Services Configuration Tool Report Manager SQL Server Management Studio Reporting Security Security Layers Managing Security with Report Manager Reporting Delivery System Subscriptions Monitoring and Performance Tuning Take Away Analysis Services Business Intelligence Scenarios Implementing Business Intelligence in SQL Server 2005 SQL Server Database SQL Server Integration Services SQL Server Analysis Services SQL Server Reporting Services Analysis Services Maintenance Infrastructure Storage Security Job Processing Synchronizing Backups Monitoring and Performance Tuning Upgrading to SQL Server 2005 General Guidelines Planning Document Your Current Systems Create an Exit Strategy Requirements What Works and What Doesn't Upgrade Strategies Migration Side-by-Side In-Place Post-Upgrade Steps System Configuration Check Security Checks Performance Tuning