¿Qué quieres aprender?

OL620ES ::: DB2 for i: DB Coding and Implementation Using DDS ...

OL620ES ::: DB2 for i: DB Coding and Implementation Using DDS and CL Commands

LUZ Tecnologías de la Información

Curso presencial

Madrid


980
+ IVA

Objetivos Code the DDS and create the physical and logical files necessary to implement a DB2 UDB for i relational databaseDescribe the advantages of a field reference file, code the necessary DDS and create a field reference fileExplain how the choices made while coding the DDS and creating the file affect the performance of the system and the programs using the filesDescribe the considerations for using the DB2 UDB for i referential integrity and triggers Audiencia This is a basic course for individuals who create and maintain a DB2 UDB for i database.

¿Quieres hablar con un asesor sobre este curso?

Sedes

Localización

Fecha inicio

Madrid

Requisitos

Requisitos You must be able to:Use Program Development Manager (PDM) and Source Entry Utility (SEU) to enter source code into a source fileUse PDM to create an IBM i object from a source file memberExplain the function of DDS in defining files on the iUse Data File Utility (DFU) to maintain a physical file

Temario completo de este curso

Temario

  • The relational database model
  • Creating physical files
  • Creating logical files
  • Database performance considerations for application design
  • Database maintenance
  • DB2 UDB for i referential integrity
  • DB2 UDB for i triggers
  • The relational database model
  • Creating physical files
  • Creating logical files
  • Database performance considerations for application design
  • Database maintenance
  • DB2 UDB for i referential integrity
  • DB2 UDB for i triggers

Ver más