IBM Education - Page 8 of 11 - IT Training and Certification

Out of stock

Analytics and Data Training and Certification

CL464G: Db2 11.1 Advanced Database Administration

2 Days ILT, VILT

This course is designed to teach you how to:

Perform advanced monitoring using the Db2 administrative views and routines in SQL queries.
Manage the disk space assigned in Database Managed Storage (DMS) and Automatic Storage table spaces, including the activities of the rebalancer.
Use SQL queries and Db2 commands to check the high water mark on table spaces and to monitor the rebalance operation.
Utilize the REBUILD option of RESTORE, which can build a database copy with a subset of the tablespaces using database or tablespace backup images.
Plan and execute the TRANSPORT option of RESTORE to copy schemas of objects between two Db2 databases.
Create incremental database or tablespace level backups to reduce backup processing and backup image storage requirements.
Implement automatic storage management for table spaces and storage groups or enable automatic resize options for DMS managed table spaces to reduce administration requirements and complexity.
Describe the various types of database memory including buffer pools, sort memory, lock memory and utility processing memory.
Adjust database or Db2 instance configuration options to improve application performance or processing efficiency.
Implement Db2 Self Tuning Memory management for specific database memory areas.

Out of stock

CL463G: DB2 10.5 for LUW Advanced Database Administration with DB2 BLU Acceleration

5 Days ILT, VILT

This course is designed to teach you how to:

Fully use the advanced technical functions and features of DB2 LUW 10.1 and 10.5.
Implement DB2 BLU Acceleration, column-organized table support, for a new or existing DB2 database.
Describe how the column dictionaries used for DB2 BLU Acceleration are built and utilized to provide extreme compression for column-organized tables.
Explain the default workload management used for DB2 BLU Acceleration processing and how you can tailor the WLM objects to efficiently use system resources.
Monitor a DB2 database or application that uses column-organized tables using SQL monitor functions.
Implement Shadow tables for selected row-organized tables to improve analytics query performance
Configure a DB2 database that supports a mixture of application processing, including OLTP and Analytics query processing with Shadow tables
Create the Infosphere CDC Datastore, Subscription and Table mappings required to support Shadow tables
Implement a User Maintained MQT for a column-organized table
Create optimization profiles that allow applications to control specific operations included in the access plans selected by the DB2 Optimizer, like which index is used to access a table or which join method to utilize for joining tables.
Perform advanced monitoring using the DB2 administrative views and routines in SQL queries.
Configure and manage the implementation of DB2 instance or database level auditing, including using the db2audit command and creation of audit policies which can be assigned to specific tables, users or database roles to perform selective collection of audit records.
Explore DB2 management of disk space usage in Database Managed Storage (DMS) table spaces, including the activities of the rebalancer. Use SQL queries and utilities to check the high water mark on table spaces and to monitor the rebalance operation.
Move data from one table to another or from one database to another using utilities like db2move.
Utilize the ADMIN_MOVE_TABLE procedure to implement table changes with a minimal impact to data availability for applications.
Implement automatic storage management for table spaces and storage groups or enable automatic resize options for DMS managed table spaces to reduce administration requirements and complexity.
Exploit and monitor the REORG utility processing for offline and online table, and index reorganization This includes planning for the disk space and database log space necessary for reorganization.
Utilize the REORG Utility to implement row compression for large tables, to reduce disk utilization and improve I/O performance for a DB2 database and understand the automatic creation of compression dictionaries.
For Multidimensional Clustering (MDC) tables, determine how to select the dimension columns and table space extent size for efficient implementation of MDC tables. Compare the block indexes used with MDC tables with rows based indexes. Select the MDC rollout option that best matches application needs and achieves the best performance results.
Plan and implement range based table partitioning for large DB2 tables. Utilize the ALTER TABLE ATTACH and DETACH options to support roll-in and roll-out operations for range-partitioned tables. Compare the advantages of selecting or combining range partitioning with the hash-based partitioning used in DB2 partitioned databases or the multiple dimensions provided by MDC tables.

Out of stock

CL451G: DB2 11 BLU Acceleration Implementation and Use

2 Days ILT, VILT

The course is intended for Data Administrators that need to prepare for using the DB2 BLU Acceleration facilities of DB2 11.1 for Linux, UNIX and Windows systems.

The concepts and facilities of the BLU Acceleration feature of DB2 11 are presented including loading data into column-organized tables and monitoring the processing of SQL statements that access the tables.

