In DB2 for i Advanced SQL Programming training course, delegates learn about advanced SQL DDL (Data Definition Language) features such as identity columns and constraints that enable data-centric programming. They learn how to take the 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.
By attending DB2 for i Advanced SQL Programming workshop, Participants will learn to:
- Defining advanced SQL DDL syntax when creating tables and indexes to leverage DB2 for i data-centric features
- Advanced query features such as common table expressions, views, subqueries, and OLAP specifications on SQL DML (Data Manipulation Language) statements
- Advanced join and hierarchical processing with SQL DML
- Define and code SQL triggers
- Define and code SQL user-defined functions
- Code advanced features of SQL procedures, including error handling and passing result sets
- Integrating DB2 and XML data with SQL
This 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.