home 
 
 
 
enfr
 
Home
Over ABIS
Diensten
Cursussen
Resources
Contact
MyABIS
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.

Background

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.

Duration

4 days.

Schedule

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.

Objectives

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