SQL in DB2 Training 22 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 CV021G - Introduction to DB2 for zOS for Systems and Operations Personnel (Live Online Training)

Cegos_Integrata GmbH (8)

Course OutlineGive an overview of the DB2 9 environment, Describe and utilize DB2 Objects, Describe and utilize several DB2 Utilities, Describe the DB2I (DB2 Interactive Facility) environment, Use SPUFI (SQL Processing Using File Input) to compose an...

• Webinar
• Ohne Einstufung

• 12.06.2024 - 14.06.2024
• 3 weitere Termine verfügbar

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 CV041G - z/OS and DB2 Basics for DB2 for z/OS DBA Beginners (Live Online Training)

Cegos_Integrata GmbH (8)

Course OutlineCONTENTS : Introduction, TSO/E and ISPF, Data Sets, JCL and SDSF, DB2 Relational Database Concepts, Structured Query Language (SQL) and SPUFI, DB2 Objects, The DB2 System, DB2 Commands and Program Preparation, DB2 Utilities, DB2 Shutdow...

• Webinar
• Ohne Einstufung

• 10.06.2024 - 14.06.2024
• weiterer Termin verfügbar

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

PREFERRED

SQL - Die Sprache: Interaktives Arbeiten mit SQL (Live Online Training)

Cegos Integrata GmbH (255)

Relationale Datenbanken: Datenbankdesign , Entitätsmengen und Relationen , Normalisierung, Referentielle Integrität , Primär-, Alternativ- und Fremdschlüssel , Integritätsbedingungen   Datendefinition...

• Webinar
• Ohne Einstufung

• 06.05.2024 - 08.05.2024
• 4 weitere Termine verfügbar

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

SQL - Spezial, Teil 1 (Live Online Training)

Cegos Integrata GmbH (255)

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

IBM CV853G - Db2 12 for z/OS Intermediate System Administration (Live Online Training)

Cegos_Integrata GmbH (8)

Course OutlineStarting, stopping, and accessing Db2 Starting Db2 as part of the z/OS IPL process Data set allocation and APF authorization The START DB2 and STOP DB2 commands zParms, DSNTIJUZ, and DSNZPARM Address spaces IRLM and lock storageDb2 comp...

• Webinar
• Ohne Einstufung

• 24.06.2024 - 26.06.2024
• 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

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

Cegos Integrata GmbH (255)

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

SQL - Spezial, Teil 2 (Live Online Training)

Cegos Integrata GmbH (255)

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

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

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

CL464G - Db2 11.1 Advanced Database Administration - Online Training

Fast Lane Institute for Knowledge Transfer

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

• Webinar
• Ohne Einstufung

• 15.07.2024 - 16.07.2024