|Workshop code||DB2iAdvSQLPgm||Skill level||Advanced|
|Duration||3 days||Delivery type||Classroom|
|Workshop type||Public or Private on-site||Start date||9 September 2014|
|Public price||USD $1,200 plus tax||Location||Rochester, MN|
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 advanced workshop 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):