IBM Db2 12: Foundation for Relational DBAs – 4.5-Day Instructor-Led Training (Hungarian Language)
Who Should Attend
- IBM Db2 users
- IBM BAW and Cognos software system administrators, infrastructure engineers
- Database Administrators (DBAs)
- Application Support professionals
- DevOps and Platform Engineering engineers
- System Integrators and IT Consultants
Course Outline
- IBM Db2 12.1 Architecture and Fundamental Concepts
- Db2 Installation and Configuration
- Managing Db2 Instances
- Database Creation and Administration
- Storage and Tablespace Management
- Creating and Managing Database Objects
- Using Command Line Processor (CLP) and Graphical Administration Tools
- Data Import, Export, and Data Movement Techniques
- Backup and Recovery Strategies
- High Availability and Business Continuity
- User, Role, and Privilege Management
- Database Security and Encryption
- Row and Column Access Control (RCAC)
- Label-Based Access Control (LBAC)
- Implementing Trusted Contexts
- Transaction Management, Locking Mechanisms, and Isolation Levels
- Concurrency and Parallel Workload Management
- SQL Performance Tuning
- Db2 Query Optimizer
- Indexing Strategies and Index Optimization
- EXPLAIN and SQL Access Plan Analysis
- Using Db2 AI Optimizer
- Using Design Advisor
- Using Data Management Console
- Monitoring and Diagnostic Tools
- Performance Optimization for Transactional and Analytical Workloads
- Troubleshooting and Problem Diagnosis
- Hands-on Lab Exercises and Real-World Enterprise Case Studies
- Best Practices for Managing Enterprise Db2 Environments