Courses & Workshops

Quickstart Database Administration

Duration: 5 days

This course covers an overview of database administration tasks, creating a Collections Server database, the structure of the database, data loading and security issues. It covers the basics of querying and displaying data in FQM. It explains how to create and use command procedures for data retrieval, updating the database or for reporting purposes.

With Quickstart Database Administration, we can bring the prerequisite knowledge as well as the steps to create and maintain a Collections Server database in order for you to become a Collections Server DBA in a single 5-day workshop!

Quickstart Database Administration covers the following topics:

  • Overview
  • Database Utilities
  • Creating a Collections Server Database
  • ADM Introduction
  • Record Styles
  • Fields
  • Search Control Sets
  • Data Validation
  • SDM Introduction
  • Complex SDM Design
  • Indexes
  • Journals
  • UDM Introduction
  • Views
  • Security
  • Data Loading
  • Introducing FQM
  • Text Retrieval in FQM
  • Displaying Data in FQM
  • Joining Multiple Records in FQM
  • Introduction to Command Procedures
  • Using Variables in Procs
  • Writing More Complex Procs
  • Manipulating Database Values
  • Working with Files


The DBA who is new to Open Text Collections Server, and needs to know the core features of the product.




If you wish to schedule this course at a different time than what is on the training schedule, please contact the Training Registrar at


Format Currency Price
Per Student at Open Text Site USD  3,500.00 
Per Course at Customer Site USD  12,500.00 

Taxes: All prices exclude VAT or other taxes where applicable (all currencies).

Extra expenses: Customer site course prices do not include instructor travel expenses, which are billed separately.

Reservations: Please provide a minimum of 3 weeks advance notice when arranging courses at customer sites.

Course & Workshop Calendar

Currently, there are no training dates scheduled for this course or workshop at this time. Please contact us to schedule an on-site course or workshop at your location.