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

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 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

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

Selection & Registration Process

Before you can register for a course or workshop, you need to select which one you want to attend. To do this, simply click on the "Add to cart" link and it will be added to your shopping cart.

Note: After clicking on the "Add to cart" link, you will be taken to the main course and workshop selection page where all of the courses and workshops you have added to your shopping cart will appear at the top of the page.

Once you have selected all the courses and workshops you want to attend, simply select the "Check-out link and complete the registration form.

Date Course Type Course Name Language Location Price Add
Apr 24, 2017  On-site  Quickstart DBA  English  Hilliard, OH 3,500.00  Add to Cart 
Oct 16, 2017  On-site  Quickstart DBA  English  Hilliard, OH 3,500.00  Add to Cart