MS SQL for administrator

About this Workshop
This workshop provides participants with the knowledge and skills how to use SQL Server 2008 product features and tools related to database administration.

Duration
5 days

Upon Completion
Participants will be able to:
· Install and configure SQL Server 2008.
· Manage database files.
· Backup and restore databases.
· Manage security.
· Transfer data into and out of SQL Server.
· Automate administrative tasks.
· Replicate data between SQL Server instances.
· Maintain high availability.
· Monitor SQL Server.

Workshop Agenda

1: Installing and Configuring SQL
· Preparing to Install SQL Server
· Installing SQL Server
· Configuring a SQL Server Installation

2: Managing Databases and Files
· Planning Databases
· Creating Databases
· Using Policy-Based Management

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

4: Managing Security
· Overview of SQL Server Security
· Protecting the Server Scope
· Protecting the Database Scope
· Managing Keys and Certificates
· Auditing Security

5: Transferring Data
· Overview of Data Transfer
· Introduction to SQL Server Integration Services

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

7: Implementing Replication
· Overview of Replication
· Managing Publications and Subscriptions
· Configuring Replication in Some Common Scenarios

8: Maintaining High Availability
· Introduction to High Availability
· Implementing Log Shipping
· Implementing Database Mirroring
· Implementing Server Clustering
· Using Distributed High Availability Solutions

9: Monitoring SQL Server
· Viewing Current Activity
· Using SQL Server Profiler
· Monitoring with DDL Triggers
· Using Event Notifications

10: Troubleshooting and Performance Tuning
· Troubleshooting SQL Server
· Performance Tuning in SQL Server
· Using Resource Governor
· Using Data Collector