New Horizons Computer Training

  learning resources


  talk to us live

Fill in the simple form below and we will contact you for FREE!

Name:
Email:
Phone:
Location:
Question:
Please enter the code below:
Security Image


Join us on:

Follow us on Twitter

Join us on Facebook

 

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

 


Contact us!
Back to top
Previous Page! Share on Twitter
 
Computer Course Catalog :: Location ::Contact us :: Privacy Policy :: Home ::
 


Tel: 0861 111 460   E-mail: solutions@newhorizonsct.co.za

Copyright (c) 2005 New Horizons - All Rights Reserved.
Procomp Computer Services CC trading as New Horizons Computer Learning Centre. Registration No. 2002/029621/23