Curso presencial
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.
Emagister S.L. (responsable) tratará tus datos personales con la finalidad de gestionar el envío de solicitudes de información y comunicaciones promocionales de formación con tu consentimiento. Ejerce tus derechos de acceso, supresión, rectificación, limitación, portabilidad y otros, según se indica en nuestra política de privacidad.
Sedes
Localización
Fecha inicio
Requisitos
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
Temario completo de este curso