Know Db2

Introduction to Db2 for z/OS and Structured Query Language

This instructor led virtual tutorial introduces Db2 for z/OS and the Structured Query Language (SQL).

Duration: Two day, Instructor led, Virtual Class.

Audience: This course is primarily directed toward new users of Db2 for z/OS and SQL basic coding.

Prerequisites: Basic computer concepts, and basic knowledge about relational data management systems.

Workshops: z/OS platform will be used to run class problems coded by the students.

Course Objectives: After successful completion of this course, the student will be able to describe relational database management system concepts, the basic structures in a Db2 for z/OS subsystem and write basic SQL statements.

Introduction to Db2 for z/OS and Structured Query Language
Class Outline:

Relational Database Management Systems:

  • 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 and 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
  •  

SQL (Structured Query Language):

  • 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
  • SQL coding and execution using SPUFI
  • Workshop - Lab Exercises:
  • -Writing basic DML SQL statements
  • -Review Questions
  •  
  •  
  • ©2017 Computer Business International, Inc.

Would you like to schedule or customize this class?
Please call our toll free number (866-224-4968) or email us at info@cbi4you.com.