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.
Pricing
| Format | Currency | Price | ||||
|---|---|---|---|---|---|---|
| Per Student at Open Text Site: | USD | 3500 |
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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Jan 14, 2013 | On-site | Quickstart DBA | English | Hilliard, OH | 3500 | Add to Cart | ||||||||
| Apr 22, 2013 | On-site | Quickstart DBA | English | Hilliard, OH | 3500 | Add to Cart | ||||||||
| Aug 05, 2013 | On-site | Quickstart DBA | English | Hilliard, OH | 3500 | Add to Cart | ||||||||
| Oct 21, 2013 | On-site | Quickstart DBA | English | Hilliard, OH | 3500 | Add to Cart |
