6231 - Maintaining a Microsoft SQL Server 2008 Database

Voor wie?

This course is intended for IT Professionals who administer and maintain SQL Server databases.

Resultaat

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database.

Inhoud

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 Backup Strategy Backing Up User Databases 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 Protecting the Server Scope 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

Examen

De cursussen MS 6231 + 6232 bereiden u voor op het examen 70-432: TS: Microsoft SQL Server 2008 - Implementation and Maintenance. Met het behalen van dit examen bent u MCTS (Microsoft Certified Technology Specialist) MS SQL Server 2008 - Implementation and Maintenance. Het examen is niet in de prijs opgenomen.

Extra informatie

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. Some experience with database design.