Opleidingen
68.931
resultaten
DB2 SQL PL, triggers, stored procedures & user-defined functions (EN/NL/FR)
Learn to design and implement Db2 stored procedures, triggers and UDFs (user-defined functions) during this one-day ABIS training.
Since quite some time now, the possibility exists to integrate extra functionality in your database by means of stored procedures, triggers and user defined functions. Meanwhile, these features have proven to be indispensable, especially for improving modularity, reusability, and security. Time for you to start using these functional objects!
In this course we will look into
the advantages and disadvantages of stored procedures, triggers and user defined functions;
how to apply the right tool.
Participants will also get a technical insight in the set-up and the use of stored procedures, triggers and user-defined functions.
Both external stored procedures and stored procedures set-up with SQL PL (the 'SQL procedural language') are discussed. The SQL PL language is treated in sufficient depth such that participants will be able to write even fairly complex procedures.
For those who want to go deeper into SQL PL, we refer to the course SQL PL database programming.
Intended for
Application developers and technical analysts who have to develop stored procedures, triggers or user defined functions.
DBAs and data base designers who want to know the new possibilities in Db2 and learn how triggers and stored procedures can help implement the logical design, the data integrity, and the access control of a relational database.
Backgroud
Participants should be familiar with SQL (see SQL and relational databases fundamentals) and with Db2 for z/OS (see Db2 for z/OS fundamentals course) or Db2 for Linux, Unix and Windows (see Db2 for LUW fundamentals course). Knowledge of an application programming language (COBOL, PL/I, C, Java, SQL PL, ...) is not required.
You can test for yourself to see if you have enough background by filling out the on-line self-test "SQL fundamentals".
For Db2 on z/OS, you can test for yourself to see whether you have sufficient Db2 background by filling out the online self-test "Db2".
Main topics
SQL PL:
The procedural language of Db2: a short introduction
How to use variables, create cursors, throw exceptions, verify conditions, ...
Triggers:
What are triggers?
How and when do we use triggers?
Writing triggers
Examples and exercises
Stored procedures:
What are stored procedures: advantages and disadvantages?
When do we use stored procedures?
External stored procedures (written in COBOL, PL/I, C, Java, ...)
"Native" stored procedures: written in SQL PL
Examples and exercises
User defined functions:
User defined functions: introduction
How do we implement user defined functions?
When and how to use UDFs?
Scalar functions and table functions
Native functions versus external ones (written in COBOL, PL/I, C, Java, ...)
Examples and exercises
Training method
Classroom instruction with examples and exercises.
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
1 day.
€655
Klassikaal
max 12
OO analysis and design with UML (EN/NL/FR)
During this training, we will learn how to do the analysis and design for creating a well-structured object oriented application. In this three-day ABIS course, we will use UML diagrams as a key tool for better understanding of all aspects of our design.
This course
discusses the analysis and design phases of creating structured object oriented applications
offers a thorough knowledge of the different UML diagrams, necessary for the set-up and documentation of re-usable software
discusses a practical approach to the OOAD process as applied by diverse methods, such as Agile Modelling
gives the participant an insight into the use of the UML notation in several process models
introduces the use of design patterns and the creation of distributed applications
Intended for
Analysts, designers, programmers, consultants and teamleaders of projects based on OO-technology.
Backgroud
Some familiarity with basic software engineering problems and techniques (see course OO concepts and techniques). Familiarity with an object oriented language is also an advantage (cf. course Java programming).
You can test yourself to see if you have enough background by filling out the on-line self-test.
Main topics
OO analysis and design
application structure
development processes and methods
overview of UML
Requirements analysis
types of requirements
use cases and user stories
UML: use case diagram and system sequence diagram
wireframes
Analysis - domain modelling
classes - objects - associations
attributes - multiplicities - roles
generalisation
UML: class and object diagrams
Designing collaborating objects
UML: sequence diagrams
UML: collaboration/communication diagrams
Design class diagrams
adding operations
associations in DCD
more inheritance: abstract classes and interfaces
Design Patterns
what/why?
GoF design patterns
concrete examples: Strategy and Composite pattern
Auxiliary UML diagrams
State Machine diagram
Activity diagram
UML 2: Interaction Overview diagram - Timing diagram - Composite Structure diagram
Organising the application
UML: package diagram - component diagram - deployment diagram
OO and RDBMS: mapping and persistence frameworks
Distributed applications: service oriented architecture and Restful applications (APIs)
Training method
Classroom instruction with exercises.
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.
€2.620
Klassikaal
max 12
PL/SQL database programming (EN/NL/FR)
Leuven (BE)
di 9 jun. 2026
en 1 andere data
This 3-day ABIS course explains the Oracle programming language PL/SQL and provides extensive practical practice. Extremely useful for anyone who will be working with Oracle as a database application and/or APEX developer (and administrator)! Classroom training, implemented interactively. Prior knowledge of SQL is required; insight into Oracle database structures is desirable.
The Oracle database system is widely used – as a data source for application development. As an application developer in this environment – Java, .Net., Python, ... – you will need to be able to work with SQL and PL/SQL. This training offers you the necessary guidance to do so!
The aim of this course is to
explain the basic features of PL/SQL: data types, procedural statements, exceptions;
describe and practice more advanced PL/SQL capabilities: PL/SQL collections (and related statements), advanced exception handling;
introduce the main Oracle packaged applications and demonstrate their global added value;
demonstrate the benefits of working with stored procedures, functions, packages and triggers.
Intended for
This course is intended for application programmers, (APEX) developers and DBAs - basically anyone who will ‘build’ anything in an Oracle environment.
Backgroud
Participants are expected to have an understanding of relational database systems and to be able to write basic SQL statements (course SQL and relational databases fundamentals). A basic knowledge of the Oracle database system (see Oracle fundamentals course) is recommended.
You can test for yourself to see if you have enough background by filling out the on-line self-test 'SQL and relational databases fundamentals' and the on-line self-test 'Oracle fundamentals course'.
Main topics
Introduction PL/SQL'Stand Alone' versus 'Stored' procedures
SQL supportWriting SQL in a procedural environment
Variables and constants - records, collectionsExplicit declaration • implicit declaration
Logical comparisonsIf-then-else structure
case
Conditional and iterative controlFor-loop • do-while loop • loop-endloop • goto
continue
Cursor managementImplicit and explicit cursors • attributes • cursor-for loop
collections (nested table, varrays, associative arrays)
cursor or collection?
Error treatmentPre-defined exceptions • application exceptions
Procedural objectspackages • functions • procedures • triggers
Oracle Supplied Packages
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.
If interested in organising this training internally, get in touch with us; we can even customise it to meet your specific needs.
Certificate
At the end of the session, the participant receives a 'Certificate of Completion'.
Duration
3 days.
€1.785
Klassikaal
max 12
MySQL & MariaDB fundamentals course (EN/NL/FR)
Learn to work with MySQL and/or MariaDB in this three-day ABIS training.
This course presents a description of MySQL and of the very similar MariaDB: what it is, what it is intended for, and how it can be used.
The participant will learn
the structure of recent versions of the MySQL database software, and the similar MariaDB software;
the use of the "client" tools: command line interface, graphical interfaces, admin interface;
the objects for data storage and data manipulation;
creating databases, tables, and users;
preparing a database for use, especially authorisations and indexes.
Attention is also paid to the use in the context of a web server, to MySQL and MariaDB in relation to other RDBMS, and to specific topics like models for data storage, integrity, authorisations, and performance.
Moreover, this training will explain how to install the system and use it in practice, on Linux, on Unix, and on MS-Windows. After completion, the participants will not only have the necessary theoretical background of MySQL and MariaDB as RDBMS but also will have had sufficient practical training to start working with MySQL or MariaDB in an independent way.
Together with SQL and relational databases fundamentals this course forms a well-balanced whole, in such a way that after successful conclusion, the participants will have a 'complete overview' of MySQL and MariaDB as RDBMS.
Intended for
Analysts, developers, and database administrators who will be using MySQL and/or MariaDB; web server maintainers who are not yet familiar with MySQL or MariaDB; and anybody wanting to gain knowledge of the detailed workings of a relational database system.
Backgroud
The participants must have insight in relational database systems and SQL (see course SQL and relational databases fundamentals).
Some knowledge of a programming language is not necessary. The course will however briefly treat - if need exists - the typical ways to access MySQL and MariaDB from one of the programming languages PHP (cf. PHP programming: fundamentals course), Python (cf. Python: fundamentals), Java (cf. course Java programming), or Perl (cf. Perl programming: fundamentals course).
You can test for yourself to see whether you have sufficient background by filling out the online self-test "SQL fundamentals".
Main topics
Introduction: the MySQL and MariaDB environment; client-server-model; position within the relational model
SQL data definition language (DDL): database objects (like tables, storage engines (esp. InnoDB), indexes, views, triggers); data types; characteristics; creation of objects, using them, and parameters
SQL embedded in a program, esp. for supporting dynamic web pages
Metadata: the INFORMATION_SCHEMA; the DESCRIBE and SHOW statements
Securing the database environment and assigning authorizations
Utilities: export/import of external data; de-fragmentation; check and repair; master/slave replication
Use of the commands "mysql" and "mysqladmin", of the MySQL Workbench, and of the new MySQL Shell
Data integrity, locking and transactions
Performance: basic principles; use of indexes to improve performance; the 'EXPLAIN' statement
Basic installation and configuration of the MySQL Community Server, of MySQL Cluster, and of MariaDB Server
Training method
Classroom instruction with hands-on practice and exercises (about 50% of the time).
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.
€1.785
Klassikaal
max 12
Computing concepts (EN/NL/FR)
This training course gives participants without a specific IT background a general overview of the basic principles and techniques used in IT. This training at ABIS takes 3 days.
At the end of this course the participant will:
be familiar with the basic architectures and technologies of hardware, networks, applications;
be familiar with the functions and the types of operating systems;
understand the different kinds of applications: how they work and how they are made;
have had a taste of some basic techniques from the world of programming, data, networking, ...
Intended for
Future programmers or analysts without a specific IT background, everyone who wants to obtain basic technical IT-knowledge (project managers, sales representatives, managers, ...).
Backgroud
No specific previous knowledge is required.
Main topics
Computer technology basics
computer architecture • binary data • CPU • memory • I/O • mainframe/midrange/PC/server ...
Operating systems:
functions • types • OS overview (Windows, Unix, Linux, MVS-z/OS, OS/400-i5/OS, ...)
Virtualisation:
Hardware virtualisation • virtual machines • containers • cloud computing
Networks and data communication:
LAN & WAN • hubs, routers, switches, modems • Ethernet • ADSL • TCP/IP • OSI model • Internet • security
Distributed processing:
client/server • web technologies • HTML • XML • HTTP • Service Oriented Architecture web services • APIs
Data organisation:
data types • storage media • database types • SQL • locking, protection, recovery • data warehouses • analytics • BI • data science • machine learning • artificial intelligence
Applications:
traditional & object oriented programming • programming languages (COBOL, C++, Java, Python, C#, ...) • programming tools (IDE, CASE, Version Management) • platforms (Java EE, .NET) • frameworks
The development process:
project lifecycle (analysis, design, implementation, test, ...) • Agile • methods and techniques • modelling • ERD • Object Orientation (OO) • RUP • UML • organisational aspects
Management:
system management • network management • application management • SLA • ITIL
Training method
Classroom training, with theoretical explanations, demos and small exercises (e.g. on the basic principles of system analysis).
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.
€1.620
Klassikaal
max 12
MVS and z/OS overview (EN/NL/FR)
This 1-day classroom-based ABIS course explains the most important characteristics of the MVS and z/OS operating systems. Live and interactive classroom presentation. Extremely useful for anyone working on these platforms - analysts, developers, administrators (of z/OS and related subsystems), .... Prior knowledge of the platform is not required.
During this course you will be introduced to MVS, and z/OS. The Multiple Virtual Storage (MVS) operating system is known as IBM's flagship mainframe operating system. Although initially a standalone operating system (1974), it was later integrated into the more comprehensive OS/390 (1995), and today z/OS (2000), operating systems. In this course we will discuss the fundamental properties of MVS, and how MVS is part of the comprehensive z/OS operating system.
During this course, participants will:
gain insight into the meaning of MVS as an operating system;
gain insight into the evolution of MVS to z/OS;
learn to functionally understand the basic concepts of z/OS and its various related subsystems;
learn to place MVS concepts in a proper z/OS context;
be familiarized with the broader z/OS environment.
Intended for
Every future user of z/OS.
Backgroud
No specific background is required.
Main topics
HardwareCPU • storage • channel subsystem • peripheral devices • network • multi-processing • LPAR • sysplex
Concept of MVSVirtual and real storage • paging • address spaces • system initialisation (IPL)
Evolution of MVS to z/OS
Task management • storage management • resource and workload management
Data managementAccess methods • data organisation • the catalog • storage management subsystem (SMS)
JES and job management
Recovery and monitoring
z/OS subsystemsUser interaction (TSO and ISPF, UNIX shell) • security (RACF) • data communication monitors • database management systems • SDSF • Web based access (HTTP, WebSphere Application Server, MQ) • ...
Training method
Live instructor-led training, with plenty of opportunities for group discussion. Demonstrations.
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.
Certificate
At the end of the session, the participant receives a 'Certificate of Completion'.
Duration
1 day.
€630
Klassikaal
max 12
Java EE: the architecture explained (EN/NL/FR)
ABIS Training & Consulting - Couse Description
Java EE: the architecture explained
During this training, we give an overview of the current Java EE architecture. This one-day course at ABIS will teach you which technologies are available in Java EE to build full-stack applications.
In this course:
the participants get a high level overview of the architecture and possibilities of Enterprise Java (Java EE)
the most recent Java EE APIs are presented
an overview of products and tools in the Java EE domain is given
Intended for
Architects, project managers, developers and analysts interested in Enterprise Java.
Backgroud
Some familiarity with the Java platform is an advantage (see course Java concepts).
You can test yourself to see if you have enough background by filling out the online selftest "Java concepts".
Main topics
The Java EE architecture
components, containers and connectors
Java EE platform and services, profiles
application development
Jakarta EE
Java EE web components
web applications
MVC
servlets • JavaServer Pages (JSP) • web sockets
JavaServer Faces (JSF)
Java EE business components
enterprise applications
Enterprise Java Beans (EJB): types - architecture - container
Contexts and Dependence Injection (CDI)
Java Persistence Architecture (JPA)
enterprise integration and Java Connector Architecture (JCA)
Java batch
Java EE web services
SOAP: JAX-WS
REST APIs: JAX-RS
Other services
Java Mail • Java Messaging Service (JMS)
Java Transaction Service (JTS) • Java Transaction API (JTA)
security services
Java Management Extensions (JMX)
Training method
Classroom instruction with demonstrations and examples.
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 course session, the participant receives a 'Certificate of Completion'.
Duration
two half days.
€655
Klassikaal
max 12
DB2 for LUW DBA - Core competences (EN/NL/FR)
In this 4-day classroom ABIS course, the physical and logical properties of the Db2 for LUW database system are thoroughly explained and practically practiced. Classroom presentation, interactive session! Useful for anyone who will start working as a (junior) Db2 DBA - but also for analysts, (DevOps) developers, .... Prior knowledge of SQL, and basic knowledge of Db2 for LUW databases is recommended.
The database administrator (DBA) plays a key role in the data management process. The DBA is the scriptwriter and director in the design, implementation and maintenance of database structures; and is partly responsible for setting up and maintaining a high-performance database system. This course therefore offers a thorough technical and logical overview of the Db2 for LUW database management system. The training is primarily focussed on application DBAs.
At the end of the course, the participant:
is able to set-up the correct product configuration for his environment;
knows the physical set-up of the Db2 for LUW objects;
is able to set-up the correct physical organisation and security of the Db2 for LUW data;
has a good understanding of the use and scope of the database tools and db-system commands;
is able to set up a troubleshooting approach based on the available error logging infrastructure;
has a good understanding of the Db2 for LUW logging mechanism;
knows about the recovery strategies in Db2 for LUW.
Intended for
Database administrators (junior role); other users who perform part of the DBA's task; application developers (in a DevOps environment); system administrators who want to gain insight into the mainly logical Db2 for LUW object structures.
Backgroud
Some basic knowledge of the use of the database system (see course Db2 for LUW fundamentals course), a thorough SQL experience (see course SQL and relational databases fundamentals) and some programming experience are required.
You can test for yourself to see if you have enough background by filling out the on-line self-test 'SQL and relational databases fundamentals'.
Main topics
The Db2 for LUW system - A roundup for DBAs
The Db2 for LUW Instance • Memory segments • Bufferpools • Agents • Engine Dispatchable Units
Db2 for LUW Physical storage
Database scalability • Parallelism • Partitioning
db2 - Command Line Processor
Instances and Databases
Instances: set-up • configuration • administration • Fault Monitor Facility
Databases: Creating • Physical structure • Database configuration • Configuration Advisor
Db2 for LUW System Information
The Catalog • LIST command • administration logs (db2diag) • Using db2pd • Memory tracking • SYSIBMADM Views
Tablespaces and Containers
Tablespace Types: SMS Tablespaces • DMS Tablespaces • Automatic storage table spaces • Storage groups
Tablespace Design Issues: Page sizes • Extent size • Prefetch size • Bufferpools
Logical Objects
Tables: Internals • Large objects • Table 'space' management • Range partitioning • Time travel
Indexes: Structure • Internals • Types • Design Advisor
Looking at objects and object behaviour
Moving Data around
Export: concepts • Import: concepts • Loading Data: concept • Load Phases • Load indexing mode
Analysing integrity problems
Moving databases around: db2move • db2look
Keep Data in shape
Reorgchk utility • Reorganizing table and/or index • Runstats Utility • Rebind Utility • QUIESCE Command
Automatic maintenance
Database Recovery
Transactional logging • Types of logging
Backing Up the Database: Backup Types • The Recovery History File • Automatic database backup
Database Recovery: Crash recovery • Database Restore • Recovery Types: Roll forward - Cloning
Security and Access Control
Authentication configuration and fail-safe
Authorization levels: System • Database • Privileges
Roles • Trusted contexts and trusted connections • Encryption
RCAC (Row and Column Access Control)
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.
If interested in organising this training internally, get in touch with us; we can even customise it to meet your specific needs.
Certificate
At the end of the course session, the participant receives a 'Certificate of Completion'.
Duration
4 days.
€2.620
Klassikaal
max 12
XML concepts (EN/NL/FR)
During this training, we give an overview of the XML technology stack. This one-day course at ABIS will introduce you to the basics of XML, as well as implementations like XSD, XSLT and parsers.
XML is much more than just a standard to represent structured text documents.
In this course
the basic XML specifications (such as XML, XML Schema and XSLT) are explained;
many examples are given of the practical applications of XML technology.
Intended for
Analysts, application developers, database administrators and project leaders who want to gain an overview of XML and its application areas. People who are going to work with XML in practice, should instead take the technical course (XML fundamentals course)
You can test yourself to see if this course contains enough new information for you by filling out the on-line self-test.
Backgroud
No specific background is required. Basic knowledge of data modelling is an advantage.
Main topics
XML basics
XML structure
content types
namespaces
usage examples
Defining/imposing structure
DTD
XML Schema
Parsing
DOM
SAX
Transforming and Rendering
XPath
XSLT
XSLFO
Searching
XQuery
XPath
Web services
SOAP
WSDL
Training method
Theory with demonstrations and exercises.
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
1 day.
€655
Klassikaal
max 12
SQL PL database programming (EN/NL/FR)
This 2 day ABIS course covers the programming language SQL PL; all syntactic details and possibilities will be treated in detail. This does include the interaction between the elements of the programming environment (like variables, program flow, exception handling) and the embedded DML ingredients like SELECT statements or cursors. The participants will develop themselves stored procedures with SQL PL, either on Db2 for z/OS, on Db2 for LUW, on PostgreSQL, or on MySQL.
This course is intended for everybody interested in the SQL PL language; prior SQL knowledge is adviced.
Remark: Course description in English; Dutch and French versions are available on the ABIS website. Courses are planned in Dutch, English, and French. Consult the ABIS website for alternate course formats.
Main topics:
Introduction SQL PL
Variables
declaration, initialisation, use; BEGIN ... END blocks
Program flow
conditional structures IF...THEN...ELSE structure; CASE-statement;
iterations: WHILE..DO loop • FOR...DO loop • ITERATE • REPEAT...UNTIL • LOOP • cursor-based FOR-loop
Working with database objects; cursor management:
SELECT INTO • declaration and use of cursors • parametrization • insert, delete, update 'where current of' cursor
Error handling
predefined exceptions • applicatively defined exception handling • SIGNAL • GET DIAGNOSTICS
Procedural objects
user-defined scalar functions • native stored procedures • triggers • SQL CALL-statement;
possibilities of parameter declaration and 'locators'; possible options like 'commit on return'
Dynamic SQL
PREPARE and EXECUTE of a dynamically built query
Intended for/Audience: This course is first of all meant for application programmers and developers of programs that make use of Db2 or MySQL, and who want to learn how to write this kind of programs with SQL PL.
Also DBAs will be able to build up the necessary experience during this course to build or deploy stored procedures, triggers or user-defined functions. Furthermore they will gather useful ideas for automating some DBA tasks in a simple way.
Background/Prerequisites: Some experience with SQL and with Db2 (cf. Db2 for z/OS fundamentals course or Db2 for LUW fundamentals course), MySQL or MariaDB (cf. MySQL & MariaDB fundamentals course) or PostgreSQL is needed. Knowledge of an other procedural programming language (like COBOL, PL/I, REXX, Java, C, ...) might be an advantage.
Training Method/Didactics: Classroom instruction with exercises.
Duration: 2 days.
€1.310
Klassikaal
max 12