Db2 for LUW
Administration and SQL fundamentals intensive workshop
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
Organizer:
LIS.TEC GmbH
Location:
Ludwigsburg or
on site (plus travel costs)
Services:
Small study groups
Food & drinks
Seminar documents and training in german
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:
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 categories
- Simple SQL queries
- Column and scalar functions
- Join tables (joins)
- Set operations
- Db2 installation, architecture and configuration
- Tools: IBM Data Studio, IBM Data Server Manager and Db2 command line
- Databases, tablespaces and DB objects
- Backup and restore
- Monitoring and problem analysis
- Statistics and reorganization
- Security