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! 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. This course provides this. Useful, both if the system is actively used in-house, or if it runs more as a blax-bock 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 an RDBMS. You should be ready to get started with it independently 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
  • client tool setup and cataloging of databases
  • Data Studio as a client tool - a short introduction

Schedule a training?

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. 
If interested in organising this training internally, get in touch with us; we can even customise it to meet your specific needs.

REQUEST IN-COMPANY TRAINING

 

Public training calendar

No public sessions are currently scheduled. We will be pleased to set up an on-site course or to schedule an extra public session (in case of a sufficient number of candidates). Interested? Please let us know.

Intended for

The course is intended for analysts, programmers 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.

Background

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

Certificate

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

Duration

3 days.

Course leader

Kris Van Thillo (ABIS).


SESSION INFO AND ENROLMENT