Course description: UniVerse Fundamentals 

Get an introduction to the UniVerse relational database environment. Learn about the tools and commands used to input data into storage files, modify data records, and extract the records to produce and print reports. Build a sample database application including data input through the UniVerse REVISE processor and reporting using the RETRIEVE processor. Create menus of stored reports and commands. Also, explore UniVerse commands that perform ad hoc queries, generate and print reports, and create stored procedures to gather business information. Learn the UniVerse RETRIEVE syntax as well as some American National Standards Institute (ANSI) standard SQL query usage.

Skills taught 

• Use common UniVerse commands
• Create data files and dictionaries
• Enter and update data records
• Use the UniVerse Record Editor (ED) to modify records
• Create prestored UniVerse commands (paragraphs)
• Create menus of commands
• Format and print simple reports
• Use RETRIEVE commands to access data records
• List and display the available data fields in a database file
• Create and print custom reports
• Define sentences and paragraphs with prompting for repetitive tasks
• Define I-Descriptors and correlatives for advanced reporting

Course outline 

• General orientation
• UniVerse editor
• UniVerse accounts
• UniVerse files
• UniVerse dictionary
• UniVerse Vocabulary (VOC) file
• ReVise
• RETRIEVE query language
• Advanced RETRIEVE
• Select lists
• Sentence stack
• Paragraphs
• Menus
• UniVerse database