IBM i DB2 and SQL School

IBM

Kurs

In Stuttgart, Zürich (Schweiz), Wien (Österreich) und 1 weiterer Standort

Preis auf Anfrage

Beschreibung

Kursart

Kurs

Ort

An 4 Standorten

This intermediate course is designed primarily for experienced IBM i programmers. However, very skilled Power Systems with IBM i users, who want to learn how to use the SQL programming language as a means to access the DB2 for i database,/05/also consider attending this class. You will learn how to create, maintain, and query the database using the interactive SQL interface and System i Navigator.

Standorte und Zeitplan

Leinfelden-Echterdingen (Baden-Württemberg)

Karte ansehen

Beginn

auf Anfrage

Stuttgart (Baden-Württemberg)

Beginn

auf Anfrage

Wien (Österreich)

Karte ansehen

Beginn

auf Anfrage

Beginn

auf Anfrage

Zürich (Schweiz)

Karte ansehen

Beginn

auf Anfrage

Hinweise zu diesem Kurs

Voraussetzungen

You should: Complete: Introduction to IBM i for New Users (OE980) IBM i Application Programming Facilities Workshop (OL490) Or be able to: Use a Windows-based PC Navigate and use a Windows-based desktop Navigate IBM i menus Use IBM i commands Use PDM/SEU or LPEX Editors List the data types that are supported by the DB2 for i database Explain the function of Data Description Specifications (DDS) in defining files Explain the use of the data types supported by the DB2 for i database

Fragen & Antworten

Ihre Frage hinzufügen

Unsere Berater und andere Nutzer werden Ihnen antworten können

Wer möchten Sie Ihre Frage beantworten?

Alle
Studierende
Bildungszentrum

Geben Sie Ihre Kontaktdaten ein, um eine Antwort zu erhalten

Es werden nur Ihr Name und Ihre Frage veröffentlicht.

Meinungen

Inhalte

SQL is a very powerful programming and database language that is widely used in business today. For example, SQL can be used to perform interactive database queries as well as to extract data from a server, and pass that data to a Java applet running on a client PC. SQL is frequently used in Power Systems with IBM i high-level languages as an alternate means to access the database.

This course is designed to teach IBM i programmers and highly skilled IBM i users on how to access the database using SQL. You will learn how to create, maintain, and query the database using the interactive SQL interface and System i Navigator.

Training Paths that reference this course are:

Application Developer (DB2, WDSc, RPG, CL, SQL) SQL Path
Application Developer using SQL

Zusätzliche Informationen

Use data definition language (DDL) to describe tables and views
Use UPDATE, INSERT, ALTER, and DELETE to modify SQL tables and maintain a database
Use the SELECT statement to extract data from tables and views
Code SQL queries that include column and scalar functions
Code SQL queries that include inner and outer joins
Use SQL Query Manager

IBM i DB2 and SQL School

Preis auf Anfrage

IBM i DB2 and SQL School

Fragen & Antworten

Meinungen

Inhalte

Fügen Sie ähnliche Kurse hinzu und vergleichen Sie sie, um eine bessere Auswahl zu treffen.