DB2 89 Veranstaltungen

PREFERRED

IBM CE121G - DB2 SQL Workshop (Live Online Training)

Cegos_Integrata GmbH (8)

Course OutlineIntroduction, Simple SQL Queries, Retrieving Data from Multiple Tables, Scalar Functions and Arithmetic, Column Functions and Grouping, UNION and UNION ALL, Using Subqueries, Maintaining dataObjectiveCode SQL statements to retrieve data...

• Webinar
• Ohne Einstufung

• 03.07.2024 - 04.07.2024

PREFERRED

IBM CE131G - DB2 SQL Workshop for Experienced Users

Cegos_Integrata GmbH (8)

Course OutlineIntroduction Identify the purpose of the clauses in the SELECT statement, Describe the key differences among the IBM DB2 platforms, Describe and use some of the OLAP features of DB2, such as GROUPING functions like CUBE and ROLLUP, and...

• Seminar / Kurs
• Ohne Einstufung

• 08.07.2024 - 10.07.2024, Leinfelden-Echterdingen (DE)

PREFERRED

IBM CL2X3G - DB2 10 for LUW: Basic Administration for Linux and Windows

Cegos_Integrata GmbH (8)

Course OutlineOverview of DB2 on Linux, UNIX and Windows, Command Line Processor (CLP) and GUI usage, The DB2 environment, Creating databases and data placement, Creating database objects, Moving data, Backup and recovery, Database Maintenance, Monit...

• Seminar / Kurs
• Ohne Einstufung

• 18.06.2024 - 21.06.2024, Leinfelden-Echterdingen (DE)

PREFERRED

IBM CV844G - Db2 12 for z/OS Basic Database Administration (Live Online Training)

Cegos_Integrata GmbH (8)

Course OutlinePreface Course Overview, Intended Audience, Course Objectives, Prerequisites Unit 1 - Db2 Relational database concepts Relational Database design, Data access, Interacting with Db2• Catalog and directory Unit 2 - SQL and SPUFI SQL SELEC...

• Webinar
• Ohne Einstufung

• 13.05.2024 - 15.05.2024
• 5 weitere Termine verfügbar

PREFERRED

IBM CL207G - Db2 11.1 Administration Workshop for Linux (Live Online Training)

Cegos_Integrata GmbH (8)

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, Monitor...

• Webinar
• Ohne Einstufung

• 04.06.2024 - 07.06.2024
• 2 weitere Termine verfügbar

PREFERRED

IBM CV042G - Db2 12 for z/OS: Intermediate Database Administration

Cegos_Integrata GmbH (8)

Course OutlineUnit 1Introduction The modern Mainframe Environment, Defining z/OS, What are the benefits of z/OS?, Typical z/OS workloads, Batch processing, Online Transaction Processing, Job roles in the Mainframe environment, z/OS Components and Ser...

• Seminar / Kurs
• Ohne Einstufung

• 12.08.2024 - 16.08.2024, Leinfelden-Echterdingen (DE)
• weiterer Termin verfügbar

PREFERRED

IBM CV042G - Db2 12 for z/OS: Intermediate Database Administration (Live Online Training)

Cegos_Integrata GmbH (8)

Course OutlineUnit 1Introduction The modern Mainframe Environment, Defining z/OS, What are the benefits of z/OS?, Typical z/OS workloads, Batch processing, Online Transaction Processing, Job roles in the Mainframe environment, z/OS Components and Ser...

• Webinar
• Ohne Einstufung

• 10.06.2024 - 14.06.2024
• 2 weitere Termine verfügbar

PREFERRED

IBM CV844G - Db2 12 for z/OS Basic Database Administration

Cegos_Integrata GmbH (8)

Course OutlinePreface Course Overview, Intended Audience, Course Objectives, Prerequisites Unit 1 - Db2 Relational database concepts Relational Database design, Data access, Interacting with Db2• Catalog and directory Unit 2 - SQL and SPUFI SQL SELEC...

• Seminar / Kurs
• Ohne Einstufung

• 26.08.2024 - 28.08.2024, München (DE)
• weiterer Termin verfügbar

PREFERRED

IBM CV964G - Db2 12 for z/OS SQL Performance and Tuning

Cegos_Integrata GmbH (8)

Course OutlineIntroduction to SQL performance and tuning Performance issues Simple example Visualizing the problem SummaryPerformance analysis tools Components of response time Time estimates with VQUBE3 SQL EXPLAIN The accounting trace The bubble ch...

• Seminar / Kurs
• Ohne Einstufung

• 13.08.2024 - 15.08.2024, Leinfelden-Echterdingen (DE)

PREFERRED

IBM CE131G - DB2 SQL Workshop for Experienced Users (Live Online Training)

Cegos_Integrata GmbH (8)

Course OutlineIntroduction Identify the purpose of the clauses in the SELECT statement, Describe the key differences among the IBM DB2 platforms, Describe and use some of the OLAP features of DB2, such as GROUPING functions like CUBE and ROLLUP, and...

• Webinar
• Ohne Einstufung

• 08.07.2024 - 10.07.2024

PREFERRED

