IBM

IBM Power Systems - Power Systems for AIX I: LPAR Configuration and Planning- AN11G

Length  –  24 hours

Level –  Intermediate

Overview
Learn how to perform system administration in a Power Systems environment. Learn about the features of PowerVM Editions and how to configure and manage LPARs running AIX V7.1 using the Hardware Management Console (HMC).

Learning Journeys or Training Paths that reference this course:
IBM Power AIX
Power AIX Administrator
Power AIX Administrators: Administrators: Virtualization
IBM Power systems for AIX virtualization

Prerequisites
This introductory course does not require any logical partitioning experience. General TCP/IP knowledge is strongly recommended. This prerequisite can be met by attending TCP/IP for AIX System Administrators AN21G.

Audience
This course is appropriate for system administrators, technical support individuals, and IBM business partners who implement LPARs on IBM Power Systems.

Objectives
Describe important concepts that are associated with managing POWER processor-based systems, such as logical partitioning, dynamic partitioning, virtual devices, virtual processors, virtual consoles, virtual local area network (VLAN), and shared processors.
Describe the features of the PowerVM editions.
Describe the functions provided by the HMC.
Configure and manage the HMC, including users and permissions, software, start and shutdown, remote access features, network configuration, security features, HMC backup and restore options, and the HMC reload procedure.
Describe the rules that are associated with allocating resources, including dedicated processors, processing units for Micro-Partitioning, memory, physical and virtual I/O for AIX and Linux partitions.
Configure and manage LPARs by using the HMC graphical user interface (GUI) and HMC commands.
Power on and power off the Power Systems server Use the HMC to back up and restore partition data.
Perform dynamic LPAR operations (DLPAR).

Course Outline
Introduction to partitioning.
Hardware system overview.
System hardware components.
Hardware Management Console.
Exploring the HMC V8 interface.
Hardware Management Console maintenance.
HMC and managed system maintenance.
System power management.
Planning and configuring logical partitions.
Configuring logical partitions.
Partition operations.
Dynamic LPAR operations.

IBM Power Systems - Power Systems for AIX II AIX Implementation and Administration – AN 12G

Lenght – 40 Hours

Level – Intermediate

Overview
Learn to install, customize, and administer the AIX operating system in a multiuser Power Systems partitioned environment. The course is based on AIX 7.1 running on a Power Systems server managed by Hardware Management Console and provides practical discussions that are appropriate to earlier AIX releases.

Prerequisites
You should already be able to:
Log in to an AIX system and set a user password
Execute basic AIX commands
Manage files and directories
Use the vi editor
Use redirection, pipes, and tees
Use the utilities find and grep
Use the command and variable substitution
Set and change Korn shell variables
Write simple shell scripts
Use a graphic Common Desktop Environment (CDE) interface

These skills can be acquired by attending AIX Basics AN10G or through equivalent AIX or UNIX knowledge. Also, it would be helpful (but not mandatory) if students were familiar with partitioning concepts and technology taught in Power Systems for AIX I: LPAR Configuration and Planning AN11G.

Audience
This intermediate course is intended for system administrators or anyone implementing and managing an AIX operating system in a multiuser Power Systems partitioned environment.

Course Outline
Introduction to IBM Power Systems, AIX, and system administration.
AIX system management tools.
Using system management tools in AIX.
System startup and shutdown.
AIX installation.
AIX software installation and maintenance.
System configuration and devices.
System storage overview.
Working with the Logical Volume Manager.
File systems administration.
Paging space.
Backup and restore.
Security and user administration: Part one.
Security and user administration: Part two.
Scheduling and time.
TCP/IP networking.
TCP/IP networking.
Introduction to Workload Partitions.

IBM Power Systems - AIX Jumpstart for UNIX Professionals – AN14G

Length – 40 hours

Level -Intermediate

Overview
Provide focused training for experienced UNIX administrators on how to install, customize, and administer the AIX operating system in a multiuser POWER (System p) partitioned environment. The course is based on AIX 7.1 running on a Power system managed by Hardware Management Console version 7 and provides practical discussions that are appropriate to earlier AIX releases.

