Event:
Title:
Db2 für LUW – Administration and SQL fundamentals intensive workshop
Course code:
LT#ADMS
Date:
On request
Duration:
4 Days
Cost per person:
1.940,00€ excl. VAT
2.308,60€ incl. VAT
Minimum number of participants:
2 participants
Organizer:
LIS.TEC GmbH
Location:
Ludwigsburg or
on site (plus travel costs)
Services:
Small study groups
Food & drinks
Seminar documents and training in german
Individual workshops and training courses with 1-2 participants on request.
If you register for several participants, we offer interesting graduated discounts.
You can register by sending an e-mail to schulung@listec.de
Contact: Herr Joachim Klassen
Telephone: +49 (0) 7141 93 93-0
Description:
For newcomers who want to get into the subject of Db2 administration and SQL in a short time, we offer this special 4-day intensive course.
In addition to the administration topics, the topic SQL is addressed in one day.
This workshop is suitable for employees who want to get into the topic Db2 Database Administration. The documents for the workshop are in German and on the most up-to-date Db2 stand – by means of exercises the theory is practically implemented.
Participants:
- beginning database administrators
- Apprentice for IT specialist
Objective:
In this practical course the participants will learn the concepts of the database management system Db2 as well as the basics of the database language SQL. You will then be able to carry out simple administrative activities and independently expand your knowledge on the basis obtained.
Requirements:
- Basic knowledge of the relational concept and operating systems (Linux / UNIX, Windows)
The topics at a glance:
SQL Foundations
- SQL categories
- Simple SQL queries
- Column and scalar functions
- Join tables (joins)
- Set operations
Db2 Administration basics
- Db2 installation, architecture and configuration
- Tools: IBM Data Studio and Db2 command line
- Databases, tablespaces and DB objects
- Backup and restore
- Monitoring and problem analysis
- Statistics and reorganization
- Security