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

SQL - Spezial, Teil 1

Overview

This course teaches you how to implement some of the advanced facilities available in RACF. Through a combination of classroom lecture and hands-on lab exercises, you will learn how to establish an RRSF environment, including using RRSF facilities to administer security of remote RACF databases from a single centralized location, allowing users to synchronize password changes among several associated userids, using RRSF facilities to automatically maintain synchronization of two or more separate RACF databases. Other major functions that you will study include RACF sysplex data sharing and sysplex communication, RACF support for z/OS UNIX, DB2 security using RACF, Network Job Entry (NJE) security, operator commands, program control and backup, recovery of the RACF database, PassTickets, digital certificatesand program signature.

Das Seminar SQL - Die Sprache: Interaktives Arbeiten mit SQL vermittelt Ihnen die wesentlichen Elemente von SQL für das interaktive Arbeiten. Nach Besuch der SQL Schulung kennen Sie die zugrundeliegenden Prinzipien - in anderen Worten, Sie kennen das relationale Modell - und können Ihr Wissen und Ihre Fertigkeiten in jeder Umgebung einsetzen, sei es  Oracle, SQL Server, DB2, Access, Sybase oder ein anderes Datenbanksystem der verschiedenen Hersteller. Dieser SQL Kurs liefert auch die Grundlage für Aufgaben im Bereich Datenmanagement und Datenanalyse. 

Unsere Lernplattform LearningHub @Cegos ist Bestandteil dieser SQL Schulung. Neben den digitalen Seminarunterlagen ist das SQL Seminar um weitere Lernformate und Medien angereichert. Um einen nachhaltigen Wissenstransfer in den Arbeitsalltag zu erzielen, wird das SQL Training nach unserem 4REAL-Vorgehensmodell umgesetzt.

Nach dem Seminar kennen Sie die Operationen der relationalen Algebra, Subqueries in der WHERE-Klause, Subqueries in der SELECT-Klausel, Subqueries in der FROM-Klausel, typische Aufgabenstellungen im SQL-Umfeld und können die verschiedenen Lösungsvarianten testen und ihre Performance einschätzen. Sie kennen die Auswirkungen der verschiedenen Isolation Level auf Performance bzw. Korrektheit der Daten. Sie kennen die Tücken von NULL, die Fallen der dreiwertigen Logik sowie die Stärken und Schwächen von SQL. Sie können Ihr Wissen und Ihre Fertigkeiten in jeder Umgebung einsetzen, sei es Microsoft SQL Server, IBM DB2, Oracle, Sybase, PostgreSQL, Access, MySQL, Ingres oder ein anderes Datenbanksystem der verschiedenen Hersteller.

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

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.