Prerequisites
You should be able to use basic UNIX commands to:
Execute basic AIX commands
Manage files and directories
Use the vi editor
Use redirection, pipes, and tees
Use the utilities find and grep
Use command and variable substitution
Set and change Korn shell variables
Write simple shell scripts
The above skills can be acquired by attending AIX Basics AU130 or AN100 or through equivalent AIX/UNIX knowledge.
In addition, you are expected to have hands-on experience administering a UNIX operating system (such as Solaris, HP/UX, and others) including:
User management and system security
Storage
Networking
System shutdown and restart
Backup and recovery
System task scheduling

Audience
This intermediate course is intended for experienced UNIX system administrators who need training to support their transition to supporting AIX running on POWER processor based systems in a multiuser POWER (System p) partitioned environment.

Course outline
Introduction to AIX and IBM Power systems
AIX system management tools
AIX software installation and maintenance
System configuration and devices
TCP/IP networking
System startup and shutdown
Basics of configuring logical partitions
AIX installation
Working with the Logical Volume Manager
File systems administration
The Object Data Manager
LVM metadata
Disk management procedures
Backup and restore
Error monitoring
System initialization – I
System initialization – II
The AIX system dump facility
Topic 1: Alternate disk installation
Topic 2: Using multibos
Optional Appendix A: Survey of additional AIX facilities
Optional Appendix B: Printers and queues

IBM Power Systems - Power Systems for AIX III: Advanced Administration and Problem Determination AN15G

Length – 40 Hours

Level – Advanced

Overview
This course provides advanced AIX system administrator skills with a focus on availability and problem determination. It provides detailed knowledge of the ODM database where AIX maintains so much configuration information. It shows how to monitor for and deal with AIX problems. There is special focus on dealing with Logical Volume Manager problems, including procedures for replacing disks. Several techniques for minimizing the system maintenance window are covered. While the course includes some AIX 7.2 enhancements, most of the material is applicable to prior releases of AIX.

Prerequisites
You should have basic AIX System Administration skills.
These skills include:
Use of the Hardware Management Console (HMC) to activate a logical partition to run AIX and to access the AIX system console
Install an AIX operating system from an already configured NIM server
Implementation of AIX backup and recovery
Manage additional software and base operating system updates
Familiarity with management tools such as SMIT
Understand how to manage file systems, logical volumes, and volume groups
Mastery of the UNIX user interface, which include use of the vi editor, command execution, input and output redirection, and the use of utilities such as grep
These skills can be developed through experience or by formal training. The recommended training course to obtain these prerequisite skills is:
Power Systems for AIX II: AIX Implementation and Administration AN12G and prerequisites.
If the student has AIX system administration skills, but is not familiar with the LPAR environment, those skills can be obtained by attending the following course:
Power Systems for AIX I: LPAR Configuration and Planning AN11G

Audience
This is an advanced course for AIX system administrators, system support, and contract support individuals with at least six months of experience in AIX.

Course outline
Advanced AIX administration overview
The Object Data Manager
Error monitoring
Network Installation Manager basics
System initialization: Accessing a boot image
System initialization: rc.boot and inittab
LVM metadata and related problems
Disk management procedures, Topic 1
Disk management procedures, Topic 2
Install and cloning techniques, Topic 1
Install and cloning techniques, Topic 2
Advanced backup techniques, Topic 1
Advanced backup techniques, Topic 2
Advanced backup techniques, Topic 3
Diagnostics
The AIX system dump facility
Wrap up / Evaluations

 

IBM Power Systems - AIX Network Installation Management Concepts and Configuration – AN22G

Length  – 16 hours

level – Intermediate

Overview
The primary goal of this course is to provide you with a working knowledge of the fundamental capabilities of the Network Installation Management (NIM) facility of the AIX 7.1 operating system. This course uses a combination of instructor lecture and machine exercises to provide you with practical background knowledge of the topics covered.

Prerequisites
You should have:
Basic knowledge regarding AIX systems administration
Basic knowledge regarding the use of HMC V7 to manage POWER-based managed systems

The following course will provided the needed skills for this course:
Power Systems for AIX I: LPAR Configuration and Planning AN11G

