Db2 Fundamentals Courses





Db2 Fundamentals Courses at EMEA23

Registration for the onsite z/OS FUNDAMENTALS or LUW FUNDAMENTALS course gives you exclusive access to Fundamentals!  Optional badging / certification testing will be offered AT the conclusion of the course. Take advantage of Fundamentals AND benefit from the IDUG 2023 EMEA Db2 Tech Conference experience! 


Fundamentals courses are only offered onsite. Please note that you must remain in the track you have registered for – z/OS or LUW.


Db2 for z/OS Fundamentals Course

Experience the IDUG conference while working on your fundamentals skills! The Db2 Fundamentals for z/OS Course typically  runs alongside traditional technical and breakout sessions and allows participants to master Db2 fundamentals while taking part in IDUG 2023 EMEA Db2 Tech Conference activities. This four-day for-beginners Db2 z/OS basic course is designed for z/OS database administrators who need to acquire the basic skills required to administer a Db2 database in a z/OS environment. Db2 12 for z/OS beginning DBAs can develop fundamental skills or recognition through lectures and hands-on exercises of:

  • TSO/E and ISPF
  • JCL and SDSF
  • Data Sets
  • Db2 Utilities
  • Db2 Objects
  • Db2 Logging
  • Structured Query Language
  • Db2 Program Preparation
  • Db2 Commands

Db2 for LUW Fundamentals Course

Experience the IDUG conference while working on your fundamentals skills! The Db2 Fundamentals for LUW Course typically runs alongside traditional technical and breakout sessions and allows participants to master Db2 fundamentals while taking part in IDUG 2023 EMEA Db2 Tech Conference activities. This four-day for-beginners Db2 LUW basic course is designed for individuals who will plan, implement, and maintain Db2 11.5 for Linux, UNIX, and Windows databases. These skills can also be utilized to support cloud based databases using Db2 on Cloud or Db2 Hosted environments

Topics will include: 

  • Overview of Db2 11.5
  • Locking and concurrency   
  • Db2 Command Line Processor (CLP) and GUI tools
  • Security
  • The Db2 database manager instance
  • Database rebuild support   
  • Creating databases and data placement   
  • Db2 database and tablespace relocation
  • Creating database objects       
  • Using Explain tools
  • Moving data 
  • Using indexes for performance 
  • Backup and recovery  
  • Advanced monitoring
  • Database maintenance, monitoring, and problem determination