G502: Major Topics

  • DB2 features
  • Relational data base concepts
  • DB2 objects
  • The DB2 catalog
  • Relational operations: SELECT, PROJECT, and JOIN
  • DB2 data types
  • Referential integrity and normalization
  • SQL data manipulation introduction: SELECT, UPDATE, DELETE, INSERT commands
  • SQL data definition introduction: CREATE, DROP, ALTER commands
  • SQL data control introduction: GRANT, REVOKE
  • DB2 application development: pre-compile, compile, bind, link, execute
  • Host variables

Comments are closed.