DB2 for z/OS SQL Advanced Course

Course Code: RT 319
Course Abstract:

In this course, participants will review SQL - Basic Select, Scalar Functions, Joins, SubQueries, Unions, and Insert/Update/Selects.  They will also learn and practice features of the current version of DB2 and look into the next version of DB2.

Audience:

This course is designed for experienced data processing personnel who have used SQL and need to refresh / deepen their current skills and learn and use "advanced" SQL topics.

Duration: 2 days
Learning Outcomes:

Upon completion of this course, the participant will be able to:
> SELECT rows of data from DB2 tables
> Use QMF and/or SPUFI  to "run" SQL statements
> Use the WHERE clause to SELECT specific rows of a DB2 table
> Build queries using the ORDER BY, GROUP BY, HAVING clauses
> JOIN tables together to get information from each
> "Change" tables using the INSERT, UPDATE, DELETE statements
> Describe the security provided by the GRANT and REVOKE
> Discuss the design considerations of REFERENTIAL INTEGRITY
> Discuss overall DB2 PERFORMANCE considerations
> Run the EXPLAIN PLAN SQL statement and analyze results
> Discuss additional SQL features of the latest DB2 Feature
> Review the DB2 Catalog and Runstats Utility
> Discuss Concepts in DB2 Efficiency
> Discuss the DB2 Explain and Visual Explain
> Discuss other Advanced Topics - Recursive SQL, Group By – CUBE, ROLLUP

Course Topics:

DAY 1
Review of DB2
Course Introduction
DB2 - Concepts, and Terminology
Structured Query Language (SQL)
SQL 1 - The SELECT Statement
Database 2 Interactive
SQL 2 - Special Features
SQL 3 - ORDER BY, GROUP BY, HAVING
SQL 4 - Join, Sub-select, UNION
SQL 5 - Data Definition Language
SQL 6 - INSERT, UPDATE, DELETE
SQL 7 - Data Control Language
SQL 8 - Other SQL Topics
Hands-on Lab - SQL Review and Refinement
Question and Answer Session

DAY 2
DB2 Performance Considerations - Overview
DB2 Catalog and Runstats
Concepts In DB2 Efficiency
DB2 Additional features - User Defined Distinct Types / User Defined
Functions (Appendix K), Triggers (Appendix M), New Scalar/Column
Functions (Appendix J)
Other Advanced Topics - CUBE, ROLLUP, GROUPING SETS
Other Advanced Topics - Recursive SQL
Hands-on Lab - SQL Review and Refinement

Appendices
Appendix A - IBM Sample Tables Appendix I - "Common" SQL Errors
Appendix B – Bibliography Appendix J – Version 6 Functions Summary
Appendix C -  DB2 SQL Advanced Workshop Appendix K – User Defined Data Types (UDT) and User Defined Functions UDF
Appendix D – EXPLAIN PLAN Statement and PLAN_TABLE and DSN_STATEMNT_TABLE Appendix L - Cast Testing
Appendix E – Hints to Success Appendix M - Trigger Introduction
Appendix F – SQLCODES / SQLSTATES Appendix Z6 - DB2 Version 6 Summary
Appendix G – QMF Overview Appendix Z7 - DB2 Version 7 Summary
Appendix H – Stored procedures – Version 5

Prerequisites:

At least six months experience using DB2 SQL.

Note: All fields are required
At the present time we do not offer training for individuals or groups less then 6 individuals. We apologize for any inconvenience.


We Value Your Privacy!

Ready to get started or in need of more information? Contact us today.

Go To Blog Virtual Learning

Testimonials

Excellent training that covered current Cisco IOS and routing and switching technologies. We also covered how to subnet, supernet, and use CIDR which was invaluable to putting our design into place. The instructor did an excellent job in teaching the CCNA class. I have been struggling to understand subnetting and networking. This class brought it all together for me.

–Student