OD470ES ::: IBM i DB2 and SQL School
Curso
En Madrid
¿Necesitas un coach de formación?
Te ayudará a comparar y elegir el mejor curso para ti y a financiar tu matrícula en cómodos plazos.
Descripción
-
Tipología
Curso
-
Lugar
Madrid
Objetivos Use data definition language (DDL) to describe tables and viewsUse UPDATE, INSERT, ALTER, and DELETE to modify SQL tables and maintain a databaseUse the SELECT statement to extract data from tables and viewsCode SQL queries that include column and scalar functionsCode SQL queries that include inner and outer joinsUse SQL Query Manager Audiencia This intermediate course is designed primarily for experienced IBM i programmers. However, very skilled i system users who want to learn how to use the SQL programming language as a means to access the DB2 for i database may also consider attending this class. Students will learn how to create, maintain, and query the database using the interactive SQL interface and System i Navigator.
Instalaciones y fechas
Ubicación
Inicio
Inicio
A tener en cuenta
Requisitos You should complete:Intro to System i for New Users (OE980)System i Programming Facilities Workshop (OL490)or be able to:Use a Windows-based PCNavigate and use a Windows-based desktopNavigate IBM i menusUse IBM i commandsUse PDM/SEU or LPEX EditorsList the data types that are supported by the DB2 for i databaseExplain the function of Data Description Specifications (DDS) in defining files on the iExplain the use of the data types supported by the DB2 for i database
Opiniones
Materias
- SQL
Temario
- Welcome and Introduction
- Introduction to RDB Management and DB2 for i
- Introducing Structured Query Language
- Extracting Data Using SELECT
- Functions
- JOIN and UNION
- SubSELECT
- Query Manager
- Database Maintenance
- Embedding SQL
- Stored Procedures
- Database Tools with System i Navigator
¿Necesitas un coach de formación?
Te ayudará a comparar y elegir el mejor curso para ti y a financiar tu matrícula en cómodos plazos.
OD470ES ::: IBM i DB2 and SQL School