DB2 UDB Custom Course

PT3709
Prerequisites
Students must have good working knowledge of relational database technology.
Duration
3 Days/Lecture & Lab
Course Topics
  • Understand the DB2 environment
  • Understand implementation of referential integrity including proper delete rule selection
  • Understand basic and advanced SQL coding syntax
  • Understand DB2 physical structure including indexes
  • Create views
  • Code SQL statements that manipulate and define DB2 tables and execute them interactively
  • Design and code SQL statements for performance
  • Learn what DB2 Catalogs are available and their purpose
  • Learn application-coding considerations for DB2
  • DB2 Overview
  • Basic Data Manipulation
  • Advanced Data Manipulation
  • Update Data Manipulation
  • Data Definition Language
  • Data Control Language
  • Application Program Considerations
  • DB2 Catalogs for Programmers
  • SQL Coding Considerations

Related Scheduled Courses