DB2 Schulungen finden - Das passende Seminar in Ihrer Nähe

Overview

Course RPG IV Programming Fundamentals Workshop for IBM i (AS06G) teaches the basics of the IBM i RPG IV programming language. It is the first of two courses that should be attended in sequence.

This course is a comprehensive exposure to the basic features and functions of RPG IV for Version 7. It does not introduce either information processing or programming in general. Students who are new to programming should attend other courses that are offered by local technical colleges or self-study methods.

This course is designed to enable a trained programmer to develop and maintain simple RPG IV programs written using the latest features and techniques available in the Version 7 compiler.

Sie möchten Daten aus einer SQL-Datenbank wie z.B. MS SQL Server, Oracle, DB2 abfragen und suchen eine verständliche Einführung mit praxisorientierten Übungen? Anhand des Microsoft SQL Server werden Sie zum Beginn des Seminars verstehen lernen, warum eine Datenbank Daten auf verschiedene Tabellen aufteilt. Im Hauptteil werden Sie einzelne Tabellen und dann mehrere Tabellen abfragen, sortieren und gruppieren. Abschließend werden Sie auch komplexere Berechnungen durchführen wie z.B. Welchen Umsatz macht mein Unternehmen in welcher Filiale?.

Daten zählen heute zu den wichtigsten Ressourcen - und SQL ist der Schlüssel, um sie effizient zu nutzen. Wer Daten strukturiert analysieren, verwalten oder bereitstellen möchte, kommt an der Datenbanksprache SQL nicht vorbei.
In diesem praxisorientierten Seminar erlernen Sie die grundlegenden Konzepte relationaler Datenbanken sowie den sicheren Umgang mit SQL - unabhängig vom eingesetzten System. Sie arbeiten interaktiv mit verschiedenen Datenbanksystemen wie Oracle, SQL Server oder DB2 und festigen Ihr Wissen durch zahlreiche Übungen. Sie haben die Wahl zwischen einer Live-Online- oder Präsenzveranstaltung - jeweils über drei Tage (21 Stunden).
Nach dem Seminar sind Sie in der Lage, Datenbanken zu verstehen, Abfragen zu formulieren und Daten gezielt zu bearbeiten - eine solide Grundlage für datengetriebene Aufgaben in Fachabteilungen, IT-Projekten oder der Anwendungsentwicklung. Besonders geeignet für alle, die sich fundierte SQL-Kenntnisse aneignen oder vorhandenes Wissen systematisch erweitern möchten.

Overview

Do you need to know how to establish a practical performance management program for your z/OS system? This course is designed for new performance analysts to learn to work with the Workload Manager (WLM) in goal mode. Learn concepts of WLM and performance management in the z/OS system using the WLM.

Learn how to analyze Resource Monitoring Facility (RMF) reports and implement service definitions using the WLM Interactive System Productivity Facility (ISPF) application. The course uses z/OS hands-on lab exercises to reinforce the concepts and techniques discussed in lecture.

Hands-on labs

This course includes hands-on lab exercises. Each student team, working on their own z/OS system, will configure RMF, analyze RMF reports to find bottlenecks, and utilize the WLM dialogs to create goals and classification rules in a service definition that manages a supplied z/OS workload.

Overview

Do you need to know how to establish a practical performance management program for your z/OS system? This course is designed for new performance analysts to learn to work with the Workload Manager (WLM) in goal mode. Learn concepts of WLM and performance management in the z/OS system using the WLM.

Learn how to analyze Resource Monitoring Facility (RMF) reports and implement service definitions using the WLM Interactive System Productivity Facility (ISPF) application. The course uses z/OS hands-on lab exercises to reinforce the concepts and techniques discussed in lecture.

Hands-on labs

This course includes hands-on lab exercises. Each student team, working on their own z/OS system, will configure RMF, analyze RMF reports to find bottlenecks, and utilize the WLM dialogs to create goals and classification rules in a service definition that manages a supplied z/OS workload.

Overview

This introductory course enables a new system operator to develop basic to intermediate level skills needed for day-to-day operations of 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 IBM i.

Overview

Learn about the basic Information Management System (IMS): IMS facilities, the IMS database system, and the IMS Transaction Manager (IMS/TM). Explore how these facilities work together and how application programs interact with them in today' s complex enterprise systems.

This course has 30 hours of instruction.

This course uses a Web conference medium with live instructor audio and Internet Web conferenced material. You have chat-type Question and Answer (Q and A) ability, plus live audio. The course is taught 10:00 a.m. to 12:00 noon and 1:00 p.m. to 4:00 p.m. Central time for six work days over a two-week period. Since the course is taught live using Web conferencing methods, you can attend from your home or work. Class durations are approximately one-half day so you can still accommodate daily work responsibilities. You will be contacted prior to class start to receive connection information, hardcopy student materials, and other relevant information.

Course Materials

You will be contacted prior to class start to receive connection information, hardcopy student materials, and other relevant information.

Overview

This course enables the project administrators and ETL developers to acquire the skills necessary to develop parallel jobs in DataStage v11.7. The emphasis is on developers. Only administrative functions that are relevant to DataStage developers are fully discussed. Students will learn to create parallel jobs that access sequential and relational data and combine and transform the data using functions and other job components.

Overview

This course enables the project administrators and ETL developers to acquire the skills necessary to develop parallel jobs in DataStage v11.7. The emphasis is on developers. Only administrative functions that are relevant to DataStage developers are fully discussed. Students will learn to create parallel jobs that access sequential and relational data and combine and transform the data using functions and other job components.

Nach dem Seminar können Sie aufgrund Ihrer Kenntnisse der temporalen relationalen Operationen und der OLAP-Erweiterungen von SQL komplexe fachliche Anforderungen - mit oder ohne temporalem Aspekt - in SELECT-Anweisungen umsetzen. Sie können Ihr Wissen und Ihre Fertigkeiten in jeder Umgebung einsetzen, sei es DB2, Oracle, SQL Server oder ein anderes Datenbanksystem der verschiedenen Hersteller. Auf Grund Ihrer Kenntnisse über die Interne Ebene und die Bedeutung der Indizes für die Performance kennen Sie die Möglichkeiten, wie die Performance einer SELECT-Anweisung verbessert werden kann.