|
|
SQL Fundamentals
» course outline
»
schedule
»
enrolment
»
 top
|
2-day hands-on class
This course will provide students with SQL skills needed to build simple or complex interactive queries against data which is stored in DB2 (or similar) databases. The course includes a comprehensive examination of the SQL language, including a progressive series of hands-on workshops to provide the student with experience in using the language.
|
Advanced SQL Workshop
» course outline
»
schedule
»
enrolment
»
top
|
2-day hands-on class
This course focuses on using the SQL language and DB2 for z/OS in the business applications environment. Through a combination of lectures and a progressive series of workshops, the audience will extend their knowledge of SQL and how it is used interactively and embedded in host language programs.
|
DB2 Overview
» course outline
»
schedule
»
enrolment
»
top
|
2-day lecture only class
This course is a basic introduction to Database/2 (DB2), IBM's Relational Data Base Management System. It will present the student with a comprehensive overview of the DB2 Product and how it relates to their current environment.
|
DB2/SQL Application Programming
» course outline
»
schedule
»
enrolment
»
top
|
3-day hands-on class
This course will provide delegates with the skills to code moderately complex applications using embedded SQL commands to access data stored in DB2 databases. Hands-on workshops are used to provide delegates with experience of using embedded SQL. The course examines design and performance considerations unique to SQL transaction processing in on-line environments.
|
DB2 Applications Performance/Tuning
» course outline
»
schedule
»
enrolment
»
top
|
4-day hands-on class
The course provides detailed coverage of DB2 Application Performance Tuning for DB2 4.1. It is intended for DBA’s, analysts and programmers. A good working knowledge of DB2 is a prerequisite.
|
DB2 Administration
» course outline
»
schedule
»
enrolment
»
top
|
4-day hands-on class
This course will cover DB2 Physical Storage, Data Definition, Application Programming Considerations, Load Related Utilities, Performance Issues, Referential Integrity Implications, DB2 Catalog, Security end Auditing, and the Backup and Recover Processes. Application programmers may find this course to be an excellent tool to sharpen their DB2 skills.
|
DB2 Operations and Recovery
» course outline
»
schedule
»
enrolment
»
top
|
4-day lecture only class
The course provides detailed coverage of DB2 for z/OS System Recovery and Restart. It is intended for DBAs, systems programmers and anyone responsible for system-wide recovery.
|
DB2 Logical Database Design
» course outline
»
schedule
»
enrolment
»
top
|
3-day lecture only class
This course will provide students with design skills needed to design relational databases. The course is based on the relational theory and is suitable for all platforms running relational or object relational databases such as DB2 and Oracle.
|
DB2 Advanced Programming Techniques
» course outline
»
schedule
»
enrolment
»
top
|
3-day lecture only class
This course will provide students with advanced programming skills and techniques in order to fully exploit the SQL language and all it?s functionality.
|
DB2 Internals
» course outline
»
schedule
»
enrolment
»
top
|
2-day lecture only class
The course provides detailed coverage of DB2 Internal behavior and data structures. It is intended for DBA?s but advanced analysts and programmers would also benefit. A good working knowledge of DB2 is a prerequisite.
|
VSAM Fundamentals
» course outline
»
schedule
»
enrolment
»
top
|
2-day hands-on class
VSAM (Virtual Storage Access Method) is the most popular file access method of IBM. As such, it is an area in which every System Programmer, DB2 Administrator and Application programmer will need some degree of expertise.
|
|
|
Accredited ISETT Education 
Training
