SQL is playing an ever-increasing IBM i role in enterprise database design, supplanting legacy DDS. This class shows you how to use industry-standard SQL Data Definition Language to build an IBM i database.
Recommended schedule: 2 day lab workshop
Who Should Attend This class is for existing RPG IV programmers who want to understand SQL Data Definition Language and its role in designing an IBM i database.
(Note: This class does not cover Data Manipulation Language or embedded SQL programming concepts. Those topics are also available as separate topics, or in a combined class: “Accessing Data, Database Design and Embedded SQL Programming.”)
Prerequisites In order to successfully complete this course, students should have completed the following courses, or have equivalent knowledge/experience:
IBM i Concepts and Programming Tools
RPG IV and the Integrated Language Environment
What You Will Accomplish At the end of the course, students will be able to:
Understand the structure of an IBM i database
Manage database privileges using SQL statements
Create a database using SQL statements
Alter a database using SQL statements
Use SQL to populate and repair data in an IBM i database
What You Will Receive Each student receives:
Custom printed handout, containing class notes
Completion certificate
Course Outline The class covers these topics:
SQL Overview
Creating Collections
Setting the Current Schema
Creating Tables
SQL Data Types
Setting the Primary Key
Altering a Table
Using Members
Adding Data to a Table
Creating Views
Creating Indexes to Improve Performance
Managing Privileges
Introduction to SQL Catalog
Hands-on Labs
Creating Collections
Creating Tables
Creating Views
Using Indexes
Limited Time!
Special pricing for the
Ontario area. Book a 5-day onsite class for as little as USD $900/day. Get a price quote today. Ask for offer CA900.
