Know Db2

Introduction to Db2 for z/OS and Structured Query Language

DETAIL COURSE OUTLINE - 1/2 Day Sessions

This hands-on workshop trains the Db2 Query User, Application Developer and DBA to code complex SQL statements to achieve optimum performance.

Duration: 4 day, 1/2 day sessions, Instructor led, Virtual Class with hands-on LABS. Half Day is approximately 2 hours of lecture and 2 hours of lab time.

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

Half-Day Session 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.
  • Allocating a data set for our exercises
  • Navigation in ISPF/PDF
  • How to submit a Job
  • Checking the job output in SDSF
  • What utilities we use in ISPF/PDF
  • Review Questions
  • End of ½ Day
  •  

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
  • Active and Archive Logs an purpose
  • Logging on to z/OS-the DB2I menu
  • Workshop-Lab exercises:
  • Working with the catalog tables
  • Creating Object structures
  • Db2 optimizer and basic data structures
  • Basics on Db2 objects:
  • -Data base, table space, table, indexes
  • Review Questions
  • End of 1/2 Day
  •  

SQL (Structured Query Language):

  • Logging on to z/OS and working with the
    DB2I menu
  • 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
  • Workshop - Lab Exercises:
  • -Writing DML SQL statements
  • -Review Questions
  • End of 1/2 day
  •  

SQL (Structured Query Language) Part II:

  • 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
  • DSQL coding and excution using SPUFI
  • Workshop - Lab Exercises:
  • -Writing DML SQL statements
  • -Review Questions
  • End of 1/2 day
  • Class Review
  •  
  •  
  • ©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.