Course Description
This 3-day course provides participants with the knowledge and skills needed to access and manipulate data in the IBM iSeries (AS/400) database using Structured Query Language (SQL). The course covers the fundamentals of SQL, including querying, updating, and managing data, as well as advanced topics such as joins, subqueries, and performance optimization. Participants will gain hands-on experience in writing SQL queries to retrieve and update data, create database objects, and generate reports.
Duration
3 Days
Course Objectives
- Understand the basic structure of databases on the iSeries and how SQL interacts with them.
- Write SQL queries to retrieve and filter data from iSeries databases.
- Perform data manipulation operations such as insert, update, and delete using SQL.
- Use SQL to create and manage database objects like tables, indexes, and views.
- Implement advanced SQL techniques, including joins, subqueries, and grouping.
- Optimize SQL queries for better performance on the iSeries platform.
Course Audience
- Database administrators and developers working with the iSeries.
- IT professionals and system administrators who need to query and manage iSeries data.
- Business analysts and report developers who use SQL for data extraction and reporting.
- Anyone interested in enhancing their SQL skills specifically for the iSeries environment.