Database Administration

Description

This course is designed for database administrators who need to administer Progress V9 or OpenEdge RDBMS 10 databases. It teaches the concepts, procedures, and guidelines used in database administration.

Students will learn about the OpenEdge RDBMS architecture, and how to use database administration tools to create, start up, and shut down a database. For maintenance, students will learn how to back up and restore a database, implement roll-forward recovery using after-imaging, and dump and load a database. Finally, they will learn how to troubleshoot database problems.

Materials you receive include two books – the Course Guide and the hands-on Lab Guide – as well as a CD with example code and lab files with solutions.

Also available online with a subscription to the OpenEdge eLearning Library

Version compatibility

This course is compatible with Progress V9 and OpenEdge 10.

What you will learn

After taking this training, you should be able to:

• Describe the OpenEdge RDBMS architecture.
• Familiarize with data administration tools.
• Create a database.
• Start up and shut down a database.
• Back up and restore a database.
• Implement roll-forward recovery using after-imaging.
• Dump and load a database.
• Troubleshoot database problems.

Prerequisites

Learners should already be able to:

• Understand relational database concepts such as tables, indexes, triggers, primary keys, foreign keys, and entity-relationship diagrams.
• Possess a working knowledge of either the UNIX or Windows operating system.

Courses that provide this prerequisite knowledge are:

• Third-party database design or data modeling courses
• Third-party UNIX or Windows operating system courses

Recommended Next Courses

Following is a list of recommended next courses, as of the time of publication. For the latest information about new ILT courses in your region, visit the Progress Education website.

For more information on the latest eLearning offerings, visit the OpenEdge eLearning Library.