G570: Major Topics

  • DB2 architecture
  • Data base design
  • Entity / Relationship Model
  • Normalization
  • Primary and foreign keys
  • DB2 objects
  • Creating Data Bases, Storage Groups, Table Spaces, Tables, Indexes, Views, Synonyms, and Aliases
  • VSAM file allocation
  • Referential integrity
  • DB2 catalog tables
  • Space estimates
  • Loading and unloading tables
  • Reorganizing table spaces
  • Backup and recovery
  • Data base tuning
  • Application tuning
  • Data Security
  • Distributed processing
×

Comments are closed.