Db2 13 – Introduction to Db2
The Introducing Db2 course discusses the platforms on which Db2 can be implemented, and the core features that can be found with all Db2 versions. You will look at common Db2 components and see how they are used to store and manage Db2 data. An overview of IBM Data Studio is also presented, explaining how it is used to work with relational database management systems such as Db2.
Db2 13 – Creating and Maintaining Db2 Programs
The Create and Maintain Db2 Programs course describes how SQL can be invoked from an application program and the interaction that can occur between the application program and Db2. Measuring the success of the SQL is then discussed, and the use of SQLCA, and SQLSTATE to determine this. You will then see how cursors can be used to reference table data, and finally how Db2 data is saved and recovered using commits and rollbacks.
Db2 13 – Building Db2 COBOL Programs
This course discusses the steps required to create Db2 COBOL programs.
Db2 13 – Optimizing Db2 Application Performance
The Db2 13 - Optimize Db2 Application Performance course describes the methods used by Db2 when processing application programs containing SQL, and provides details of the tools and utilities that can be used to measure and analyze their effectiveness.