The DB2 10.5 Fix Pack 4, referred to as Cancun, added support for Shadow tables, a new type of Materialized Query Table, and also Column-organized User Maintained MQT tables. One lecture unit describes these features. A demonstration allows students to implement and experiment with these functions.

With DB2 11.1, BLU Acceleration can be used in a clustered multiple database partition DB2 environment. This course includes a lecture and demonstration that allows students to create a set of column-organized tables from an existing set of row-organized tables and execute and analyze the performance of BLU Acceleration in a MPP database.

The lab demonstrations are performed using DB2 LUW 11.1 for Linux.

CL413G: DB2 for LUW Performance Tuning and Monitoring Workshop

RM5,180.00

4 Days ILT, VILT

Learn how to tune for optimum performance the IBM DB2 10 for Linux, UNIX, and Windows relational database management system and associated applications written for this environment. Learn about DB2 10 for Linux, UNIX, and Windows in a single partition database environment. Explore performance issues affecting the design of the database and applications using the database, the major database performance parameters, and the different tools that assist in performance monitoring and tuning.

Use tools in class that are common across the Linux, UNIX, and Windows environments. During labs running on DB2 10.1, develop your ability to use monitoring tools. Explain tools and DB2 utilities like RUNSTATS, REORG and db2batch to tune a database running on your local LINUX workstation.

CL213G: DB2 10 for LUW: Basic Administration for AIX

RM6,240.00

4 Days ILT, VILT

This course teaches you to perform, basic database administrative tasks using DB2 10.1 for Linux, UNIX, and Windows. These tasks include creating and populating databases and implementing a logical design to support recovery requirements. The access strategies selected by the DB2 Optimizer will be examined using the DB2 Explain tools.

Various diagnostic methods will be presented, including using the db2diag.log file messages to direct your investigation of problems, as well as using the db2pd commands.

CL207G: Db2 11.1 Administration Workshop for Linux

4 Days ILT, VILT

This course teaches database administrators to perform basic database administrative tasks using Db2 11.1. These tasks include creating database objects like tables, indexes and views, and loading data into the database with Db2 utilities like LOAD and INGEST. Various diagnostic methods will be presented, including using db2pd command options, and monitoring with SQL statements that reference Db2 monitor functions. Students will learn how to implement automatic archival for database logs and how to recover a database to a specific point in time using the archived logs.

The course covers using EXPLAIN tools to review the access plans for SQL statements and adding indexes to improve SQL performance. We will cover the locking performed by Db2 and the effect the application isolation level has on locking and lock wait conditions. Students will learn how to implement database security, including adding a security administrator, SECADM user, and implement database roles to simplify security management. We will also describe implementing Db2 native encryption for a database.

CE131G: IBM DB2 SQL Workshop for Experienced Users

RM6,440.00

3 Days ILT, VILT

The CE131G: IBM DB2 SQL Workshop for Experienced Users course teaches you how to make use of advanced SQL techniques to access DB2 databases in different environments. This course is appropriate for customers working in all DB2 environments, specifically for z/OS, Linux, UNIX, and Windows.

CE121G: IBM DB2 SQL Workshop

RM4,850.00

2 Days ILT, VILT

This CE121G: IBM DB2 SQL Workshop course provides an introduction to the SQL language.

This course is appropriate for customers working in all DB2 environments, that is, z/OS, VM/VSE, iSeries, Linux, UNIX, and Windows. It is also appropriate for customers working in an Informix environment.

CE031G: IBM DB2 Family Fundamentals

2 Days ILT, VILT

This course provides you with information about the functions of IBM’s DB2, a relational database manager which may be installed under a variety of operating systems on many hardware platforms.

DB2 runs under the z/OS, VM, Linux, UNIX, and Windows operating systems, to name a few.

The course includes discussion of how the DB2 products provide services. The focus is on the services DB2 provides and how we work with DB2, not on its internal workings.

BQ203G: IBM QRadar SIEM Advanced Topics

RM6,780.00

2 Days ILT, VILT

IBM QRadar SIEM provides deep visibility into network, user, and application activity. It provides collection, normalization, correlation, and secure storage of events, flows, assets, and vulnerabilities. Suspected attacks and policy breaches are highlighted as offenses.

This 2-days BQ203G: IBM QRadar SIEM Advanced Topics course walks you through various advanced topics about QRadar such as custom log sources, reference data collections and custom rules, X-Force data and the Threat Intelligence app, UBA and QRadar Advisor, tuning and custom action scripts.

The course also discusses integration with IBM SOAR. Hands-on exercises reinforce the skills learned.

