Db2 for LUW fundamentals course

This 3-day ABIS course thoroughly explains the basic characteristics of the Db2 for LUW database system and provides practical exercises. Extremely useful for anyone who will eventually work with Db2 for LUW - analysts, developers, administrators, .... Classroom presentation, interactive session! Prior knowledge of SQL is recommended.

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.