Progress development best practices
Strategies to Minimizing record I/O
Database design
Request structure
Index usage
Query definitions
Index selection rules, for single and multiple index usage
Minimizing sub-transaction I/O
Database triggers
Auditing, tracking, and database replication
Dynamic programming concepts, and "semi-dynamic" coding
Persistent procedures, and inter-process communication
Programming methodologies
Request optimization vs system tuning
System tuning concepts
Buffer size
Database physical organization
Reorganization and index rebuilding strategies
Monitoring techniques