About ABIS
All CoursesbalkjeGeneral » Introduction to HW & SW » Soft skills » TracksOperating systems » MVS - z/OS » UNIX - Linux - AIX » Mac OS X » iPad and iPhone iOSDatabases and middleware » Relational databases & SQL » DB2 for z/OS » DB2 for LUW » Oracle » SQL Server » MySQL & MariaDB » IMS » CICS » IBM MQ » WebSphere » Big data and analyticsApplication development » Methods and techniques » TOGAF » PRINCE2 » Agile development and Scrum » Programming languages » Internet development » Object Oriented systems » Java » Development tools » SAS » XML » SOA & web servicesSystems management » ITIL » SecuritybalkjePractical informationRegistration 
DB2 for LUW fundamentals course


DB2 for Linux, Unix and Windows (DB2 for LUW in short; previously also called DB2 UDB) is a database platform of IBM. (For the IBM mainframe platform, see DB2 for z/OS fundamentals course instead.) This course is on level with version 10.5.In this the course the participant learns:

  • the set-up of the DB2 for LUW (Linux, UNIX and Windows) product;
  • a short intro to Data Studio as a client tool;
  • the DB2 objects for data storage and manipulation;
  • the simple definition of databases and tables;
  • the client set-up and the catalogue of databases.

This course combined with the course SQL and relational databases fundamentals gives you a complete view on DB2 for LUW as an RDBMS and learns you the basic skills to get going with this data platform.

Main topics

  • The DB2 for LUW family- An overview
  • DB2 Server products • New in V10.5 • DB2 Data Servers • Data Clients/Drivers
  • DB2 Tools
  • DB2 (Administration) Command Line Tools • Intro to Data Studio • DB2 scripting
  • Data Definition in DB2 for LUW (Base definitions)
  • Instances • Databases
  • DB2 storage objecten: tablespaces, containers
  • Tables • Indexes • Views • User-Defined Types • Triggers • Schemas • Packages
  • Client - Server Setup
  • Directories • Server setup for client access
  • Configuring the Data Client/Driver
  • Application Development overview
  • Development, the context • Development,SQL extensions: Compound SQL and "Inline" SQL PL • PureXML
  • Server-side development • Triggers • User-defined Functions (UDFs) • Stored Procedures
  • How developers see it: Application interfaces to DB2 • Embedded Static SQL • Dynamic SQL • DB2 Call Level Interface (DB2 CLI) • Java Database Connectivity application (JDBC)
  • Security and authorisation
  • Authentication types • System level authority • Database level authority • Privileges
  • Utilities
  • Export utility • Import utility • Load utility • Explain
  • Concurrency and locking
  • The concurrency problem • Isolation en isolation levels • Locking mechanism
  • Labs

Intended for

Users and developers who are dealing (directly or indirectly) with DB2 for Linux, UNIX and Windows objects and data.

This fundamentals course can also be interesting as an introduction course for system managers and database administrators who are NOT familiar with DB2, and as such is a stepping-stone to the course DB2 for LUW DBA - Core competences.


Knowledge of concepts of relational databases and SQL (see course SQL and relational databases fundamentals) is expected. You can test your knowledge and current SQL skills by filling out the online self-test.

Training method

Classroom instruction with exercises.

Course leader

Koen De Backer, Kris Van Thillo.


3 days.


You can enrol by clicking on a date
datedur.lang.  location  price
25 Sep3NWoerden  (NL)1425 EUR  (exempt from VAT) 
18 Oct3?Leuven  (BE)1425 EUR  (excl. VAT) 

Global score

3.9/5 (based on 86 evaluations)


Had graag eerder oefeningen gehad na uitleg van bepaalde theorie. Theorie was nu lang voordat er een oefening was (, )
3 dagen is misschien net iets te kort voor deze cursus. De Heer Koen De Backer is een goede trainer, hij legt de materie goed uit. (, )
heel goed, zeer leerzaam (, )
Prima cursus gegeven door Koen, met kennis van zaken. (, )
Geeft in vogelvlucht een goed beeld van DB2 LUW met de meest belangrijke functies. (, )
prima gegeven. Lokaal was erg warm (, )
Heel goede cursus die dank zij de combinatie UDB en Mainframe een extra meerwaarde kreeg. (, )
goede verhoudingen cursusstof en oefening (, )
zonder enige ervaring zijn bepaalde delen soms lastig te volgen, verder goed. (, )
Zeer goed, gedoseerde informatie. Oefeningen waren begrijpelijk. (, )

Refresh this page to see other comments.