Cursos de Datos y Business Intelligence

This course provides a high-level overview of IBM Db2 version 12.1, giving relational database administrators the foundational skills needed to manage and support Db2 environments effectively. Learners will develop essential competencies in installation, configuration, database creation, and day-to-day administration tasks.The course covers key topics including Db2 product editions and architecture, command-line and GUI tools, instance and database configuration, storage management, object creation, performance tuning with utilities, and backup and recovery strategies. Learners will also explore troubleshooting techniques using diagnostic logs and system views.Hands-on lab exercises throughout the course allow learners to apply concepts by performing real-world tasks such as creating databases, configuring automatic storage, running utilities like RUNSTATS and REORG, and executing recovery procedures.By the end of the course, learners will be proficient in administering Db2 v12.1 systems and confidently handling routine operations, performance optimization, and recovery scenarios.

This course provides a detailed exploration of essential data management, recovery, and maintenance techniques for IBM Db2 12.1 database administrators. Learners will gain the skills necessary to manage data movement, implement robust backup and recovery strategies, and monitor and maintain database performance in enterprise environments.This course covers how to move and load data efficiently using SQL commands, the LOAD, IMPORT, and INGEST utilities, and procedures like ADMIN_MOVE_TABLE. The course then shifts focus to recovery operations, covering crash recovery, version recovery, roll-forward recovery, and the configuration of logging and backup policies, including high availability through HADR. In the final unit, learners will explore tools and commands for ongoing maintenance and performance tuning, including RUNSTATS, REORG, REORGCHK, event monitors, the Db2 Design Advisor, and diagnostic utilities such as db2diag, db2fodc, and db2trc.Through a series of hands-on exercises, learners will practice loading and reorganizing large datasets using Db2 utilities, configuring and executing backup and recovery operations, analyzing system health and performance using monitoring functions, and capturing and interpreting diagnostic data for problem determination.By the end of this course, learners will be proficient in managing data movement, implementing recovery procedures, optimizing performance, and diagnosing operational issues in Db2 12.1 databases—ensuring high availability and reliability in production environments.

This course provides learners with a comprehensive exploration of advanced techniques for managing and recovering data in Db2 12.1 environments. It begins with methods for efficiently moving and loading data, enabling database administrators to migrate schemas, relocate data, and integrate with external sources while maintaining system stability. The course covers advanced backup and recovery strategies, from incremental backups and redirected restores to dropped table recovery and logical backups. Learners will also explore Db2 features that support high availability and disaster recovery, as well as specialized tools such as split mirror technology and the Db2 Advanced Recovery Feature. Through a series of hands-on exercises, learners will practice applying these advanced techniques in real-world scenarios. Activities include using the LOAD utility with advanced options, moving data between databases with db2move and schema copy procedures, executing redirected restores, and recovering dropped tables. Participants will also gain practical experience with database maintenance tasks such as running RUNSTATS, reorganizing tables and indexes with REORG, and applying autonomic features to automate recurring maintenance operations. By the end of this course, learners will be able to confidently manage complex data movement, implement robust backup and recovery procedures, and use Db2’s autonomic features to sustain database performance and availability. They will be equipped with the expertise needed to reduce downtime, optimize efficiency, and safeguard critical enterprise data in advanced Db2 deployments.

This course provides a comprehensive introduction to building interactive, insightful dashboards and stories using IBM Cognos Analytics version 12. Through a combination of demonstrations, hands-on practice, and best practices, you will learn how to create compelling visualizations, develop dynamic stories, build explorations for advanced analysis, and apply forecasting and drill-through techniques to enhance user interactivity. The course covers both foundational and advanced features, including new visualization properties, customization options, and predictive insights. By the end of the course, you will be able to design professional, data-driven dashboards and deliver actionable insights to support better business decision-making.

This course provides a high-level overview of IBM Db2 version 12.1, giving relational database administrators the foundational skills needed to manage and support Db2 environments effectively. Learners will develop essential competencies in installation, configuration, database creation, and day-to-day administration tasks.The course covers key topics including Db2 product editions and architecture, command-line and GUI tools, instance and database configuration, storage management, object creation, performance tuning with utilities, and backup and recovery strategies. Learners will also explore troubleshooting techniques using diagnostic logs and system views.Hands-on lab exercises throughout the course allow learners to apply concepts by performing real-world tasks such as creating databases, configuring automatic storage, running utilities like RUNSTATS and REORG, and executing recovery procedures.By the end of the course, learners will be proficient in administering Db2 v12.1 systems and confidently handling routine operations, performance optimization, and recovery scenarios.

