| Publisher: | Microsoft |  |
|---|---|---|
| Version: | MS | |
| Length: | 3 day s | |
| Course-ID: | MS2780 |
This course provides students with product knowledge and skills needed to maintain a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to maintaining a 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.
- Some experience with database design.
|
Installing and Configuring SQL Server 2005 Preparing to install SQL Server Installing SQL Server Managing a SQL Server 2005 Installation Managing Databases and Files Planning databases Creating databases Managing databases Managing Security Overview of SQL Server Security Securing the Server Scope Securing the Database Scope Implementing Cryptography in SQL Server. Disaster Recovery Planning a Backup Strategy Backing Up User Databases Restoring User Databases Recovering Data from Database Snapshots System Database and Disaster Recovery Monitoring SQL Server Viewing Current Activity Using System Monitor Using SQL Server Profiler Using DDL Triggers Using Event Notifications Transferring Data Overview of Data Transfer Introduction to SQL Server Integration Services (SSIS) Using SQL Server Integration Services 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 Maintaining High Availability Introduction to High Availability Implementing Server Clustering Implementing Database Mirroring Implementing Log Shipping Introduction to Replication Overview of Replication Creating a Publication Creating A Subscription |
|---|