Power Systems for AIX II: AIX Implementation and Administration AN12G

Audience
This course is appropriate for anyone with system administrative duties installing and managing an AIX operating system in a multiuser POWER (System p) environment.

Course Outline
Welcome
NIM overview
Setting up the NIM master
RTE installation
Defining additional base install resources
NIM client backups and restores
Managing the lpp_source and the SPOT resources
NIM client updates

 

IBM Power Systems - Power Systems for AIX – PowerVM I Implementing Virtualization – AN30G

Length – 40 Hours

Advanced

Overview
This course provides an overview of the PowerVM edition’s features on POWER6, POWER7, and POWER8 processor-based systems. It explains the new features and benefits of virtualization including processor virtualization, Virtual I/O Server, and virtual devices, such as virtual Ethernet, virtual SCSI, and virtual Fibre Channel adapters. Basic and advanced configurations of the Virtual I/O Server and its clients are discussed including various availability options.
Expand your knowledge about PowerVM features that were introduced in Power Systems for AIX I: LPAR Configuration and Planning AN11G.

Prerequisites
You must have advanced system administration experience with AIX 6 or AIX 7.
This prerequisite can be met by attending one of the following courses:
Power Systems for AIX II: Implementation and Administration AN12G
Power Systems for AIX III: Advanced Administration and Problem Determination AN15G
AIX Jumpstart for UNIX Professionals AN14G
Alternatively, you must have equivalent AIX and LPAR skills:
General TCP/IP knowledge is strongly recommended. This prerequisite can be met by attending TCP/IP for AIX Administrators AN21G
You are also expected to have logical partition administration skills on Power Systems servers, which can be obtained by attending Power Systems for AIX I: LPAR Configuration and Planning AN11G

 
Audience
This advanced course is appropriate for System Administrators, Technical Support Personnel, and Business Partners responsible for implementing LPARs on IBM Power Systems with AIX servers.

Course Outline
Introduction to partitioning
HMC V8 enhancements
Processor virtualization
Virtual Ethernet
Virtual I/O Server and Shared Ethernet Adapter
Virtual SCSI devices
Virtual network configuration with dual VIOS
Virtual SCSI configurations with dual VIOS
Virtual Fibre Channel devices
HMC Service Management
PowerVM advanced systems maintenance

IBM Power Systems - Power Systems for AIX Virtualization II: Advanced PowerVM and Performance – AN31G

Length – 36 Hours

Overview
You will learn how to implement advanced IBM PowerVM features, such as Active Memory Sharing, Active Memory Expansion, shared dedicated processors, and multiple shared processor pools.
Additionally, you will learn skills to implement, measure, analyze, and tune PowerVM virtualization features for optimal performance on IBM Power Systems servers. This course focuses on the features that relate to the performance of IBM POWER processor-based systems, AIX, and the special monitoring, configuring, and tuning needs of logical partitions (LPARs). This course does not cover application monitoring and tuning.
You will also learn AIX performance analysis and tuning tools that help an administrator take advantage of shared processors and other virtualization features of the IBM Power Systems servers.
Hands-on lab exercises reinforce each lecture and give the students practical experience.

Prerequisites
The LPAR prerequisite skills can be met by attending one of the following classes or you can have equivalent LPAR skills:
Power Systems for AIX – Virtualization I: Implementing Virtualization AN30G.

Audience
This course is for anyone responsible for the system administrative duties implementing and managing virtualization features on a System p server. The audience for this training includes the following:
AIX technical support individuals
System administrators
Systems engineers
System architects

 
Zagadnienia
Welcome
PowerVM features review.
Shared processors and virtual processor tuning.
Multiple shared processor pools and donating dedicated processors.
Active Memory Sharing.
Suspend and Resume.
Active Memory Expansion.
Virtual storage performance.
Virtual network performance.
Virtualization monitoring and performance management tools.
Wrap up/Evaluations.

IBM Storage - Storage Area Networking Fundamentals – SN71G

Length– 32 hours

Intermediate

