This class combines the content from the Accessing Data Using SQL, Database Design Using SQL, and RPG IV Programming with Embedded SQL classes into one comprehensive week of SQL training.
SQL is playing an ever-increasing role in the IBM i operating system (aka iSeries, AS/400) in enterprise database design, supplanting legacy DDS. This class shows you how to embed SQL statements into your RPG IV programs to combine the best of SQL and RPG IV. It also introduces the concept of SQL stored procedures.
SQL is playing an ever-increasing role in the IBM i operating system (aka iSeries, AS/400) in enterprise database design, supplanting legacy DDS. This class shows you how to use industry-standard SQL Data Definition Language to retrieve, analyze and modify the data in an IBM i database.
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.
This hands-on lab shows you how to use Data Definition Specifications to create an IBM i database. The class covers database from start to finish, including the relational database model, physical files, logical files, join files, and field reference files.