DB2 for LUW fundamentals course (EN/NL/FR)

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.

Intended for

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.

Backgroud

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 'SQL fundamentals'.

Main topics

• 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

Training method

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.

Certificate

At the end of the session, the participant receives a 'Certificate of Completion'.

Duration
3 days.