IBM CV722G - DB2 11 for z/OS Application Programming Workshop

Cegos_Integrata GmbH (8)

Course OutlineDB2 Concepts, Program Structure I, Program Preparation, Program Structure II, Recovery and Locking Concepts, Dynamic SQL Introduction, Managing Test Data, Performance ConsiderationsObjectiveIncorporate static SQL statements in an applic...

• Seminar / Kurs
• Ohne Einstufung

• 07.08.2024 - 09.08.2024, München (DE)
• weiterer Termin verfügbar

PREFERRED

IBM CV963G - DB2 11 for z/OS Application Performance and Tuning

Cegos_Integrata GmbH (8)

Course OutlineIntroduction to Application Performance and Tuning, List common causes of application performance problems, Evalutate different approaches for detecting the problems, Describe possible solutions, Performance Analysis Tools, Understand c...

• Seminar / Kurs
• Ohne Einstufung

• 27.05.2024 - 31.05.2024, Leinfelden-Echterdingen (DE)

PREFERRED

IBM CV871G - DB2 10 for z/OS Utilities for Database Administrators

Cegos_Integrata GmbH (8)

Course Outline(CV831) utilities review, RUNSTATS, DSN1COPY,REPAIR, and DIAGNOSE, LOAD and REBUILD INDEX performance and availability, Online CHECK DATA, REORG performance and availability, UNLOAD performance and availability, Generic utility jobs (LI...

• Seminar / Kurs
• Ohne Einstufung

• 08.07.2024 - 10.07.2024, Leinfelden-Echterdingen (DE)

PREFERRED

IMS for Java Programmers (Live-Online)

PROTRANET GmbH (68)

In diesem Seminar eignen Sie sich die nötigen Grundkenntnisse in IMS Java an. Sie lernen, IMS Transactions in Java, die mit einer DB2 Datenbank und einer IMS Datenbank verknüft sind, anzuwenden.

• Webinar
• Ohne Einstufung

• 13.05.2024 - 15.05.2024
• 19 weitere Termine verfügbar

PREFERRED

IMS for Java Programmers

PROTRANET GmbH (68)

In diesem Seminar eignen Sie sich die nötigen Grundkenntnisse in IMS Java an. Sie lernen, IMS Transactions in Java, die mit einer DB2 Datenbank und einer IMS Datenbank verknüft sind, anzuwenden.

• Seminar / Kurs
• Ohne Einstufung

• 13.05.2024 - 15.05.2024, München (DE)
• 74 weitere Termine verfügbar

PREFERRED

IBM CV843G - DB2 11 for zOS Database Administration Workshop Part 2

Cegos_Integrata GmbH (8)

Course Outline1: Program preparation and the use of packages part 1• Go through the program preparation steps and execute programs in the DB2 environment using the TSO Attachment Facility• Resolve some of the most commonly occurring problems, for exa...

• Seminar / Kurs
• Ohne Einstufung

• 13.05.2024 - 15.05.2024, Leinfelden-Echterdingen (DE)
• weiterer Termin verfügbar

PREFERRED

IBM CL451G - DB2 11 BLU Acceleration Implementation and Use (Live Online Training)

Cegos_Integrata GmbH (8)

Course OutlineTopics Covered:• BLU Acceleration Concepts• BLU Acceleration Implementation and Use• Implementing Shadow Tables and BLU MQTs• DB2 BLU MPP supportObjectivePlease refer to course overviewMethodepresentation, discussion, hands-on exercises

• Webinar
• Ohne Einstufung

• 10.07.2024 - 11.07.2024

PREFERRED

IBM CL443G - DB2 LUW Performance Tuning and Monitoring for Single or Multiple Partition DBs

Cegos_Integrata GmbH (8)

Course OutlineDatabase Monitoring, Database I/O Management, Table space and Table Design for Performance, DB2 Memory Management, Automated Memory Management, Application Performance Considerations, Using Explain Tools, The DB2 Optimizer, Using Indexe...

• Seminar / Kurs
• Ohne Einstufung

• 01.07.2024 - 05.07.2024, Leinfelden-Echterdingen (DE)

PREFERRED

IBM CV722G - DB2 11 for z/OS Application Programming Workshop (Live Online Training)

Cegos_Integrata GmbH (8)

Course OutlineDB2 Concepts, Program Structure I, Program Preparation, Program Structure II, Recovery and Locking Concepts, Dynamic SQL Introduction, Managing Test Data, Performance ConsiderationsObjectiveIncorporate static SQL statements in an applic...

• Webinar
• Ohne Einstufung

• 10.06.2024 - 12.06.2024
• 3 weitere Termine verfügbar

PREFERRED

IBM CV964G - Db2 12 for z/OS SQL Performance and Tuning (Live Online Training)

Cegos_Integrata GmbH (8)

Course OutlineIntroduction to SQL performance and tuning Performance issues Simple example Visualizing the problem SummaryPerformance analysis tools Components of response time Time estimates with VQUBE3 SQL EXPLAIN The accounting trace The bubble ch...

• Webinar
• Ohne Einstufung

• 13.08.2024 - 15.08.2024
• weiterer Termin verfügbar