SQL/400 -(M090) – Visualogic

Courses: SQL/400 -(M090)

OBJECTIVE :

Designed for SQL users and programmers who are responsible for reproducing application programs to manipulate AS/400 SQL databases

PREREQUISITE :

Having attended the OS/400 Operating System course
Having basic knowledge and experience of programming and concepts.

AUDIENCE :

AS/400 programmers and data administrators

WHAT WILL YOU LEARN :

Understanding the concepts of SQL/400 programming in IBM AS/400
Creating, retrieving and manipulating information from RDMS table
Incorporating SQL statements in an application program.

METHOD :

Hands-on oriented training with one workstation for each participant.
Participants to design, write and debug programs in this workshop.
Lecturer-assisted and use of computer-generated slides for presentation.
Training materials that include notes with key points and graphics layout.

DURATION : 2 days ( approximately 14 hours )

COURSE CONTENT :

Module 1: Understanding SQL/400 Concepts

Static SQL
Dynamic SQL
Interactive SQL
Query Manager

Module 2: Quick Tour of Query Manager

Module 3: Interactive SQL/400 Environment

Module 4: User & Data Security

Module 5: Creating A Collection/Tables/Indexes

Module 6: SQL Select Clause & Built-In Functions

Module 7: SQL Samples & Assignments

Company

Legal

Support

Connect With Us

© 2024 Visualogic Resources (M) Sdn Bhd. All Rights Reserved