Db2 for z/OS Fundamentals and SQL Coding

PT24804
Training Summary
Come prepared to master Structured Query Language on the Db2 platform in this fast paced and hands-on course. The course begins with a discussion of relational concepts and terminology and quickly moves into a very practical discussion of data retrieval and manipulation using SQL. Each topic is reinforced with hands-on workshops. The workshops and examples in this course may be used across the Db2 family of products. This class may be taken in conjunction with the 2-day Db2 for z/OS Embedded SQL Programming class or the Advanced SQL for Db2 course.
Prerequisites
This course is designed for Programmers, Analysts, Database Administrators, and IT Managers who are exposed to, or are required to perform the activities associated with data stored in a Db2 relational database.
Duration
3 Days/Lecture & Lab
Audience
This course is designed for Programmers, Analysts, Database Administrators, and IT Managers who are exposed to, or are required to perform the activities associated with data stored in a Db2 relational database.
Course Topics
  • Relational Database Concepts
  • Basic Data Manipulation
  • Intermediate Data Manipulation
  • Built-in Functions
  • Aggregation
  • Joins
  • Data Modification
  • Complex Joins
  • SQL Subqueries
  • Set Operations

Related Scheduled Courses