db2 formacion oficial sixe ibm

IBM Db2 12.1 | Relational Database Basic Course

2.240,00€

Become an expert IBM Db2 12.1 administrator with our official CLA90G course, designed to provide the fundamental skills every DBA needs in today’s business environment.

At SIXE, with more than 15 years training professionals in IBM technologies, we offer you a comprehensive learning experience that combines solid theory with intensive practice. This 16-hour course will prepare you to manage and maintain Db2 environments with total confidence and efficiency.

Our program covers everything from the basics to advanced administration techniques, including installation, configuration, database object management, performance optimization, and backup and recovery strategies. All this with a practical approach that will allow you to immediately apply what you have learned in your professional environment.

Why choose our training? Our certified instructors combine years of real-world experience with hands-on labs designed to simulate real business scenarios. Not only will you learn Db2, but you will develop the mindset and skills of a professional DBA.

SKU: CLA90G Category:

Description

Course information

IBM code: CLA90G
Category: IBM Db2 / Administration
Modality: Online and Presential
Duration: 2 days
Level: Basic-Intermediate
Certification: IBM Official

Who is it aimed at?

This course is specially designed for:

  • Database administrators starting their career or changing technology
  • System administrators who need to manage Db2 environments
  • Developers working with IBM Db2 databases
  • IT professionals looking for data management specialization
  • Technical consultants implementing Db2-based solutions

Prerequisites

To get the most out of this training, participants should have:

  • Basic knowledge of relational database concepts
  • Familiarity with operating systems (Linux/Unix/Windows)
  • No previous experience with Db2 required – perfect for beginners

Learning objectives

At the end of this course, participants will be able to:

  • Compare features and use cases of different editions of Db2
  • Explain Db2 versioning model and manage Mod Packs, Fix Packs and Service Builds
  • Using the Command Line Processor (CLP) to execute SQL and system commands
  • Create, configure and manage Db2 instances using command line and GUI tools
  • Configuring database parameters with commands such as GET/UPDATE/RESET DB CFG
  • Creating and managing database objects: schemas, tables, indexes, views and triggers
  • Implement external tables for data loading from various sources
  • Executing maintenance utilities: EXPORT, IMPORT, RUNSTATS, REORG
  • Perform backup, restore and recovery operations to ensure data availability.
  • Apply troubleshooting techniques using diagnostic logs and system views

Complete syllabus

Module 1: Introduction to IBM Db2 12.1

  • Db2 architecture and main components
  • Product editions: features and limitations
  • Versioning model and update strategies
  • Appropriate use cases for each edition

Module 2: Installation and configuration

  • Preparation of the environment and system requirements
  • Step-by-step installation process
  • Creation and configuration of Db2 instances
  • Initial configuration and validation

Module 3: Management tools

  • Command Line Processor (CLP): advanced usage
  • Data Management Console and GUI tools
  • Command line utilities for administrative tasks
  • Integration with development tools

Module 4: Database management

  • Database creation and configuration
  • Storage management and tablespaces

Module 5: Database objects

  • Creation and management of schemas, tables and indexes
  • Implementation of views, aliases and triggers
  • Referential integrity and constraint management
  • External tables for various data sources

Module 6: Maintenance and optimization

  • EXPORT and IMPORT utilities for data management
  • RUNSTATS for query optimization
  • REORG for performance maintenance
  • Proactive optimization strategies

Module 7: Backup and recovery

  • Backup strategies: full, incremental and delta backups
  • Disaster recovery planning

Module 8: Troubleshooting and diagnostics

  • Analysis of diagnostic logs
  • Use of system views for monitoring
  • Identification and resolution of common problems
  • Advanced diagnostic tools

Practical methodology

Our hands-on approach ensures that each theoretical concept is reinforced with real-world practical exercises. Participants will work in labs that include:

  • Complete Db2 installation from scratch
  • Creation of databases with customized configuration
  • Implementation of complex objects with dependencies
  • Execution of maintenance utilities in real time
  • Simulation of failures and recovery procedures
  • Performance analysis and query optimization

Our differential value

At SIXE we don’t just teach Db2, we train complete administrators. Our certified instructors provide:

  • Real-world experience in enterprise implementations
  • Case studies based on real projects
  • Best practices developed in the field
  • Documentation updated with the latest versions
  • Post-course support to resolve doubts

Training modalities

Online training

Interactive sessions with remote labs and full access to Db2 environments. Ideal for professionals looking for flexibility without sacrificing quality.

On-site training

Immersive experience in our specialized classrooms with dedicated equipment. Available in multiple cities:

Spain: Madrid, Barcelona, Valencia, Seville, Bilbao, Malaga
Latin America: Mexico City, Buenos Aires, Bogota, Santiago, Lima, Quito, and more

Start your career as a DBA Db2 Certified DBA

Don’t miss the opportunity to master one of the most powerful databases on the market. With limited places to guarantee personalized attention, we assure you an exceptional learning experience.

Check available dates and prices

Do you need to adapt the content to your company? Ask us about our customized in-company programs.

Related products