| COURSE : |
SQL/400 - (M090) |
| OBJECTIVE : |
Designed for SQL users and programmers who are responsible for
reproducing application programs to manipulate AS/400 SQL databases. |
| PREREQUISITES : |
-> Having attended the OS/400 Operating System course.
-> Having basic knowledge and experience of programming and concepts. |
| 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 which include notes with key points & graphics
layout |
| DURATION : |
2 days (approximately 14 hours). |
| AUDIENCE : |
-> AS/400 programmers and data administrators. |
| WHAT YOU WILL LEARN : |
-> Understanding the concepts of SQL/400 programming in IBM AS/400.
-> Creating, retrieving and manipulating information from RDBMS table.
-> Incorporating SQL statements in an application program. |
| COURSE CONTENT : |
Understanding SQL/400
* SQL concepts
* SQL objects
* Catalog views
Databases and Tables
SQL Coding Techniques
Coding SQL in HLL
Using Interactive SQL
User and Data Security |
Course Contents - SQL/400
