Microsoft SQL Server

Course Start Date: 25TH April 2016

Next Intake: T.B.A.

Duration: 1 Month


6231 Maintaining a Microsoft SQL Server 2008 Database

Duration:

  • Instructor Led Learning – 40 Hrs

Outline:

Lesson 1: Installing and Configuring SQL Server

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

Lesson 2: Managing Databases and Files

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

Lesson 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

Lesson 4: Managing Security

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

Lesson 5: Transferring Data

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

Lesson 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

Lesson 7: Implementing Replication

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

Lesson 8: Maintaining High Availability

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

Lesson 9: Monitoring SQL Server

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

Lesson 10: Troubleshooting and Performance Tuning

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