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
