Quickstart Database Administration

Have questions about training?   Contact us

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

Audience

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

Prerequisites

None.

Summary

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

Pricing

Format Currency Price
Per Student at OpenText 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

Below is a listing of all the currently available dates and locations for this course or workshop from OpenText.

To register, please select the course you want to attend by clicking the "Add to cart" button.

Date Course type Course name Language Location Price Add
Oct 14, 2019  On-site  Quickstart DBA  English  Hilliard, OH 3,500.00  Add to cart