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