Detail

MSSQL Server 2005 Database Administration SQL Server 2005 Module 1: Installing and Configuring SQL Server 2005 Preparing to install SQL Server. Installing SQL Server. Managing a SQL Server 2005 Installation. Module 2: Managing Databases and Files Planning databases. Creating databases. Managing databases. Module 3: Disaster Recovery Planning a Backup Strategy. Backing Up User Databases. Restoring User Databases. Recovering Data from Database Snapshots. System Database and Disaster Recovery. Module 4: Managing Security Overview of SQL Server Security. Securing the Server Scope. Securing the Database Scope. Managing Keys and Certificates in SQL Server. Module 5: Monitoring SQL Server Viewing Current Activity. Using System Monitor. Using SQL Server Profiler. Using DDL Triggers. Using Event Notifications. Module 6: Maintaining the Database DBCC Commands Managing Database Maintenance Module 7: Transferring Data Overview of Data Transfer. Introduction to SQL Server Integration Services. Using SQL Server Integration Services. Module 8: Introduction to Analysis Services Understanding Analysis Services Creating a Unified Dimensional Model Module 9: Introduction to Reporting Services Understanding Reporting Services Configuring Reporting Services Building a Simple Report Creating, Publishing, and Viewing Reports Module 10: Automating Administrative Tasks Automating Administrative Tasks in