G560: Major Topics

  • Relational database concepts
  • DB2 concepts
  • DB2I, SQL, and SPUFI
  • SELECT / UPDATE / DELETE / INSERT / MERGE
  • COMMIT / ROLLBACK
  • Joined and nested queries
  • Subqueries
  • Creating DB2 tables
  • DB2 objects
  • DB2 system catalog tables
  • SQL in application programs
  • Host variables and structures
  • DCLGEN and SQLCA
  • BIND / REBIND / FREE
  • Cursors and locks
  • Security and Authorization
  • EXPLAIN and efficiency considerations
×

Comments are closed.