Db2 for Linux, Unix and Windows (abbreviated as Db2 for LUW, previously also called DB2 UDB) is IBM's database platform for distributed platforms. In order to be able to work effectively with this Db2 system - regardless of your task or background - you need to have a certain basic knowledge. That knowledge is provided by this course. Useful, both if the system is actively used in-house, or if it runs more as a black-box to support third-party applications.

Combined with the course SQL and relational databases fundamentals, this course forms a balanced whole, so that after completing it, one has a 'total overview' of Db2 for LUW as a database system. You should be ready to get started independently with it immediately!

We refer users on the zOS platform to the Db2 for z/OS fundamentals course.

During this basic course the following topics are covered:

• the structure of Db2 for LUW - system/instance and database;
• the Db2 objects for physical data storage (tablespaces);
• the Db2 objects for logical data storage and data manipulation (tables, indexes, views, synonyms, ...);
• the locking behavior of the system;
• the techniques available for access security - identification, validation;
• client tool setup and cataloging of databases;
• Data Studio as a client tool - a short introduction.

• The Db2 for LUW family- An overview
  • Db2 Server products • Db2 Data Servers • Data Clients/Drivers
• Db2 Tools
  • Db2 (Administration) Command Line Tools • Introduction to Data Studio • Db2 scripting
• Data Definition in Db2 for LUW (Base definitions)
  • Instances • Databases
  • Db2 storage objects: 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 and isolation levels • Locking mechanism
• Labs

Live instructor-led training, with plenty of opportunities for hands-on exercises and discussion.

Delivered as a live, interactive training: available in-person or online, or in a hybrid format. Training can be implemented in English, Dutch, or French.

Knowledge of concepts of relational databases and SQL (see course SQL and relational databases fundamentals) is expected.

The course is intended for analysts, (DevOps) developers and (starting) database administrators who are going to use Db2 for LUW. Furthermore, anyone who wants to get a thorough overview of the Db2 for LUW database system.