We are a family owned USA based Corporate Training Company determined to help professionals, teams, and organizations improve.

Let us help you find the training program you are looking for.

If you can't find what you are looking for, contact us, we'll help you find it. We have over 800 training programs to choose from.

banner-img
Home » Database » Introduction to Db2 for z/OS and Structured Query Language

Course Skill Level:

Foundational

Course Duration:

2 day/s

  • Course Delivery Format:

    Live, instructor-led.

  • Course Category:

    Database

  • Course Code:

    DBISQLN22J02

Who should attend & recommended skills:

New users of Db2 for z/OS

Who should attend & recommended skills

  • This course is primarily directed toward new users of Db2 for z/OS and SQL basic coding, with basic z/OS, TSO, ISPF, and SDSF; sequential, partitioned, and VSAM data sets; JCL skills z/OS, TSO, ISPF, and SDSF: Basic (1-2 years’ experience) Sequential, partitioned, and VSAM data sets: Basic (1-2 years’ experience) JCL: Basic (1-2 years’ experience)

About this course

This instructor led virtual class introduces Db2 for z/OS and the Structured Query Language (SQL).
Workshops: z/OS platform will be used to run class problems coded by the students.

Skills acquired & topics covered

  • After successful completion of this course, the student will be able to:
  • Describe relational database management system concepts
  • Describe the basic structures in a Db2 for z/OS subsystem
  • Write basic SQL statements

Course breakdown / modules

  • Mainframes systems overview
  • Using Db2 on z/OS system basics
  • Logon / Logoff a TSO/ISPF session
  • Allocate sequential/partitioned dataset
  • Workshop – Lab Exercises:
  • Logging on to z/OS and allocating a data set to use in our exercises.

  • Db2 on z/OS:RDBMS concepts
  • Overview of Logical Data Modeling
  • Overview of Physical Data Modeling
  • Architecture and structure of Db2 on z/OS
  • Catalog tables in Db2
  • Directory tables in Db2
  • BSDS (boot strap data set) uses
  • Db2 optimizer and basic data structures
  • Basics on Db2 objects:
  • Data base, table space, table, indexes
  • Active / Archive Logs and purpose
  • Workshop – Lab Exercises:
  • Logging on to z/OS and working with the DB2I menu
  • Workshop – Lab Exercises:
  • Execute on Db2 for z/OS, coded SQL statements to query the catalog tables and answer object structure questions

  • Basic introduction to the language
  • DDL, DCL, DML introduction
  • Coding DML:
  • SELECT, INSERT, UPDATE, DELETE
  • SELECT statement overview
  • SELECT Syntax and structure
  • Coding predicates in a SELECT
  • Predicate types
  • Basic Joining techniques
  • Basic review and coding of SQL join types
  • INNER JOIN
  • OUTER JOIN
  • LEFT JOIN
  • RIGHT JOIN
  • Coding Simple sub-SELECTs
  • Coding UNION statements
  • Coding for performance and why
  • The Optimizer and path choices for SQL
  • Packages and Plans overview
  • Techniques to tune SQL
  • EXPLAIN overview
  • PLAN_TABLE review
  • DB2I Menu in TSO
  • Data Set use in DB2I

Browse our programs to take the next step toward advancing yourself, your team, and organization.

Browse Courses