Alle CursussenbalkjeAlgemeen Soft skills Introductie HW & SW TrajectenOperating Systems MVS - z/OS UNIX - Linux - AIX Mac OS X iPad en iPhone iOSDatabases, transactiesystemen en middleware DB2 for z/OS DB2 UDB for Linux, UNIX and Windows Oracle SQL Server MySQL IMS CICS WebSphere MQ WebSphere Application Server Data warehouse, business analytics en big dataApplicatieontwikkeling Methoden en technieken TOGAF PRINCE2 Agile en Scrum Programmeertalen Internet development Object Oriented systems Java IBM development tools SAS XML SOA & web servicesSysteembeheer ITIL SecuritybalkjePraktischInschrijven 
Deze pagina is niet beschikbaar in het Nederlands.
Maintaining a SQL Server 2008 database

Intended for

IT Professionals wanting to become skilled on SQL Server 2008 product features and technologies for maintaining a database.


Before attending this course, students must have competency in the following areas:

It is also recommended that students have completed the Implementing a SQL Server 2008 database course.

Training method

Class training alternated with exercises.

Course leader

an ABIS partner.


4 days.


No public sessions are currently scheduled. We will be pleased to set up an on-site course or to schedule an extra public session (in case of a sufficient number of candidates). Interested ? Please contact ABIS.


This course provides students with the knowledge and skills required to install, configure, administer, and troubleshoot the client-server database management system of SQL Server 2008.

After completing this course, students will be able to:

  • Install and configure SQL Server 2008;
  • Manage database files;
  • Back up and Restore databases;
  • Manage security;
  • Automate administrative tasks;
  • Replicate data between SQL Server instances;
  • Transfer data into and out of SQL Server;
  • Maintain high availability;
  • Monitor SQL Server.

Main topics

  • Installing and Configuring SQL Server
  • Preparing to install SQL Server
  • Installing SQL Server
  • Configuring a SQL Server Installation
  • Managing Databases and Files
  • Planning databases
  • Creating databases
  • Using Policy-Based Management
  • Disaster Recovery
  • Planning a Backup Strategy
  • Backing Up User Databases
  • Restoring User Databases
  • Performing Online Restore Operations
  • Recovering Data from Database Snapshots
  • System Database and Disaster Recovery
  • Managing Security
  • Overview of SQL Server Security
  • Protecting the Server Scope
  • Protecting the Database Scope
  • Managing Keys and Certificates
  • Auditing Security
  • Transferring Data
  • Overview of Data Transfer
  • Introduction to SQL Server Integration Services
  • Automating Administrative Tasks
  • Automating Administrative Tasks in SQL Server 2008
  • Using SQL Server Agent
  • Creating maintenance plans
  • Implementing Alerts
  • Managing Multiple Servers
  • Managing SQL Server Agent Security
  • Implementing Replication
  • Overview of Replication
  • Managing Publications and Subscriptions
  • Configuring Replication in some common scenarios
  • Maintaining High Availability
  • Introduction to High Availability
  • Implementing Log Shipping
  • Implementing Database Mirroring
  • Implementing Server Clustering
  • Using Distributed High Availability Solutions
  • Monitoring SQL Server
  • Viewing Current Activity
  • Using SQL Server Profiler
  • Monitoring with DDL Triggers
  • Using Event Notifications
  • Performance Tuning and Troubleshooting
  • Troubleshooting SQL Server
  • Performance Tuning in SQL Server
  • Using Resource Governor
  • Using Data Collector