Overview
IBM offers a comprehensive portfolio of SAN switches, storage, software, services and solutions to reliably bring information to people in a cost effective way. IBM provides flexible, scalable and open standards-based business-class and global enterprise-class storage networking solutions for the on demand world. This course provides an overview of storage network and data center networking technology. It reviews SAN concepts, Fibre Channel architecture, SAN topologies, IBM b-type offerings, IBM offerings from Cisco, and SAN over Ethernet architectures, such as iSCSI and FCoE

Prerequisites
The following course, or equivalent knowledge, is required prior to this course:
• Introduction to Storage SS0

Audience
This is a base course for individuals who are involved in the planning, installing, configuring, and upgrading of IBM systems.

Course Outline
Welcome
SAN Concepts
Fibre Channel
SAN design and topology (1 of 2)
SAN design and topology (2 of 2) (continued)
IBM Fibre Channel b-type switches and directors
Cisco MDS Fibre Channel switches and directors
SAN over Ethernet

IBM Storage - IBM Spectrum Protect 8.1.6 Implementation and Administration TS617G

Length  – 40 Hours

Level: Intermediate 

Overview
IBM Spectrum Protect 8.1.6 is a data backup and recovery solution designed to help you manage your data retention, reduce the cost of storage, and provide appropriate recovery point objectives to meet any service level agreement. IBM Spectrum Protect offers improved efficiency and flexibility using object – based data management and policy driven retention.
This five day course will focus on implementation and basic administration of a IBM Spectrum Protect environment. The hands – on lab exercises are performed on a Windows 2012 environment. The course materials include examples of AIX and Linux commands, when different from Windows.

Prerequisites
Experience navigating Windows 2012/2016.
A basic understanding of concepts regarding client/server relationships.
You may wish to take Introduction to Storage prior to this class:.
Introduction to Storage SS01G or Foundations of Storage SS00DG.

Audience
This lecture and exercise based course is for implementers and administrators who are new to IBM Spectrum Protect data management.

Objectives
Components and concepts.
Installation and configuration.
Interfaces and monitoring.
Storage pools and devices.
Policy management, data movement, and exploration.
Server database and storage pool management.
Client configuration.
Client data protection.
Daily operations and maintenance.
Schedules and reports.

Course Outline
Components and concepts.
Installation and configuration.
Interfaces and monitoring.
Storage pools and devices.
Policy management, data movement, and exploration.
Database and storage pool management.
Client configuration and management.
Client data protection.
Daily operations and maintenance.
Schedules and reports.

IBM Storage - IBM Spectrum Protect 8.1.7 Advanced Administration, Tuning, and Troubleshooting – TS627G

Length– 40 Hours

Level: Advanced

Overview
IBM Spectrum Protect, formerly known as IBM Tivoli Storage Manager, is a data backup and recovery solution designed to help you manage your data retention, reduce the cost of storage, and provide appropriate recovery point objectives to meet any service level agreement. IBM Spectrum Protect offers improved efficiency and flexibility through the use of object-based data management, policy driven retention, and an easy to use interface, the Operations Center.
In this advanced-level course, you streamline your daily operations by implementing the latest features, such as inline data deduplication using storage containers, secure communications, and node replication. You use the Operations Center and administrative command line to manage multiple IBM Spectrum Protect servers and nodes. The hands-on exercises are performed on two Windows 2012 R2 virtual machines.
This course is the second in a two-course series. It is for storage administrators familiar with the daily management of IBM Spectrum Protect, and focuses on the latest features, such as container pool storage. Basic concepts and installation are not covered in this course.
TS617G, the first course in the series, IBM Spectrum Protect 8.1.6 Implementation and Administration, covers basic administration and installation.

Prerequisites
IBM Spectrum Protect version 8.1.6 Implementation and Administration (TS617G)

Audience
This course is for storage administrators familiar with the daily management of IBM Spectrum Protect/Tivoli Storage Manager.

Objectives
After completing this course, you should be able to:
Describe a multi-server IBM Spectrum Protect storage environment.
Manage storage containers and traditional storage pools.
Configure a multi-server environment.
Improve data protection and recovery with replication.
Enable advanced client functions.
Protect and monitor the IBM Spectrum Protect environment.
Use scripting to automate daily processing.
Optimize the IBM Spectrum Protect server and client.
Troubleshoot common problems.
Describe the other IBM Spectrum Protect family products.

