SQL is the standardized language for defining and manipulating data in a relational database. SQL is the recommended interface from applications into your data on IBM i. And SQL views can access and alter system services procedures, and functions on IBM i.
In short, it is imperative to know SQL.
This bootcamp defines Structured Query Language (SQL) as supported by Db2 for IBM i. It contains basic reference information for the tasks of system administration, database administration, application programming, and operation.
This bootcamp will be delivered in semi-weekly presentations, from November 6, 2023 until January 15, 2024.
The Power of SQL on IBM i, Scott Forstie — 11/6/2023SQL DDL – Create Table – Basics, Sue Romano — 11/13/2023SELECT Statement Basics, Vern Hamberg — 11/27/2023Scalar Functions & Date/Time Calculation, Birgitta Hauser — 12/4/2023Data Manipulation, Sven Jansson — 12/11/2023Group By / Having, Mike Zaringhalam — 12/18/2023Joining Tables, Ryan Moeller — 1/8/2023 Next Steps – A Little Bit Beyond the Basics, Scott Forstie — 1/15/2024All sessions will appear on the CONTENT tab of this page at 10:00 am CT on the date indicated. Register now and return here on the premier dates to access the content. Read More