Interskill Learning Mainframe Training

770-872-4278

The Online Mainframe Training Specialists
Search   Course Catalog   Live Chat!  
Return to Catalog Home     Return to Curriculum Listing

Database Basics and the Need for Query

Duration

4 hours

Overview

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.

Audience

Personnel requiring knowledge about creating reports with the Query/400 facility.

Prerequisites

Knowledge of IBM i concepts

Objectives

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

Course Content

What is Query?

The purpose of Query/400
Report Formats

Database Concepts

Physical and Logical Files
Records
Record Fields
Field Types
Primary Keys

How Files are Defined to the System

Data Description Specifications
Defining Record Formats
Field Specifications
Record Configuration Examples

Description of the Example Database

Example Database Need
File Structure
Record Values
Keys
How the Database is Used

Database Basics and the Need for Query Mastery Test

Looking for more information about Interskill Learning Products?
Contact our Learning Consultants or call us at 770-872-4278