BQ104G: IBM QRadar SIEM Foundations

RM3,969.00

3 Days ILT, VILT

IBM Security QRadar enables deep visibility into network, endpoint, user, and application activity. It provides collection, normalization, correlation, and secure storage of events, flows, assets, and vulnerabilities. Suspected attacks and policy breaches are highlighted as offenses. In this course, you learn about the solution architecture, how to navigate the user interface, and how to investigate offenses. You search and analyze the information from which QRadar concluded a suspicious activity. Hands-on exercises reinforce the skills learned.

In this 3-day instructor-led course, you learn how to perform the following tasks:

Describe how QRadar SIEM collects data to detect suspicious activities
Describe the QRadar SIEM component architecture and data flows
Navigate the user interface
Investigate suspected attacks and policy breaches
Search, filter, group, and analyze security data
Investigate the vulnerabilities and services of assets
Use network hierarchies
Locate custom rules and inspect actions and responses of rules
Analyze offenses created by QRadar SIEM
Use index management
Navigate and customize the QRadar SIEM dashboard
Use QRadar SIEM to create customized reports
Use charts and filters
Use AQL for advanced searches
Analyze a real world scenario

Extensive lab exercises are provided to allow students an insight into the routine work of an IT Security Analyst operating the IBM QRadar SIEM platform. The exercises cover the following topics:

Using the QRadar SIEM user interface
Investigating an Offense triggered by events
Investigating the events of an offense
Investigating an offense that is triggered by flows
Using rules
Using the Network Hierarchy
Index and Aggregated Data Management
Using the QRadar SIEM dashboard
Creating QRadar SIEM reports
Using AQL for advanced searches
Analyze a real-world large-scale attack

The lab environment for this course uses the IBM QRadar SIEM 7.3 platform.

B6290G: IBM Cognos Analytics: Modeling with Data Modules v11.1.x

RM462.00

1 Day ILT, VILT

This training teaches data modelers how to model data using data modules in IBM Cognos Analytics. Users will learn how to create data modules from different sources, such as uploaded files. They will also identify how to customize their data modules by adding joins, calculations, and filters. In addition, they will examine how to group their data (for example, by using navigation paths), how to share their data modules with others, and how to make use of some advanced modeling techniques, such as relative date analysis.

If you are enrolling in a Self Paced Virtual Classroom or Web Based Training course, before you enroll, please review the Self-Paced Virtual Classes and Web-Based Training Classes on our Terms and Conditions page, as well as the system requirements, to ensure that your system meets the minimum requirements for this course.

B6289G: IBM Cognos Analytics: Dashboard Essentials v11.x

RM462.00

1 Day SPVC

This B6289G: IBM Cognos Analytics: Dashboard Essentials v11.1.x course teaches authors how to create dashboards in IBM Cognos Analytics so users can explore and interact with their data and gain insight into their business. You will learn how to add data sources, create and interact with dashboards, and customize content for presentation. You will also learn how to create effective narratives by using stories, and how to use explorations to perform a deeper analysis on your data.

B6259G: IBM Cognos Analytics: Author Reports Advanced v11.x

2 Days ILT, VILT

This B6259G: IBM Cognos Analytics: Author Reports Advanced v11.x course teaches experienced authors advanced report building techniques to enhance, customize, manage, and distribute reports. Additionally, the student will learn how to create highly interactive and engaging reports that can be run offline by creating Active Reports.

B6258G: IBM Cognos Analytics: Author Reports Fundamentals v11.1.x

3 Days ILT, VILT

This course provides authors with an introduction to build reports using Cognos Analytics. Techniques to enhance, customize, and manage reports will be explored. Activities will illustrate and reinforce key concepts during this learning opportunity.

B6255G: IBM Cognos Analytics: Enterprise Administration v11.1.x

RM6,780.00

2 Days ILT, VILT

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.

B6252G: IBM Cognos Framework Manager: Design Metadata Models v11.x

4 Days ILT, VILT

This B6252G: IBM Cognos Framework Manager: Design Metadata Models v11.x offering provides participants with introductory to advanced knowledge of metadata modeling concepts, and how to model metadata for predictable reporting and analysis results using IBM Cognos Framework Manager.

Participants will learn the full scope of the metadata modeling process, from initial project creation, to publishing of metadata to the web, enabling end users to easily author reports and analyze data.

B6159G: IBM Cognos Analytics: Author Reports Advanced v11.0.x

RM3,690.00

2 Days ILT, VILT