This course provides a detailed exploration of essential data management, recovery, and maintenance techniques for IBM Db2 12.1 database administrators. Learners will gain the skills necessary to manage data movement, implement robust backup and recovery strategies, and monitor and maintain database performance in enterprise environments.This course covers how to move and load data efficiently using SQL commands, the LOAD, IMPORT, and INGEST utilities, and procedures like ADMIN_MOVE_TABLE. The course then shifts focus to recovery operations, covering crash recovery, version recovery, roll-forward recovery, and the configuration of logging and backup policies, including high availability through HADR. In the final unit, learners will explore tools and commands for ongoing maintenance and performance tuning, including RUNSTATS, REORG, REORGCHK, event monitors, the Db2 Design Advisor, and diagnostic utilities such as db2diag, db2fodc, and db2trc.Through a series of hands-on exercises, learners will practice loading and reorganizing large datasets using Db2 utilities, configuring and executing backup and recovery operations, analyzing system health and performance using monitoring functions, and capturing and interpreting diagnostic data for problem determination.By the end of this course, learners will be proficient in managing data movement, implementing recovery procedures, optimizing performance, and diagnosing operational issues in Db2 12.1 databases—ensuring high availability and reliability in production environments.

This course provides learners with a comprehensive exploration of advanced techniques for managing and recovering data in Db2 12.1 environments. It begins with methods for efficiently moving and loading data, enabling database administrators to migrate schemas, relocate data, and integrate with external sources while maintaining system stability. The course covers advanced backup and recovery strategies, from incremental backups and redirected restores to dropped table recovery and logical backups. Learners will also explore Db2 features that support high availability and disaster recovery, as well as specialized tools such as split mirror technology and the Db2 Advanced Recovery Feature. Through a series of hands-on exercises, learners will practice applying these advanced techniques in real-world scenarios. Activities include using the LOAD utility with advanced options, moving data between databases with db2move and schema copy procedures, executing redirected restores, and recovering dropped tables. Participants will also gain practical experience with database maintenance tasks such as running RUNSTATS, reorganizing tables and indexes with REORG, and applying autonomic features to automate recurring maintenance operations. By the end of this course, learners will be able to confidently manage complex data movement, implement robust backup and recovery procedures, and use Db2’s autonomic features to sustain database performance and availability. They will be equipped with the expertise needed to reduce downtime, optimize efficiency, and safeguard critical enterprise data in advanced Db2 deployments.

This course provides database administrators and IT security professionals with the knowledge and practical skills needed to implement and manage robust security in IBM Db2 v12.1 environments. Learners will explore the fundamentals and advanced concepts of Db2 security, including authentication, authorization, and privilege hierarchies. This course covers key topics such as configuring access controls, utilizing database roles and authorities, managing data encryption for secure communications, and applying advanced security features like Row and Column Access Control (RCAC), Label-Based Access Control (LBAC), and Trusted Contexts for multi-tiered architectures. Additionally, students will examine Db2’s built-in auditing capabilities to monitor compliance and ensure secure database operations.

This course equips experienced database administrators with the skills needed to analyze, tune, and optimize the performance of IBM Db2 12 for Linux, UNIX, and Windows. Participants will learn how to interpret and influence the Db2 query optimization process using statistical metadata, develop efficient indexing strategies for high-performance workloads, and apply advanced tools such as EXPLAIN, db2pd, and the Db2 Data Management Console to evaluate and refine SQL access paths. The course also introduces the Db2 AI Optimizer and automation techniques that simplify statistics collection and performance diagnostics. Emphasis is placed on real-world use cases, practical monitoring methods, and proactive tuning practices to ensure scalable and efficient database operations in enterprise environments.

