logo
Powered by QM on a Rpi server
Home
About OpenQM
Sales and Downloads
Help and Support
About
Login

UniVerse and Unidata Introduction

This is one of our most popular courses.

The Introduction course is available for both UniVerse and Unidata. It covers much of the same material as the Essentials and Developer courses but in a little less depth. The course is intended for users who will be working in a development role and includes many practical exercises to explore the topics presented.

The course materials include a detailed student manual which will be a useful book for future reference.

The main topics covered are:

The multivalue data model. This section discusses the general relational database model and the extensions to provide the multi-valued fields that make this database so powerful and easy to use.

The command environment. This module explores the concepts of accounts, the important system files, command syntax and the command stack editor.

The file system: File types and sizing. This module introduces the student to the different types of file and explains why they are necessary and how to choose the appropriate type for each file. The module includes discussion of how each file type operates and a brief description of the process of setting file configuration parameters.

The Editor. All users need a good basic understanding of the editor even if they will use other editing tools for most of their work. In this module we meet the most important editor commands and see how they allow us to create and modify data stored in database files.

The VOC file: Overview. This module describes each of the VOC record types and explains how they work. Emphasis is placed on how users can extend or modify the VOC file to meet their own needs. Discussion of paragraphs is restricted to those that execute a simple sequence of sentences. The standard LOGIN, ON.EXIT and ON.ABORT paragraphs are also discussed.

Dictionaries (D, A and S-type records). This module explores the role of the database dictionary and examines each of the dictionary record types. The most important conversion and format codes are discussed. Although concentrating on D-type data definitions, A and S type items are discussed in the notes and can be taught for clients who use them.

Dictionaries: I-type records. This module covers development of virtual attributes stored in I-type dictionary items.

Query processing. This is the longest module of the course and covers all of the major features of the query processor. Built around many example queries and practical exercises, the module explores the query processor verbs, the selection clause, the sort clause, the display clause, and reporting options. Field modifiers, arithmetic operations and breakpoints are discussed in detail. The module also includes an extensive discussion of select lists and the associated commands.

Alternate key indices. This module discusses the substantial performance improvements that can be achieved by use of alternate key indices. The procedures for creating, testing and deleting indices are discussed together with a description of how indices are used by the query processor.

The VOC file: Paragraph development. Building on the simple paragraphs introduced in an earlier module, this module explores inline prompts, the DATA statement, conditional processing and loop constructs.

Menus (four day format only). This module discusses the types of menu and their components. Creation and maintenance of menus using the menu processor is explored in detail. There is also a brief discussion of Motif style menus (UniVerse only).

Database design exercise (four day format only). This exercise brings together all topics from this course to take the student through the process of designing a simple database together with reports and a menu front end.