Home > Courses Certifications > Data Management > Course 6231 synopsis

6231 - Maintaining a Microsoft SQL Server 2008 Database

Prerequisites: Before attending this course, students must have:

• Basic knowledge of the Microsoft Windows operating system and its core functionality.
• Working knowledge of Transact-SQL.
• Working knowledge of Relational databases.
• Core Windows Server skills.
• Database design skills.

Duration: 5 days

 

Module 1: Installing and Configuring SQL Server

• Preparing to Install SQL Server
• Installing SQL Server
• Configuring a SQL Server Installation

Module 2: Managing Databases and Files

• Planning Databases
• Creating Databases
• Using Policy-Based Management

Module 3: Disaster Recovery

• Planning a Database Backup Strategy
• Backing Up a User Database
• Restoring User Databases
• Performing Online Restore Operations
• Recovering Data from Database Snapshots
• System Databases and Disaster Recovery

Module 4: Managing Security

• Overview of SQL Server Security
• Protecting the Server Scope
• Protecting the Database Scope
• Managing Keys and Certificates
• Auditing Security

Module 5: Transferring Data

• Overview of Data Transfer
• Introduction to SQL Server Integration Services

Module 6: Automating Administrative Tasks

• Automating Administrative Tasks in SQL Server
• Using SQL Server Agent
• Creating Maintenance Plans
• Implementing Alerts
• Managing Multiple Servers
• Managing SQL Server Agent Security

Module 7: Implementing Replication

• Overview of Replication
• Managing Publications and Subscriptions
• Configuring Replication in Some Common Scenarios

Module 8: Maintaining High Availability

• Introduction to High Availability
• Implementing Log Shipping
• Implementing Database Mirroring
• Implementing Server Clustering
• Using Distributed High Availability Solutions

Module 9: Monitoring SQL Server

• Viewing Current Activity
• Using SQL Server Profiler
• Monitoring with DDL Triggers
• Using Event Notifications

Module 10: Troubleshooting and Performance Tuning

• Troubleshooting SQL Server
• Performance Tuning in SQL Server
• Using Resource Governor
• Using Data Collector