This course provides a comprehensive exploration of Db2 12.1 performance tuning and optimization, giving relational DBAs the skills needed to manage and improve workload efficiency. Learners begin by reviewing core optimization concepts, examining how Db2 evaluates access paths, uses statistics, and determines efficient execution strategies. They then progress into more advanced topics, including statistical views, optimization classes, query rewrite behavior, registry variables, and the integration of AI-driven optimizer enhancements.The curriculum also covers essential physical design considerations—such as logging strategies, clustering methods, table partitioning, MDC, and MQT design—to help DBAs create structures that support scalable, high-performance query execution. In addition, learners gain hands-on experience with modern monitoring and diagnostic tools, including db2batch, db2mon, db2caem, the Db2 Data Management Console, and core troubleshooting utilities.Throughout the course, participants reinforce their skills through practical exercises that involve analyzing access plans, applying statistical techniques, tuning queries, benchmarking SQL workloads, and diagnosing performance issues using Db2's monitoring and diagnostic capabilities.

This course provides relational DBAs with essential and advanced skills to manage, secure, recover, and optimize IBM Db2 v12.1 environments. Beginning with foundational concepts, participants will learn how to install Db2, configure instances, manage storage, and create database objects using both command-line and GUI tools. The course then expands into practical techniques for data movement, backup and recovery, and high availability configurations, equipping learners to maintain data integrity and ensure business continuity.Security and concurrency are addressed in depth, including the implementation of user access controls, role-based permissions, encryption methods, Row and Column Access Control (RCAC), Label-Based Access Control (LBAC), and Trusted Contexts for multi-tiered architectures. Participants will also explore Db2’s locking mechanisms and isolation levels to troubleshoot contention issues and manage concurrent workloads effectively.Performance tuning and optimization are emphasized through detailed instruction on the query optimizer, indexing strategies, monitoring tools, and the use of EXPLAIN utilities. Learners will leverage the Db2 AI Optimizer, Design Advisor, and Data Management Console to analyze SQL access plans and improve system responsiveness across transactional and analytical workloads.Through hands-on lab exercises and real-world scenarios, learners will gain the proficiency to manage Db2 environments efficiently and securely, diagnose issues quickly, and ensure high availability and performance in enterprise-scale deployments.

This course teaches learners how to explore, analyze, and report on data using IBM Planning Analytics Workspace and related clients. Participants learn core Planning Analytics conceptssuch as models, cubes, dimensions, views, and setsand apply them to create interactive reports, dashboards, and formatted outputs. The course combines conceptual instruction with guided, hands-on exercises that allow learners to practice real-world tasks, including creating books and views, formatting reports, entering and spreading data, applying calculations and conditional formatting, working with sandboxes, publishing websheets, and exploring forecasting results. These exercises reinforce best practices and help learners build confidence using Planning Analytics features in practical business scenarios. The course reflects the current Planning Analytics Workspace v2.1.x environment while preserving content that remains valid from earlier v2.x releases. The course emphasizes effective analysis, reporting, collaboration, and planning techniques that learners can immediately apply in their own Planning Analytics implementations.

This course teaches modelers how to design and build a complete model using IBM Planning Analytics Workspace. Learners progress through the full modeling lifecycle, starting with an overview of Planning Analytics architecture and continuing through dimension design, cube construction, data loading, and business rule development. The course emphasizes modeling best practices and performance considerations using Planning Analytics version 2.1.x.Through a combination of instructor-led explanations and hands-on exercises, learners create and enhance a working model that reflects common planning and analysis scenarios. Topics include TurboIntegrator processes for loading and maintaining data, rules and feeders for advanced calculations, and techniques for optimizing model performance.The course also covers advanced modeling capabilities such as drill-through paths, currency conversion, and time modeling for different fiscal requirements. By the end of the course, learners will be able to build scalable, maintainable models that support planning, forecasting, and reporting use cases in Planning Analytics Workspace.

This course provides a high-level overview of the IBM Cognos Analytics v12 Data Module tool and its underlying architecture to provide learners with the skills necessary to master data modeling using the web-based, self-service capabilities of IBM Cognos Analytics v12 Data Modules. Learners will explore the essential steps in building data modules, from understanding the purpose and workflow of data modeling to creating, refining, and optimizing data structures. The course covers various topics, including managing relationships, advanced features and performance optimization, data enrichment with calculations and filters, creating groups and navigation paths, and managing data security. Learners will gain hands-on experience through exercises that enhance their ability to create and customize data modules, review and modify column properties, creating calculations, filters and data groups, and adding column dependencies. These hands on activities ensure learners practice consistency and usability for reporting, dashboarding, and exploration purposes.By the end of this course, learners should be proficient in developing data modules that integrate multiple data sources, support business analysis, and facilitate informed decision-making within the IBM Cognos v12 environment.

