Cursos de Datos y Business Intelligence

Este curso está diseñado para dotar a los administradores de las habilidades y conocimientos esenciales necesarios para gestionar de manera competente bases de datos PostgreSQL.
Los participantes profundizarán en una experiencia de aprendizaje práctica que cubrirá temas clave como instalación de bases de datos, configuración, optimización del rendimiento, estrategias de respaldo y recuperación, y mejores prácticas de seguridad.

El curso "Neo4j for Developers and Administrators" está diseñado para proporcionar a los participantes el conocimiento y habilidades necesarios para utilizar eficazmente la base de datos de grafos Neo4j desde el punto de vista del desarrollo y la administración.

El curso de MongoDB para Desarrolladores es una formación diseñada para aquellos que deseen adquirir conocimientos sólidos sobre el uso y la implementación de MongoDB, una popular base de datos NoSQL orientada a documentos. Durante el curso, los participantes aprenderán desde los conceptos fundamentales hasta técnicas avanzadas para aprovechar al máximo esta potente herramienta en sus proyectos de desarrollo.

El curso de Talend Open Studio proporciona a los participantes una formación completa sobre el uso y las capacidades de esta herramienta de integración de datos. A través de una combinación de teoría y práctica, los participantes adquirirán habilidades sólidas en el manejo de archivos, transformación de datos, trabajo con bases de datos y técnicas de procesamiento avanzadas.

El curso de SQL - Fundamentos es una introducción completa al lenguaje de consulta estructurado (SQL) y proporciona a los participantes las habilidades y conocimientos fundamentales para interactuar con bases de datos relacionales.
A lo largo del curso, los participantes aprenderán los conceptos esenciales de SQL y cómo utilizarlo para realizar consultas y manipular datos.

El curso de Kibana proporciona una introducción completa al ecosistema ELK (ElasticSearch, Logstash y Kibana) y se centra específicamente en los conocimientos necesarios para utilizar Kibana de manera efectiva como una herramienta de análisis y visualización de datos.
A lo largo del curso, los participantes explorarán los conceptos fundamentales de Kibana y aprenderán cómo utilizarlos para extraer información valiosa de los datos.

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.

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 explores the fundamentals and top features of IBM Manta that are most relevant to Metadata Administrators. Explore the Manta administration user interface, discover how to configure connections, run workflows, fine-tune your lineage, and extend your repository beyond out of the box scanners thanks to OpenManta.

This course teaches Information Server and/or DataStage administrators to configure, manage, and monitor the DataStage Engine which plays a crucial role in Information Server.  It not only runs high-performance parallel ETL jobs designed and built-in DataStage, but also supports other Information Server products including Information Analyzer, QualityStage, and Data Click.  After introducing DataStage parallel jobs and the Engine that runs them, the course describes DataStage project configuration, the Engine’s development and runtime environments, and the Engine’s data source connectivity.  In addition, the course explains how to import and export DataStage objects, how to run and monitor DataStage jobs through the command line and GUI, and how to use some important Engine utilities.

This course enables the project administrators and ETL developers to acquire the skills necessary to develop parallel jobs in DataStage v11.7. The emphasis is on developers. Only administrative functions that are relevant to DataStage developers are fully discussed. Students will learn to create parallel jobs that access sequential and relational data and combine and transform the data using functions and other job components.

This course teaches how to build QualityStage parallel jobs that investigate, standardize, match, and consolidate data records. This course covers common data quality issues, QualityStage architecture, QualityStage clients and their functions, importing metadata, running jobs and reviewing results, building Investigate jobs, the Standardize stage and rule sets, identifying matching records and applying multiple Match passes, building a Survive job, and using a Two-Source match.Students will gain experience by building an application that combines customer data from three source systems into a single master customer record.

This course provides participants with a high-level overview of the IBM Cognos Analytics Dashboard tool and its underlying architecture. They will explore the powerful features of IBM Cognos Analytics dashboards to transform raw data into actionable insights. Through interactive lessons, practical exercises, and real-world scenarios, learners will gain the skills to create, customize, and share dynamic dashboards that drive data-informed decisions.Learners will gain hands-on experience through exercises that enhance their ability to create and customize dashboards, stories, and explorations.By the end of this course, learners should be proficient in creating and customizing dashboards, using Cognos Analytics tools and AI Assistant, integrating and visualize data from multiple sources, employing advanced features like 3D maps, forecasting, and drill-through definitions to enhance insights, and much more.

This course teaches Professional Report Authors about advanced report building techniques using relational data models, and ways of enhancing, customizing, and managing professional reports. The course builds on topics presented in the Fundamentals course. Attendees will participate in interactive demonstrations and exercises that illustrate key concepts while learning how to use advanced features in the product builds on topics learned in the Fundamentals course.

Students will explore IBM Cognos Analytics report authoring and different report object types (list, crosstab, chart, visualization, etc.). They will also create and format reports using grouping, headers, footers, and other formatting options. Also covered is the ability to focus reports by filtering data and using prompts. Students will learn to add value to reports using calculations and additional report-building techniques as well as how to enhance reports with advanced formatting and exceptional data highlighting.

This offering covers the fundamental concepts of installing and configuring IBM Cognos Analytics, and administering servers and content, in a distributed environment. In the course, participants will identify requirements for the installation and configuration of a distributed IBM Cognos Analytics software environment, implement security in the environment, and manage the server components. Students will also monitor and schedule tasks, create data sources, and manage and deploy content in the portal and IBM Cognos Administration.

This course provides a high-level overview of the IBM Cognos Analytics 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 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 relationship joins, data enrichment with calculations and filters, creating navigation paths, and managing data security. Learners will gain hands-on experience through exercises that enhance their ability to create and customize data modules, ensuring 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 environment.

This course provides participants with a high level overview of the IBM Cognos Analytics suite of products and their underlying architecture. They will examine each component as it relates to an Analytics solution. Participants will be shown a range of resources to provide additional information on each product.

This course is designed to teach database administrators advanced topics about Db2 for z/OS utilities with a combination of lecture materials and extensive lab exercises.