Catàleg de Cursos

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 enables students to perform AIX Live Update operations on the AIX operating system. This includes installing interim fixes, service packs and technology levels using the AIX Live Update capability. Students in this course will learn how to implement AIX Live Update. Students will also be exposed to the different management types for live update and learn skills required to install AIX updates, such as technology levels, service packs and interim fixes, without requiring downtime (a reboot) for the server. Best practices and testing methods for live update will be discussed, providing students with the knowledge to effectively configure and manage live update in a production environment. Additionally, students will learn skills to troubleshoot and debug live update issues.

Data security and privacy challengers are never-ending. IBM Guardium Data Protection (Guardium) provides a broad range of data security and protection capabilities that can protect sensitive and regulated data across environments and platforms. It discovers and classifies sensitive data from across an enterprise, providing real-time data activity monitoring and advanced user behavior analytics to help discover unusual data activity.The course prepares the student to administer Guardium appliances, discover unusual data activity, locate vulnerable data, automate compliance processes, and monitor and protect sensitive data. To proact using Guardium, students complete hands-on lab exercises.This course is based on Guardium Data Protection version 12.1.

With IBM Turbonomic, your cloud investments are smarter, automation is easier, and you can finally realize the promise of agility, elasticity and speed to market. It is an ideal solution for organizations adopting FinOps! This course takes you in-depth into how the IBM Turbonomic platform interacts with the world's most broadly accepted public cloud technologies, such as AWS, Azure, and GCP. You learn about the cost and feasibility of migrating core applications to the cloud for flexibility and scale. You gain understanding of IBM Turbonomic support for reserved instances, savings plans as well as committed use discounts. This course describes how IBM Turbonomic optimizes compute, storage, and PaaS services in cloud for performance and efficiency, increasing ROI and lowering your cloud bill by using only what you need.

IBM Instana helps in managing application performance in real-time and maximizing uptime with automated full-stack observability. This course provides information about the architecture and functionality of IBM Instana to help you understand the value proposition. You learn essential user interface techniques, creating application perspectives, and how to use dashboards to monitor the services. In addition, this course teaches about distributed tracing and the AutoTrace feature that helps in quickly tracing issues down to the root cause. You also learn the differences between alerts, issues, and incidents and how to create alerts to notify team members when certain criteria are met. You also learn how the Smart Alerts simplify the alerting configuration. IBM Instana automatically discovers, maps, and monitors all services and infrastructure components, providing complete visibility across every layer of your application stack. The course also teaches about Unbounded Analytics, Synthetic Monitoring, Log Management, and custom dashboards. Built on a foundation of real-time granularity and high-fidelity data, IBM Instana delivers actionable insights that your IT teams can leverage to enhance application performance and drive operational efficiency and reliability.

This course teaches you how to use IBM App Connect Enterprise to apply advanced topics such as basic security authentication on deployed integrations, message flow monitoring to help in problem determination, and creating user-defined properties in a message flow. The first part of this course covers message flow aggregation, encrypting credentials and storing them in the IBM App Connect vault, and debugging message flows. The second half introduces dynamic features that use IBM App Connect web user Interface to Record and Replay messages, create a business transaction definition, and view various business events in a completed, failed, inconsistent, and in-progress state.

This course provides instruction in using IBM App Connect Enterprise to connect to IBM MQ and reference databases. The first part of this course covers traditional use cases for IBM App Connect Enterprise including using App Connect Enterprise in conjunction with JMS, web services, and IBM MQ. The second half extends topics discussed in prior courses including using the Graphical Data Mapping editor to create a DFDL model and using ESQL in a Compute node. The course also covers referencing a database in a message flow application.

In this course, you learn how to construct message flow applications to transport and transform data. You learn how to process file data and develop REST APIs. The course also explores how to control the flow of data by using various processing nodes, and how to import, build, and test message flow applications. You learn how to test your message flows by using the Flow Exerciser, Message Flow Debugger, and Trace nodes.

This self-paced with lab course will accelerate your API Management knowledge enabling you to scale the use of secure API connectivity within your organization. This course will help you develop the knowledge and skills necessary to be self-sufficient on webMethods API Management which underpins your project success.

This self-paced course provides learners with an overview of the basic features and functionality of webMethods Integration (on-premises). This course provides developers and architects a deeper dive into integrating enterprise applications at scale.

In this two-day intermediate-level course, you learn about case solution design. You export and import case solutions. You define various case objects such as properties, choice lists, roles, business objects, and case types. You create To-do Tasks and Container activities and implement preconditions and Sets to manage activities. You create custom property views for case pages. You model BPM processes for case activities and create client-side human services. You create case stages and manage the stages manually and automatically with JavaScript. This course also teaches you how to create custom pages and implement Free Form page layout and utility widgets for case solutions.

This introductory course integrates training in Case Management methods and implementation with IBM Business Automation Workflow (BAW). The course introduces IBM Business Automation Workflow along with its key capabilities. You learn case management concepts, architecture, and the benefits of using IBM Business Automation Workflow on Cloud. You also learn how to manage cases in the BAW Case Client. The course ends with building your first case solution and deploying it.

In this one-day advanced course on process application development, you learn how to handle complex tasks and process interactions. You learn how to integrate your process application with external systems, implement a cancellation pattern, and how to handle content events in your process.

In this advanced one-day course, you implement advanced routing and integrate your process application with external systems. You create a decision service, implement message events, apply asset tagging, and access and manipulate external data. You integrate your process application with a database and learn about exposed process variables (EPVs) and environment variables (ENVs). You develop a catch exception and implement error handling in a service. You add advanced routing capabilities to your process application by using team filter services and implement a 'four eyes' policy.

This intermediate-level course covers the modeling of process flow, sequence flow, tokens, gateways, and intermediate events. Using the core requirements for an HR recruitment process, you determine and create all the necessary assets to support a coach in the Hiring Request Process. You use complex business objects to organize your data, and pass data into and out of a linked process. You implement a service for an activity, and map variables between a nested service and an activity. You also create a toolkit to enable sharing of your assets. The course concludes with conducting a Playback session. You demonstrate the process, following various paths that flow from the exclusive gateways in the process and demonstrate tasks that are assigned.

This introductory course integrates training in business process management (BPM) methods and implementation with IBM Business Automation Workflow. You learn core process modeling and implementation skills, the project development approach, process model implementation fundamentals, and delivery patterns.

This course provides technical professionals with the needed skills to administer IBM Cloud Pak for Business Automation. The course begins with an introduction to IBM Cloud Pak for Business Automation (CP4BA). You manage platform security for CP4BA and work with Business Teams. You explore the Red Hat OpenShift Container Platform (RHOCP) web console for container management such as Cluster Inventory, Events, CPU, and Memory. You examine the available observe options such as Metrics, Alerts, and Dashboards. You scale the application deployment. You customize the Cloud Pak Platform UI. To troubleshoot common Cloud Pak cluster problems, you get logs for nodes, cluster, and pods. You view the logs for pods by running commands and examine the logs in the RHOCP console. You learn how to troubleshoot the Container Engine and the pods that fail to start. The course concludes with the collection of MustGather files to submit it to the IBM Support team for troubleshooting.