DB2 11 for z/OS Application Programming Workshop
Explore this Global Knowledge course and ask the Bolt team for the detailed syllabus.
This course provides an introduction to the SQL language. This course utilizes IBM Data Studio on a Windows 11 operating system, but the SQL queries are appropriate for Linux, UNIX, and Windows environments. This course introduces SQL, including syntax, retrieving data from a Db2 table, coding inner joins, arithmetic operations, and scalar and columnar functions. Learners will also explore the UNION function, inserting, updating, and deleting rows, and will use the create table and create view statements. Additionally, learners will be introduced to advanced functions and performance optimization features in Db2 v12. Learners will participate in hands-on exercises to practice what they have learned.
After completing this course, learners should be able to:
Unit 1: SQL Introduction
Unit 2: Simple SQL Queries
Unit 3: Retrieving Data from Multiple Tables
Unit 4: Scalar Functions and Arithmetic
Unit 5: Column Functions and Grouping
Unit 6: Advanced Functions
Unit 7: Performance Optimization
Unit 8: UNION
Unit 9: Using Subqueries
Unit 10: Maintaining Data
No upcoming dates are listed yet. You can still enquire with flexible dates, and we’ll check options for your team.