Database Basics and the Need for Query
The Database Basics and the Need for Query course describes the IBM Query for i sort, report and analyze capabilities providing examples on how IBM Query for i is used to create business reports. Basic concepts relating to database structure and the data that can be accessed by IBM Query for i are explained in detail.
Personnel requiring knowledge about creating reports with the Query/400 facility.
Knowledge of IBM i concepts
After completing this course the student should be able to:
- Describe the tasks that can be performed by Query/400
- Identify the components that comprise a database
- Explain how database files and records are configured
What is Query?
The purpose of Query/400
Physical and Logical Files
How Files are Defined to the System
Data Description Specifications
Defining Record Formats
Record Configuration Examples
Description of the Example Database
Example Database Need
How the Database is Used
Database Basics and the Need for Query Mastery Test
Contact our Learning Consultants or call us at +44 (0) 1625 441120