This course is not scheduled.
To register interest for this course, remember the course code and choose "request a specific course" from a partner.
|Course code||OL390||Skill level||Advanced|
|Duration||3.0 days||Delivery type||Instructor led
|Course type||Public or Private on-site|
|Public price||See Partner website|
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 (On-Line Analytical Processing) specifications. Learn how to use SQL procedurally with user-defined functions, triggers, and advanced stored procedures.
This course provides lectures and hands on labs in a face-to-face classroom setting. The course is also offered in a live virtual classroom environment (ILO -Instructor Led Online) with hands-on labs: DB2 for i Advanced SQL Programming - ILO (OV390).
Training Paths that reference this course are:
This advanced course is for experienced Power System with 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):