Courses we teach: DB2
DB2 Concepts and
Facilities - 2 days
DB2 Management Overview - 1 day
DB2 Application Programming - 5 days
Advanced DB2 Application Programming - 5
days
DB2 Tuning and Performance - 5 days
DB2 Operations - 3 days
SQL Query Building in DB2 - 2 days
QMF For Programmers - 3 days
SQL Coding Workshop - 3 days
QMF for SQL Developers - 1.5
days
DB2 Database Administration - 5 days
DB2 / CICS Interface - 2 days
DB2 Version 6 Differences - 3 days
DB2 Version 7 Differences - 2 days
DB2 Version 5 to Version 7
Transition for Developers - 2 days
DB2 Version 5 to Version 7
Transition for Data Base Administrators - 3 days
DB2 Version 8 Differences - 3 days
DB2 Version 9 Differences - 3 days
Advanced SQL Query Building - 2 days
DB2 Dynamic SQL - 1 day
DB2 Stored Procedures - 2 days
DB2 (Data Base 2) is IBM's relational database product. Although originally developed for the MVS, OS/390, z/OS platform, IBM now has DB2 versions available to run on Windows, Unix, Linux, and more.
A relational database is a collection of data stored in tabular form (rows and columns) that follow the rules of organization first delineated by E.F. Codd. A column designates a unit of data, such as name, customer number, or unit cost of an item. Each row designates an entity being kept track of, for example an employee, a customer, an item in inventory.
Two or more tables may be related (hence the term "relational database") by a common column. For example, a table of employees may relate to a table of company departments by a department number column (in the employee table, the department number column designates which department the employee works for; in the department table, the department number column identifies each department; thus, given an employee name or number, you can find out about the department the employee works in; or, given a department number, you can construct a list of all the employees who work in that department).
The path to DB2 data is a specialized language called SQL (Structured Query Language; "SQL" is pronounced as the letters "S-Q-L" or as "see-kwel"). Programmers, developers, or users can issue SQL statements using DB2I / SPUFI (DB2 Interactive / SQL Processor Using File Input) or QMF (Query Management Facility) or by embedding SQL statements in programs written in COBOL, PL/I, C, Assembler, and so on.
Programs containing embedded SQL statements may run in batch or under TSO, CICS, or IMS.
The course "DB2 Application Programming" is our main DB2 course for programming professionals. It covers DB2 and SQL concepts, the SPUFI process, and how to embedd SQL statements in programs.
"DB2 Concepts and Facilities" and "DB2 Management Overview" are introductory courses for people who just need an overview. The first course has labs, the second one does not.
"Advanced DB2 Application Programming" presents more sophisticated SQL techniques, goes deeper into understanding the implications of design choices (index types, query styles, packages and plans, normalization), loading tables, stored procedures, distributed data access, and dynamic SQL statements.
"DB2 Tuning and Performance" provides the programmer or data base administator with the knowledge and skills to understand performance implications of SQL. In addition, it shows how to adjust either an SQL statement, or the containing environment to improve performance. Techniques for utility, security, and design performance improvement are also presented.
"DB2 Operations" is designed to help operational personnel work with DB2 commands, utilities, and resources. In addition to including an overview of DB2 concepts, the course provides hands on exercises for DB2 operators.
"SQL Query Building in DB2" introduces the non-programmer to SQL, in the context of on-line access to DB2 tables using QMF. The basic concepts of relational data bases are discussed, along with the techniques for utilizing QMF to retrieve and present information.
"QMF for Programmers" presents the fundamentals of SQL access to DB2 tables from within the QMF environment. The course is intended for programmers, and includes both data access and data modification SQL statements. In addition, the facilities of QMF for report formatting, and for procedural programming are discussed.
"QMF for SQL Developers" is for experienced SQL coders who need to know how to use QMF facilities to format SQL requests.
"SQL Coding Workshop" presents the fundamentals of SQL access to DB2 tables from within the SPUFI environment. The course is intended for programmers, and includes both data access and data modification SQL statements. A discussion of data definition, and the DB2 catalog is also included.
"Advanced SQL Query Building" consists of the more sophisticated SQL techniques contained in the Advanced DB2 Application Programming course, and includes the SQL tuning discussion from the DB2 Tuning and Performance class, as well.
"DB2 Database Administration" is intended to provide data base administrators (DBAs) with the knowledge and skills necessary to define, manage, and tune DB2 data bases. The course introduces the techniques of Entity-Relationship Diagrams and Normalization. This is followed by the DB2 SQL statements for DB2 object definition (CREATE, DROP, and ALTER), and the utilities used by DBAs to load, reorganize, recover, and manage DB2 tables.
"DB2/CICS Interface" presents the details of establishing and maintaining connections between CICS (a common teleprocessing monitor) and DB2. The course includes a discussion of the interaction between data base access and pseudo-conversation programming techniques. This course has recently been updated to reflect changes in the products.
"DB2 Version 6 Differences" presents what is new and different in Version 6 of DB2. Included are such topics as: new built-in functions, shcema; user-defined functions; SQL Procedures Language; stored procedures enhancements; triggers; BLOBs, CLOBs, and DBCLOBs; REXX language support, and much more.
"DB2 Version 7 Differences" presents what is new and different in Version 7 of DB2. Included are such topics as: the advent and impact of Unicode, new and changed SQL statements, z/OS impacts, operational enhancements, utilities enhancements, changes in JAVA support, and much more.
"DB2 Version 5 to Version 7 Transition for Developers" many installations skipped DB2 Version 6 and went (or are going) right from Version 5 to Version 7; this course provides a fast track update to the essential changes introduced in this transition, from the perspective of DB2 application developers.
"DB2 Version 5 to Version 7 Transition for Data Base Administrators" many installations skipped DB2 Version 6 and went (or are going) right from Version 5 to Version 7; this course provides a fast track update to the essential changes introduced in this transition, from the perspective of DB2 DBAs.
"DB2 Version 8 Differences" describe the impacts of this major change to DB2, including the use of Unicode in the catalog tables, support for XML, and extensions to stored procedures.
"DB2 Version 9 Differences" describe the impacts of this major change to DB2, including the support for zIIPs, new kinds of triggers, clone tables, universal table spaces, new data types, and enhancements to utilities and commands.
"DB2 Dynamic SQL" shows how to build and execute SQL statements on the fly, for the ultimate flexibility in working with DB2 tables.
"DB2 Stored Procedures" explores how to code and use SQL-based code that can be requested from the host and run on the client.
this page last updated: 22 March, 2008
Copyright © 2008 by The Trainer's Friend, Inc.