Course Outline
IBM Spectrum Protect 8.1.7 environment.
Storage pool management overview.
Multi-site/multi-server management.
Replication and disaster recovery.
Client functions and management.
Daily maintenance and monitoring.
Automation and scripting.
Tuning the server and client for optimization.
Troubleshooting and recovery.
IBM Spectrum Protect additional products.

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

Length– 16 hours

Intermediate

Overview
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.
    

Prerequisites
Knowledge of your business requirements.
IBM Cognos Analytics for Consumers (v11.0) WBT or equivalent knowledge.
IBM Cognos Analytics: Author Reports Fundamentals (v11.0.x) or equivalent knowledge

Audience
Report Authors

Course Outline
Create query models
Build a query and connect it to a report.
Answer a business question by referencing data in a separate query.

Create reports based on query relationships
Create join relationships between queries.
Combine data containers based on relationships from different queries.
Create a report comparing the percentage of change.

Introduction to dimensional reporting concepts
Examine data sources and model types.
Describe the dimensional approach to queries.
Apply report authoring styles.

Introduction to dimensional data in reports
Use members to create reports.
Identify sets and tuples in reports.
Use query calculations and set definitions.

Dimensional report context
Examine dimensional report members.
Examine dimensional report measures.
Use the default measure to create a summarized column in a report.

Focus your dimensional data
Focus your report by excluding members of a defined set.
Compare the use of the filter() function to a detail filter.
Filter dimensional data using slicers.

Calculations and dimensional functions
Examine dimensional functions.
Show totals and exclude members.
Create a percent of base calculation.

Create advanced dynamic reports
Use query macros.
Control report output using a query macro.
Create a dynamic growth report.
Create a report that displays summary data before detailed data and uses singletons to summarize information.

Design effective prompts
Create a prompt that allows users to select conditional formatting values.
Create a prompt that provides users a choice between different filters.
Create a prompt to let users choose a column sort order.
Create a prompt to let users select a display type.

Examine the report specification
Examine report specification flow.
Identify considerations when modifying report specifications.
Customize reporting objects.

Distribute reports
Burst a report to email recipients by using a data item.
Burst a list report to the IBM Cognos Analytics portal by using a burst table.
Burst a crosstab report to the IBM Cognos Analytics portal by using a burst table and a master detail relationship.

Enhance user interaction with HTML
Create interactive reports using HTML.
Include additional information with tooltips.
Send emails using links in a report.

Introduction to IBM Cognos Active Reports
Examine Active Report controls and variables.
Create a simple Active Report using Static and Data-driven controls.
Change filtering and selection behavior in a report.
Create interaction between multiple controls and variables.

Active Report charts and decks
Create an Active Report with a Data deck.
Use Master detail relationships with Decks.
Optimize Active Reports.
Create an Active Report with new visualizations.

 

IBM Cognos Analytics: Enterprise Administration (v11.0.x) – B6155G

Length – 16 hours

Intermediate

Overview
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.

Prerequisites
Knowledge of Web application server architectures.
Security systems administration.
Experience using basic Windows functionality.
Experience using a Web browser.
Knowledge of your business requirements.

Audience
Administrators

Course Outline
Introduction to IBM Cognos Analytics administration
IBM Cognos Analytics components.
Administration workflow.
IBM Cognos Administration.
IBM Cognos Configuration.

Identify IBM Cognos Analytics architecture
Features of the IBM Cognos Analytics architecture.
Examine the multi-tiered architecture, and identify logging types and files.
Examine IBM Cognos Analytics servlets.
Performance and installation planning.
Balance the request load.
Configure IBM Cognos Analytics.

Secure the IBM Cognos Analytics environment
Identify the IBM Cognos Analytics security model.
Define authentication in IBM Cognos Analytics.
Define authorization in IBM Cognos Analytics.
Identify security policies.
Secure the IBM Cognos Analytics environment.

