Rocket Training and Services

Overview

This self-paced, online course provides those new to the U2 (UniData and UniVerse) extended relational database environment with hands-on experience. There are no prerequisites.

During this class, participants will:

• Build a database file and add records to it
• Create and edit a data dictionary file
• Use the VOC file
• Build queries and select lists, and merge two lists together
• Use paragraph syntax to run sequential processes
• Use basic administration commands
• And much more!

Duration

This course takes about 4 days to complete. Participants will review audio-based online modules, answer knowledge check questions, and complete a variety of learning activities that will give them practical experience using the databases.

Cost

This course is free to those with an active maintenance contract on UniData or UniVerse. Participants must have a valid UniData or UniVerse serial number available to register.

• US/Canadian Customers: https://rbc.rocketsoftware.com/
• International Customers: https://rbcint.rocketsoftware.com/

Click U2 Fundamentals Online Course to access the course. Download a free trial version of UniData or UniVerse.
If you do not have an active maintenance agreement and would like to access this course, please contact your sales and renewal associate.

Purpose

This course provides an introduction to the U2 (UniData and UniVerse) extended relational database environment. Build a sample database file, including creating a data dictionary, entering data input through the editor and building queries against that data. Explore commands that perform ad hoc queries. Learn about and create paragraphs used for sequential processing and efficient report generation.  Explore advanced topics, including running background processes and basic exploration commands for the environment.

Audience

End users, managers, system administrators, and programmers who are new to the U2 database environment and need to understand basic concepts and usage including database queries.

Prerequisites

None

Objectives

After completing this course, you should be able to:

• Understand the U2 environment
• Log in and log out
• Use the on-line Help facility
• Execute basic query commands
• Understand U2 file structure
• Create a data file and add records to it
• Learn basic concepts of the line editor and BDT (full screen editor)
• Create and edit dictionaries
• Use the VOC file
• Add virtual attributes that perform mathematical calculations and lookup data from other files
• Create select lists and merge two lists together
• Use basic administration commands like LOGTO and STATUS
• Explain secondary indexes and identify when they exist on a file
• Use paragraphs to execute sequential processes