SQL in DB2 38 Veranstaltungen

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 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 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 CV843G - DB2 11 for zOS Database Administration Workshop Part 2 (Live Online Training)

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

• Webinar
• Ohne Einstufung

• 13.05.2024 - 15.05.2024
• 3 weitere Termine verfügbar

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

SQL - Spezial, Teil 1 (Live Online Training)

Cegos Integrata GmbH (256)

Die SELECT-Anweisung und die Operationen der relationalen Algebra: Ausführliche Betrachtung von NULL, NULL und die dreiwertige Logik, TRUE, FALSE, UNKNOWN, NULLs sind gleich, NULLs sind nicht gleich, NULL und COALESCE, Die Restriktion, WHERE-Kla...

• Webinar
• Ohne Einstufung

• 17.06.2024 - 19.06.2024
• weiterer Termin verfügbar

PREFERRED

Datenbanksysteme - Techniken, Systemvergleich, Design (Live Online Training)

Cegos Integrata GmbH (256)

Klassifizierung von Datenbanksystemen: Lineare Datenbanken, Hierarchische Datenbanken, Relationale Datenbanken, Objektorientierte Datenbanken, NoSQL-Datenbanken   Kriterien für das Datenbankdesign: Normalisierung, ER-Modellierung, UML, Redu...

• Webinar
• Ohne Einstufung

• 19.06.2024 - 21.06.2024
• weiterer Termin verfügbar

PREFERRED

IBM CV871G - DB2 10 for z/OS Utilities for Database Administrators (Live Online Training)

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

• Webinar
• Ohne Einstufung

• 08.07.2024 - 10.07.2024

PREFERRED

Datenbanksysteme - Techniken, Systemvergleich, Design

Cegos Integrata GmbH (256)

Klassifizierung von Datenbanksystemen: Lineare Datenbanken, Hierarchische Datenbanken, Relationale Datenbanken, Objektorientierte Datenbanken, NoSQL-Datenbanken   Kriterien für das Datenbankdesign: Normalisierung, ER-Modellierung, UML, Redu...

• Seminar / Kurs
• Ohne Einstufung

• 09.12.2024 - 11.12.2024, Hamburg (DE)

PREFERRED

SQL - Spezial, Teil 2

Cegos Integrata GmbH (256)

OLAP Online Analytical Processing: Der Ausdruck OLAP kann definiert werden als “the interactive process of creating, managing, analyzing, and reporting on data”., Sofern die Daten als konventionelle Tables vorliegen, können die OLAP-...

• Seminar / Kurs
• Ohne Einstufung

• 06.05.2024 - 08.05.2024, Düsseldorf (DE)
• 2 weitere Termine verfügbar

PREFERRED

SQL - Spezial, Teil 2 (Live Online Training)

Cegos Integrata GmbH (256)

OLAP Online Analytical Processing: Der Ausdruck OLAP kann definiert werden als “the interactive process of creating, managing, analyzing, and reporting on data”., Sofern die Daten als konventionelle Tables vorliegen, können die OLAP-...

• Webinar
• Ohne Einstufung

• 01.07.2024 - 03.07.2024
• weiterer Termin verfügbar

PREFERRED

CE131G - DB2 SQL Workshop for Experienced Users - Classroom Training

Fast Lane Institute for Knowledge Transfer

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

• Seminar / Kurs
• Ohne Einstufung

• 08.07.2024 - 10.07.2024, Leinfelden-Echterdingen (DE)

PREFERRED

CL207G - Db2 11.1 Administration Workshop for Linux - Online Training

Fast Lane Institute for Knowledge Transfer

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

• Webinar
• Ohne Einstufung

• 04.06.2024 - 07.06.2024
• weiterer Termin verfügbar

PREFERRED

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

Fast Lane Institute for Knowledge Transfer

This course is designed to teach the students how to prevent SQL performance problems and how to improve the performance of existing SQL.

• Webinar
• Ohne Einstufung

• 13.08.2024 - 15.08.2024

PREFERRED

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

Fast Lane Institute for Knowledge Transfer

This course is designed to teach the students how to prevent SQL performance problems and how to improve the performance of existing SQL.

• Seminar / Kurs
• Ohne Einstufung

• 13.08.2024 - 15.08.2024, Leinfelden-Echterdingen (DE)

PREFERRED

CV852G - DB2 11 for z/OS System Administration - Classroom Training

Fast Lane Institute for Knowledge Transfer

Administrators of DB2 11 for z/OS can acquire a view of the architecture and fundamental processes required to manage a DB2 11 for z/OS subsystem. Engage in lectures and hands-on labs to gain experience to: \tRelate the z/OS IPL process to a DB2 subs...

• Seminar / Kurs
• Ohne Einstufung

• 12.08.2024 - 16.08.2024, München (DE)

PREFERRED

CV722G - DB2 11 for z/OS Application Programming Workshop - Classroom Training

Fast Lane Institute for Knowledge Transfer

This course enables you to acquire the skills necessary to produce application programs that manipulate DB2 databases. Emphasis is on embedding Structured Query Language (SQL) statements and preparing programs for execution.

• Seminar / Kurs
• Ohne Einstufung

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