Administer the IBM Cognos Analytics server environment
Administer IBM Cognos Analytics servers.
Monitor system performance.
Manage dispatchers and services.
Tune system performance, and troubleshoot the server.
Audit logging.
Dynamic cube data source administration workflow.

Manage run activities
View current, past, and upcoming activities.
Manage schedules.

Manage content in IBM Cognos Administration
Data sources and packages.
Manage visualizations in the library.
Deployment.
Other content management tasks.

Examine departmental administration capabilities
Create and manage team members.
Manage activities.
Create and manage content and data.
Manage system settings.
Manage Themes, Extensions, and Views.
Share services with multiple tenants.

IBM Analytics - DB2 11.1 Administration Workshop for Linux – CL207G

Lenght – 32 hours

Level – Intermediate

Overview
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.

Prerequisites
Perform basic database administration tasks on a relational database system.
Use basic OS functions such as utilities, file permissions, hierarchical file system, commands, and editor.
State the functions of the Structured Query Language (SQL) and be able to construct DDL, DML, and authorization statements.
Discuss basic relational database concepts and objects such as tables, indexes, views, and joins.

These skills can be developed by taking:
DB2 SQL Workshop.
DB2 Fundamentals.

Audience
This is an intermediate level course for students that will perform Database Administration tasks, who plan, implement, and maintain D22 11.1  databases.

Course Outline
Overview of DB2 11.1.
DB2 Command Line Processor (CLP) and GUI tools.
The DB2 database manager instance.
Creating Databases and Data Placement.
Creating Database Objects.
Moving Data.
Backup and Recovery.
Database Maintenance, Monitoring and Problem Determination.
Locking and concurrency.
Security.

IBM Analytics - DB2 11.1 Advanced Database Administration – CL464G

Length – 16 Hours

Intermediate

Overview
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.

Prerequisites
Perform basic database administration tasks for a DB2 database server, including using DB2 commands like BACKUP and RESTORE.
Utilize Structured Query Language (SQL) and be able to construct DDL, DML, and authorization statements.

These skills can be developed by taking:
CL207 DB2 11.1 Administration Workshop for Linux

Audience
This is an advanced course for DBAs and technical individuals who plan, implement, and maintain DB2 11.1 database.

Course Outline
Advanced Monitoring.
DB2 Table Space Management.
DB2 Database Memory Management.
Database rebuild support.
DB2 database and tablespace relocation.
DB2 Incremental Backup.

IBM Analytics - DB2 11.1 Quickstart for Experienced Relational DBAs- CL487G

Czas trwania- 32 Hours

Intermediate

Informacje o szkoleniu

This course teaches you to perform, basic and advanced, database administrative tasks using DB2 11.1. 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 various db2pd command options. Students will learn how to implement automatic archival for database logs and how to plan a redirected database restore to relocate either selected table spaces or an entire database. The REBUILD option of RESTORE, which can build a database copy with a subset of the tablespaces, will be discussed. We will also cover using the TRANSPORT option of RESTORE to copy schemas of objects between two DB2 databases. The selection of indexes to improve application performance and the use of SQL statements to track database performance and health will be covered. This course provides a quick start to Db2 database administration skills for experienced relational Database Administrators (DBA).

 

Co warto wiedzieć przed szkoleniem?

Participants should have the following skills:
Perform basic database administration tasks on a relational database system
Use basic OS functions such as utilities, file permissions, hierarchical file system, commands, and editor
State the functions of the Structured Query Language (SQL) and be able to construct DDL, DML, and authorization statements
Discuss basic relational database concepts and objects such as tables, indexes, views, and joins
These skills can be developed by taking:

DB2 SQL Workshop
DB2 Fundamentals

 

Dla jakiej grupy odbiorców jest dedykowane szkolenie?

This is an intermediate course for experienced DBAs and technical individuals, with experience on other relational database platforms, who plan, implement, and maintain DB2 11.1 for Linux, UNIX, and Windows databases. These skills can also be utilize to support cloud based databases using DB2 on Cloud or DB2 Hosted environments.

 

Zagadnienia

