Home >
DB2 for iSeries >
DB2 for iSeries Concepts & Facilities
DB2 for iSeries Concepts & Facilities
| Course Code: |
DBICF |
| Duration: |
1 day |
| Audience: |
DB2 developers and systems administrators.
|
| Prerequisites: |
At least six (6) months of IT experience.
|
| Summary: |
This presentation summarises the DB2 for OS/400 architecture, objects,
SQL programming facilities, SQL data definition facilities and the like.
This course is a prerequisite to the more extensive workshop-oriented courses,
SQL Essentials, for example.
|
| Objectives: |
Upon completion of this presentation, the participant should be conversant with all of
the following topics:
- DB2 architecture (e.g., query dispatcher, stat manager)
- Query processing components (e.g., optimiser, data access, primitives)
- SQL options (dynamic vs. static SQL)
- SQL objects (e.g., schemas, tables, views, constraints, triggers)
- User-defined functions
- Data types
- Constraints (e.g., referential integrity)
- Summary of data access methods (e.g., index options)
- Visual Explain - introduction
- Monitoring and tuning facilities
- iSeries Navigator
- Data Definition Language (DDL) - e.g., create DB2 objects
- Locking and concurrency (e.g., isolation levels)
- Catalog views
- Two-phase commit
- Utilities (e.g., IMPORT, EXPORT)
- Security options
|
