Training

We offer the following workshops for in house training only. You can choose among the different themes and create your own individual workshop. If you do not find all the themes you are interested in, please ask us for a special offering.

Our Themes

• Databases
  • Data modeling and application development
  • Training for ORACLE und DB2
  • Know how from the Silicon Valley,
    A training for insiders about dynamic SQL with DB2 for OS/390 and z/OS

• CA DB2 tools

• Basic Knowledge

Data Modeling and Application Development

M01

Design and Implementation of Data Models

Send message to Education Services

5 days

M02

Methods of Data Modeling

Send message to Education Services

2 days

Database Training for ORACLE and DB2

DB01

Basics - Relational theory, data definitions, data manipulation using SQL

Send message to Education Services

3 days

DB02

SQL-Highlights - Complex queries, joins, triggers, stored procedures, Large Objects, user defined functions for DB2 or Oracle

Send message to Education Services

2 days

DB03

Application development (C or COBOL) - Embedded SQL, error handling, dynamic SQL, Precompilers, other APIs, special considerations

Send message to Education Services

3 days

DB04

Performance analysis and tuning - Access path analysis, Optimizer strategies, isolation levels, locks, deadlocks, monitoring performance

Send message to Education Services

2 days

DB05

Distibuted Computing - basics of distributed databases, partitioning, replication, two-phase-commit, client-server-computing, distributed computing, function shipping

Send message to Education Services

1 day

DB06

Experiences from Silicon Valley:
A training for insiders about dynamic SQL with DB2 for OS/390 and z/OS.
Content:

• Where do find dynamic SQL?
• Embedded DSQL, ODBC, JDBC -
• How does Statement Caching work?
• KEEPDYNAMIC: YES or NO?
• Monitoring
• Explain

Send message to Education Services

DB07

Performance Tuning of DB2 applications for experienced application developers and database administrators

Send message to Education Services

5 days

CA DB2 Tools

Individual workshops for the DB2 tools of Computer Associates:

• Plan Analyzer: SQL tuning in Application development
• Database Analyser: Automation of database administration procedures
• RC/Migrator: Change management of DB2 objects
• RC/Update: Changing DB2 objects and data

education@puerner.com

Send message to Education Services

Basic Knowledge

A02

LINUX - Overview, prozesses, file system, Shells, X-Windows, application development

Send message to Education Services

2 days