This offering teaches Professional Report Authors about advanced report building techniques using relational data models, dimensional data, and ways of enhancing, customizing, managing, and distributing professional reports. The course builds on topics presented in the Fundamentals course. Activities will illustrate and reinforce key concepts during this learning activity.

B6159FG: IBM Cognos Analytics: Advanced Report Writing v11.0.x

RM3,690.00

2 Days ILT, VILT

This offering teaches Professional Report Authors about advanced report building techniques using relational data models, dimensional data, and ways of enhancing, customizing, managing, and distributing professional reports. The course builds on topics presented in the Fundamentals course.

Activities will illustrate and reinforce key concepts during this learning activity.

B6158G: IBM Cognos Analytics: Author Reports Fundamentals v11.0.x

RM5,200.00

3 Days ILT, VILT

This B6158G: IBM Cognos Analytics: Author Reports Fundamentals v11.0.x offering provides Business and Professional Authors with an introduction to report building techniques using relational data models. Techniques to enhance, customize, and manage professional reports will be explored. Activities will illustrate and reinforce key concepts during this learning opportunity.

Out of stock

B6158FG: IBM Cognos Analytics : Basics of creating reports v11.0.x

3 Days ILT, VILT

This offering introduces business and professional authors to the basics of creating reports using relational data models. Techniques to improve, personalize and manage professional relationships will be explored. During this training, activities will illustrate and reinforce the concepts.

B6155G: IBM Cognos Analytics: Enterprise Administration v11.0.x

RM3,690.00

2 Days ILT, VILT

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.

B6152G: IBM Cognos Framework Manager: Design Metadata Models v11.0.x

RM6,720.00

4 Days ILT, VILT

This offering provides participants with introductory to advanced knowledge of metadata modeling concepts, and how to model metadata for predictable reporting and analysis results using Framework Manager. Participants will learn the full scope of the metadata modeling process, from initial project creation to publishing of metadata to the web, enabling end-users to easily author reports and analyze data.

B6098G: IBM Cognos Analytics – Author Active Reports v11.0

1 Day ILT, VILT

This course provides participants with an understanding of Active Report content and functionality within IBM Cognos Analytics – Reporting. Through lecture, demonstrations, and exercises, participants increase their IBM Cognos Analytics experience by building highly interactive reports using Active Report controls, which can then be distributed to and consumed by users in a disconnected environment, including on mobile devices.

B6091G: IBM Cognos Analytics – Departmental Administration v11.0

RM462.00

0.5 Days SPVC

This Web-Based Training course provides students with knowledge and experience in using the administration capabilities available in the IBM Cognos Analytics 11.0 portal. They will learn how to manage the security environment, perform deployment of application content, create and manage data server connections, view and manage runtime activities, such as schedules, and manage some system activities

If you are enrolling in a Self Paced Virtual Classroom or Web Based Training course, before you enroll, please review the Self-Paced Virtual Classes and Web-Based Training Classes on our Terms and Conditions page, as well as the system requirements, to ensure that your system meets the minimum requirements for this course.

B6088G: IBM Cognos Analytics for Consumers v11.0

RM462.00

1 Day SPVC

IBM Cognos Analytics for Consumers (v11.0) will teach consumers how to access content, use reports, create dashboards, and personalize the appearance of IBM Cognos Analytics portal.

If you are enrolling in a Self Paced Virtual Classroom or Web Based Training course, before you enroll, please review the Self-Paced Virtual Classes and Web-Based Training Classes on our Terms and Conditions page, as well as the system requirements, to ensure that your system meets the minimum requirements for this course

B6063G: IBM Cognos Cube Designer – Design Dynamic Cubes v11.0

RM3,450.00

2 Days ILT, VILT

This course provides participants with introductory to advanced knowledge of how to model metadata for predictable reporting and analysis results using IBM Cognos Cube Designer. Participants will learn the full scope of the metadata modeling process, from initial project creation, to publishing a dynamic cube, and enabling end users to easily author reports and analyze data.

B6061G: IBM Cognos Analytics – Author Reports with Multidimensional Data v11.0

2 Days ILT, VILT

This course is designed to guide report authors in building on their expertise with IBM Cognos Analytics by applying dimensional techniques to reports. Through interactive demonstrations and exercises, participants will learn how to author reports that navigate and manipulate dimensional data structures using the specific dimensional functions and features available in IBM Cognos Analytics.

B6059G: IBM Cognos Analytics – Author Reports Advanced v11.0

RM3,690.00

2 Days ILT, VILT

