MSSQL Server 2005: Database Administration

SQL Server 2005: Database Administration

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.
li> 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: Automating Administrative Tasks

• Automating Administrative Tasks in SQL Server 2005.
• Configuring the SQL Server Agent.
• Creating Jobs and Operators.
• Creating Alerts.
• Managing Multiple Servers.
• Managing SQL Server Agent Security.

Module 8: Maintaining High Availability

• Introduction to High Availability.
• Introduction to Server Clustering.
• Introduction to Database Mirroring.
• Introduction to Log Shipping.

Module 9: Introduction to Replication

• Overview of Replication.
• Replication Scenarios.

Top