Please select area for further details.
 Introduction to DB2 | Using SQL with DB2 Data Bases | DB2 Applications Programming | Home |
A two day course designed to give a basic understanding of the objects that form a DB2 data base, to extract information and satisfy simple queries. A prior knowledge of TSO would be advantageous.
 Data Base Technology | Evolution; Hierachical, network and relational DBMS's; Advantages and disadvantages |
| History of DB2 | Development of DB2 through the 80's; what has been incorporated in which releases |
| The relational Model | Data structure; Data integrity and validation; Data manipulation; Candidate and foreign keys; Referential Integrity; Introduction to SQL |
| How Data is Defined | Data definition Language; Definition of DB2 objects; Simple, segemented and partitioned table spaces; Create/delete/change DB2 objects |
| Data Manipulation | Data retrieval using SQL; SELECT statement; Unions and Joins; INSERT; DELETE; UPDATE |
| DB2 Catalog and Directory | Definition and use; Naming conventions; Systems tables; Information interrogation |
| Security and Authorisation | Data protection; Data Control Language; Ownership of DB2 objects; Use of Synonyms; Authorisation levels |
| DB2 Utilities | LOAD, REORG, RUNSTATS etc.; Use of DB2 to invoke utilities |
Extensive practical work, using SPUFI is used in this three day course to consolidate the topics discussed and enable the attendee to use interactive SQL. Prior attendance on the Introduction to DB2 course would help analysts, programmers, DBA's and end users who wish to come on this course.
| DB2 Objects | Table spaces, tables, rows, columns etc.; Candidate and foreign keys; Introduction to SQL |
| Defining DB2 Objects | CREATE statement; Candidate and foreign keys; Null clauses; DB2 referential integrity |
| Modifying DB2 Objects | ALTER and DROP statements |
| Indexes | Types; Creation; Defining; SUBPAGES clause |
| Making Querie | SELECT statement; Built in functions; Simple and complex queries; UNION; Subselects; Views |
| Expanding the SELECT | ORDER BY clause; GROUP BY clause; HAVING clause |
| Modifying DB2 Data | INSERT, DELETE and UPDATE statements |
| DB2 Catalog and Directory | Naming conventons,; Contents of systems tables; Interrogating information |
| Security and Authorisation | Data protection; GRANT and REVOKE statements; Using synonyms; Authorisation levels such as SYSADM, DBADB etc. |
| DB2 Utilities | IBM Utilities; DB21; LOAD; RUNSTATS; REORG |
| Locking Techniques | updates; COMMIT and ROLLBACK |
For those programmers who need to write programs accessing DB2 data this two day course is a must, as at the end of it they will have gained an in-depth knowledge of DB2 and be able to use embedded SQL in programs. A knowledge of Interactive SQL (as covered in Using SQL with DB2 Data Bases) and a minimum of one years programming experience is assumed.
| Interactive SQL | SQL statements and syntax; Use of SPUFI |
| Embedded SQL | Use of delimeters; Static and Dynamic; DCLGEN; The precompiler; DRBM; The bind process; Re-binding; SQLCA |
| Random updates | "One-off" updates using a primary key; Host variables; NULLS; COMMIT statement |
| Using a cursor | Why it is needed; definition and use; FETCH statement |
| Cursor Controlled updates | expanding the OPEN CURSOR statement; WHERE CURRENT OF clause; UPDATE and DELETE statements; COMMIT statement |
| Locking techniques | "Lost" updates; Types of lock; Lock modes and duration of locks; CS and RR; COMMIT and ROLLBACK statements |
| DB2 Utilities | IBM Utilities; DB21; LOAD; RUNSTATS; REORG |
| Performance considerations | Table design; Row size; Indexes; Data Type; EXPLAIN statement; RUNSTATS utility |
| Introduction to DB2 | Using SQL with DB2 Data Bases | DB2 Applications Programming | Home |
Please see our further information page for more details or call +44(0)1206 240647 to book any of these courses
 |
 |