This offering teaches Professional Report Authors about advanced report building techniques using relational data models, dimensional data, and ways of enhancing, customizing, managing, and distributing professional reports. The course builds on topics presented in the Fundamentals course. Activities will illustrate and reinforce key concepts during this learning activity.

B6052G: IBM Cognos Framework Manager: Design Metadata Models v11.0

RM6,720.00

4 Days

This offering provides participants with introductory to advanced knowledge of metadata modeling concepts, and how to model metadata for predictable reporting and analysis results using Framework Manager. Participants will learn the full scope of the metadata modeling process, from initial project creation, to publishing of metadata to the web, enabling end users to easily author reports and analyze data.

B6025G: IBM Cognos Analytics: Introduction to Authoring v11.x

RM462.00

1 Day SPVC

The IBM Cognos Analytics: Introduction to Authoring (v11.0) course presents you with ways to create, enhance, customize, and manage reports and charts using IBM Cognos Analytics – Reporting. Participants will view demonstrations and work through scenarios that illustrate key introductory concepts while exploring the basics of the Reporting tool.

If you are enrolling in a Self Paced Virtual Classroom or Web Based Training course, before you enroll, please review the Self-Paced Virtual Classes and Web-Based Training Classes on our Terms and Conditions page, as well as the system requirements, to ensure that your system meets the minimum requirements for this course.

B6019G: IBM Cognos Analytics: Architecture and Logging v11.0

RM3,450.00

2 Days ILT, VILT

This course is designed to teach participants how to identify components and sub-components of the IBM Cognos Analytics architecture and how to use tools and techniques to provide a foundation to troubleshoot issues. Through lecture and interactive exercises participants will identify IBM Cognos Analytics components, examine how these components interact with Java, and will explore logging to assist when troubleshooting issues.

B6008G: Overview of IBM Cognos Analytics v11.0

1 Day ILT, VILT

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

AS28G: BRMS for IBM i, including Cloud Storage Solutions for i

RM17,847.00

5 Days ILT, VILT

This course covers the features and functions supported by Backup Recovery and Media Services (BRMS). BRMS is an integrated and comprehensive tool for managing backup, recovery, archive, and retrieval operations for a single Power system with IBM i or multiple systems with IBM i at a site or across a BRMS Network. The lectures describe how to perform the supported functions when using a 5250 emulation session, when using System i Navigator, and when using IBM Navigator for i. Students will then have the opportunity to practice in lab exercises what they have learned in lecture.

IT Infrastructure Training and Certification

AS27G: Advanced System Operator Workshop for IBM i (AS27G)

RM10,707.00

3 Days ILT, VILT

This is the follow on course to AS24G. This course teaches advanced operator skills. OL19G may also interest this student.

This course is designed to enhance the skills of an IBM i System Operator. This course explains the concept of how LPAR works and discusses the functions provided by the HMC. We will discuss the IBM i Access Family of products in general and Access Client Solutions, specifically. We will discuss the different types of security that you can implement in order to control who has access to your data and what they can do with that data if they are allowed to access. We will discuss security control via system values, user and group profiles, authorization lists, and adopted authority. This course will help you develop additional skills in the areas of work management and how to create a basic CL program. In the area of CL programming, we discuss concepts of programming, then how to create a basic CL program using the traditional application development tools PDM and SEU. Then, you will learn how to use the GUI tools in RDP (RSE and LPEX). You will also learn the steps to create a menu using SDA. You will learn some tips that you can use to help improve your IBM i operations. We will also discuss how you can use Management Central as a tool to manage a single system or a network of TCP/IP connected Power Systems with IBM i.

AS24G: System Operator for IBM i

RM6,240.00

4 Days ILT, VILT

This introductory course enables a new system operator to develop basic to intermediate level skills needed for day-to-day operations of the Power System with IBM i. Focus is given to using the GUI (IBM i Access Client Solutions and IBM Navigator for i) as well as 5250 emulation sessions to perform tasks including job control, monitoring, sending messages, managing systems devices, and more. Hands-on exercises reinforce the lecture topics and prepare the student to successfully operate a Power System with IBM i.

Learn. Earn. Succeed with IBM Education.

Learn. Earn. Succeed with IBM Education.

Gain expertise with IBM Professional Certification.

Certified IT professionals report high job satisfaction

Frequently Asked Questions

Stay connected. Be the first to know.

Company

Customer Service

Principals

Stay connected. Be the first to know.

Trainocate: A Global Leader in Technology, Business, and People Development