This course provides a comprehensive introduction to building interactive, insightful dashboards and stories using IBM Cognos Analytics version 12. Through a combination of demonstrations, hands-on practice, and best practices, you will learn how to create compelling visualizations, develop dynamic stories, build explorations for advanced analysis, and apply forecasting and drill-through techniques to enhance user interactivity. The course covers both foundational and advanced features, including new visualization properties, customization options, and predictive insights. By the end of the course, you will be able to design professional, data-driven dashboards and deliver actionable insights to support better business decision-making.

This course teaches learners how to explore, analyze, and report on data using IBM Planning Analytics Workspace and related clients. Participants learn core Planning Analytics concepts—such as models, cubes, dimensions, views, and sets—and apply them to create interactive reports, dashboards, and formatted outputs. The course combines conceptual instruction with guided, hands-on exercises that allow learners to practice real-world tasks, including creating books and views, formatting reports, entering and spreading data, applying calculations and conditional formatting, working with sandboxes, publishing websheets, and exploring forecasting results. These exercises reinforce best practices and help learners build confidence using Planning Analytics features in practical business scenarios. The course reflects the current Planning Analytics Workspace v2.1.x environment while preserving content that remains valid from earlier v2.x releases. The course emphasizes effective analysis, reporting, collaboration, and planning techniques that learners can immediately apply in their own Planning Analytics implementations.

This course teaches modelers how to design and build a complete model using IBM Planning Analytics Workspace. Learners progress through the full modeling lifecycle, starting with an overview of Planning Analytics architecture and continuing through dimension design, cube construction, data loading, and business rule development. The course emphasizes modeling best practices and performance considerations using Planning Analytics version 2.1.x.Through a combination of instructor-led explanations and hands-on exercises, learners create and enhance a working model that reflects common planning and analysis scenarios. Topics include TurboIntegrator processes for loading and maintaining data, rules and feeders for advanced calculations, and techniques for optimizing model performance.The course also covers advanced modeling capabilities such as drill-through paths, currency conversion, and time modeling for different fiscal requirements. By the end of the course, learners will be able to build scalable, maintainable models that support planning, forecasting, and reporting use cases in Planning Analytics Workspace.

This course covers fundemental and advanced SQL techniques for efficient data management, optimization, and analytics in Db2 12. Participants will learn how to navigate the Db2 system catalog and explore query performance optimization techniques, including indexing strategies, predicate pushdown, and query access plans to improve efficiency.The course also introduces advanced SQL functions, such as LISTAGG, PERCENTILE_CONT, and PERCENTILE_DISC. Participants will learn how to create and manage database objects and gain expertise in utilizing advanced join techniques such as inner and outer joins, hash joins, lateral joins, and set operators like UNION, INTERSECT, and EXCEPT to merge and analyze data from multiple tables.The course also covers the use of subqueries and query optimization techniques, including correlated subqueries, EXISTS/NOT EXISTS, and quantified predicates to enhance data retrieval efficiency. Through hands-on exercises and real-world scenarios, they will develop the skills necessary to handle large datasets efficiently and implement best practices for high-performance database management.

This course provides an introduction to the SQL language. This course utilizes IBM Data Studio on a Windows 11 operating system, but the SQL queries are appropriate for Linux, UNIX, and Windows environments. This course introduces SQL, including syntax, retrieving data from a Db2 table, coding inner joins, arithmetic operations, and scalar and columnar functions. Learners will also explore the UNION function, inserting, updating, and deleting rows, and will use the create table and create view statements. Additionally, learners will be introduced to advanced functions and performance optimization features in Db2 v12.Learners will participate in hands-on exercises to practice what they have learned.

Este curso está diseñado para programadores que desean dominar el desarrollo de aplicaciones basadas en Apache Kafka, desde los fundamentos hasta la implementación avanzada con procesamiento de streams y gestión de esquemas.
A lo largo del curso, los participantes aprenderán a instalar, configurar y utilizar Kafka en entornos reales, así como a desarrollar aplicaciones robustas, escalables y tolerantes a fallos.