IBM Db2 LUW Fundamentals Training Course – Introduction to Database Administration on Linux
Key information
Upcoming sessions
Would you like to schedule this training on a specific date? Contact us by email or via the contact form.
Description of the training: IBM Db2 LUW Fundamentals Training Course – Introduction to Database Administration on Linux
This IBM Db2 LUW Fundamentals Training Course – Introduction to Database Administration on Linux introduces you to using and performing basic administration of an IBM Db2 (Linux, UNIX and Windows) relational database on Linux. You will learn to install Db2 on a Linux server, navigate its environment, use the db2 CLP, work with objects and write your first SQL queries.
Also discover our IBM Db2 LUW Training Course (administration level) and our PostgreSQL Training Course.
Good to know
This course includes extensive exercises (60% hands-on) for better learning. Sessions are guaranteed from a single registrant (except in cases of force majeure). A preliminary interview takes place between the participant and/or a company contact in order to fully account for the participant’s profile (level, needs, professional context, challenges, etc.).
Assessment: throughout the course, the trainer evaluates participants’ progress through quizzes, role-play scenarios and hands-on labs. Participants receive a certificate of completion at the end of the course.
This course is part of our Database Training Courses catalog. Discover our other database and BI training courses to model, operate and add value to your business data.
Objectives of the training: IBM Db2 LUW Fundamentals Training Course – Introduction to Database Administration on Linux
By the end of the course, participants will be able to:
- Understand the role of Db2 LUW and how it works on Linux
- Install Db2 on a Linux server and connect to a database
- Navigate the Db2 environment and use the db2 CLP
- Describe and work with the main Db2 objects (databases, tables, indexes, views)
- Run SQL queries to query and manipulate data
- Use basic utilities (EXPORT, IMPORT, LOAD)
- Understand logging and the principles of backup/restore
- Perform common administration tasks on Linux
Prerequisites of the training: IBM Db2 LUW Fundamentals Training Course – Introduction to Database Administration on Linux
- Basic Linux administration skills (command line, files)
- General understanding of relational databases
- Prior SQL experience is a plus
- No mainframe knowledge is required: the course runs entirely on Linux.
- Because every participant is unique, a personalized interview with our expert allows us to design a course perfectly aligned with their objectives, level and professional challenges.
Target audience of the training: IBM Db2 LUW Fundamentals Training Course – Introduction to Database Administration on Linux
- Beginners who want to discover Db2 LUW
- Linux system administrators and operators
- Developers who want an introduction to Db2 LUW
- IT technicians and future junior DBAs
- Anyone who wants to understand the fundamentals of Db2 on Linux
FAQ
What is IBM Db2 LUW?
IBM Db2 LUW (Linux, UNIX and Windows) is IBM’s relational database management system for distributed environments, deployed in particular on Linux servers. This introductory course walks you through its fundamentals and basic administration over 5 days (35h).
What is the difference between Db2 LUW and Db2 for z/OS?
Db2 LUW (Linux, UNIX and Windows) is the distributed version of Db2, installed on Linux, UNIX or Windows servers. Db2 for z/OS is the mainframe version. The SQL language is largely common, but administration and tooling differ. This introductory course focuses on Db2 LUW on Linux.
Who is this Db2 introduction for?
This introductory course is aimed at beginners: Linux/system administrators, developers, IT technicians and future junior DBAs who want to discover Db2 LUW. Basic Linux administration and SQL skills are enough; no mainframe knowledge is required.
How long is the IBM Db2 LUW Fundamentals course at MFE-IT?
The course lasts 5 days (35 hours), in a fully tailored format with a maximum of 3 participants per session. It covers the fundamentals of Db2 LUW: installation on Linux, environment, objects, SQL, utilities and the first administration tasks. 30 days of post-training support.