UniVerse and Unidata Developer
The Developer course is available for both UniVerse and Unidata. It is
intended for users involved in application development and covers all
development areas of the core database product except for programming which
has a separate course. The course is also relevant for users in a system
administration or management role.
The course includes many practical exercises to explore the topics
presented and is accompanied by a detailed student manual which will be a
useful book for later reference.
The main topics covered are:
The multivalue data model. This module 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. This section is primarily intended
as revision for students who have not recently taken the Essentials course.
Dictionaries: I-type records. This module covers development of virtual
attributes stored in I-type dictionary items. The module includes all of the
basic concepts covered on the Essentials course and then builds on these to
explore the more advanced features of I-type expressions.
Query processing. This is the main 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 module also includes a brief discussion of related topics applicable to
system administrators and to application programmers.
The VOC file: Paragraph development. Building on the basic features of
paragraphs introduced in the Essentials course, this module explores inline
prompts, the DATA statement, conditional processing and loop constructs.
Menus. 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. This exercise brings together all topics from
this course and many from the Essentials course to take the student through
the process of designing a simple database together with reports and a menu