Learn how to use advanced SQL features and syntax that can be leveraged from any programming language that supports SQL. Learn about advanced SQL DDL (Data Definition Language) features such as identity columns and constraints that enable data-centric programming. Learn how to take your SQL reports and query definitions to the next level with views, common table expressions, and OLAP specifications. Learn how to use SQL procedurally with user-defined functions, triggers, and advanced stored procedures.
This workshop provides lectures and hands on labs in a face-to-face classroom setting. The labs exclusively use the IBM i Navigator graphical interface.
Test drive videos
Audience and prerequisites
This advanced workshop is for experienced IBM i (including iSeries and AS/400e) programmers who design and write applications that use SQL to access the database.
You should complete the following courses (or have the equivalent skills taught in these courses):
Interested in future scheduling or a custom onsite workshop, contact IBM Systems Lab Services and Training.