Datatrain
Partners
Partners
Interskill Mainframe Training Newsletter - April ´17
Interskill Mainframe Training Newsletter - August ´16
Interskill Mainframe Training Newsletter - June ´15
Past Issues

Partners
Mainframe Links
Mainframe Facts - Did you know?



DidYouKnow


More facts...

Course Catalog » IBM Power Systems - IBM i Curriculum

Database Basics and the Need for Query

Duration
4 hours

Overview

Description

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 IBM Query for i 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 IBM Query for i
  • Identify the components that comprise a database
  • Explain how database files and records are configured

Course Content

What is Query?

The purpose of IBM Query for i

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

Course Catalog » IBM Power Systems - IBM i Curriculum
 
 
 
  © All rights reserved. Interskill Learning Pty Ltd.
  HomeAbout UsProductsDemonstrationCourse CatalogContact UsSite Map
      Interskill IBM