Topics Covered:
Overview of DB2 11
Command Line Processor (CLP) and GUI Usage
The Db2 Environment
Creating Databases and Data Placement
Creating Database Objects
Moving Data
Backup and Recovery
Locks and Concurrency
Database Maintenance, Monitoring and Problem Determination
Security
Database Rebuild Support
DB2 Database and Table Space Relocation
Using Explain Tools
Using Indexes for Performance
Advanced Monitoring

IBM Security - IBM QRadar SIEM Foundations – BQ104G

Length – 24 hours

Basic

Overview
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 collects data to detect suspicious activities​​​​​​​
Describe the QRadar architecture and data flows
Navigate the user interface
Define log sources, protocols, and event details
Discover how QRadar collects and analyzes network flow information
Describe the QRadar Custom Rule Engine
Utilize the Use Case Manager app
Discover and manage asset information
Learn about a variety of QRadar apps, content extensions, and the App Framework
Analyze offenses by using the QRadar UI and the Analyst Workflow app
Search, filter, group, and analyze security data
Use AQL for advanced searches
Use QRadar to create customized reports
Explore aggregated data management
Define sophisticated reporting using Pulse Dashboards
Discover QRadar administrative tasks

Prerequisites
Before taking this course, make sure that you have the following skills:
IT infrastructure.
IT security fundamentals.
Linux.
Windows.
TCP/IP networking.
Syslog.

Audience
This course is designed for security analysts, security technical architects,
offense managers, network administrators, and system administrators using QRadar SIEM.

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:
Architecture exercises
UI – Overview exercises
Log Sources exercises
Flows and QRadar Network Insights exercises
Custom Rule Engine (CRE) exercises
Use Case Manager app exercises
Assets exercises
App Framework exercises
Working with Offenses exercises.
Search, filtering, and AQL exercises
Reporting and Dashboards exercises
QRadar – Admin tasks exercises

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

IBM Security - IBM QRadar SIEM Advanced Topics – BQ204G

Length – 16 hours

Advanced

Overview
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-day 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.

Prerequisites
Students should be knowledgeable about the following topics:
IT infrastructure
IT security fundamentals
Linux
Windows
TCP/IP networking
Syslog
Foundational skills for the IBM QRadar Security Intelligence Platform
(at least the skills that are taught in the IBM QRadar SIEM Foundations – BQ104 course)

Audience
This course is designed for security administrators and security analysts

Course Outline
Unit 1: Custom log sources
Unit 2: Reference data collections and custom rules
Unit 3: IBM X-Force Threat Intelligence in QRadar
Unit 4: User Behavior Analytics and Advisor with Watson
Unit 5: Tuning
Unit 6: Custom action scripts
Unit 7: IBM SOAR integration

IBM Security -IBM Guardium (V10) Foundations – 8G101G

Length  – 24 hours

Intermediate

Overview
Are you getting ready to administer database security policies? Learn how to configure Guardium V11 to discover, classify, analyze, protect, and control access to sensitive data. You will learn to perform vulnerability assessment, and how to monitor data and file activity. This course also teaches you how to create reports, audits, alerts, metrics, and compliance oversight processes.

Prerequisites
Before taking this course, make sure that you have the following skills:
Working knowledge of SQL queries for IBM DB2 and other databases.
Working knowledge of UNIX commands.
Familiarity with data protection standards such as HIPAA and CPI

Audience
Database administrators, security administrators, security analysts, security technical architects, and professional services using IBM Guardium.

 
Before taking this course, make sure that you have the following skills:
Working knowledge of SQL queries for IBM DB2 and other databases
Working knowledge of NoSQL type databases
Working knowledge of UNIX commands
Ability to use a UNIX text editor such as vi
Familiarity with data protection standards such as HIPAA, PCI, GDPR, and SOX

Course Outline
Identify the primary functions of IBM Security Guardium
Apply key Guardium architecture components
Navigate the Guardium user interface and command line interface
Manage user access to Guardium
Build and populate Guardium groups
Use the administration console to manage Guardium components
Configure policy rules that process the information gathered from database and file servers
Use the configuration auditing system, Vulnerability Assessment application, and Database Discovery to perform data security tasks
Create queries and reports to examine trends and gather data
Automate compliance workflow processes
Use file activity monitoring to keep track of the files on your servers