System i (AS/400, iSeries, i5) Accessing DB2 with SQL

Course Details:

Course Outline:

This is intended for development staff needing to view, create or modify data quickly and simply. Also, support staff who need to manipulate data within database files and technical users requiring a more direct interface into database files than that provided by Query/400. You will learn how to start and configure the basic SQL environment and use the basic commands to view, and change selected data within a database.

Pre-requisites:

There are no specific prerequisites but delegates should have basic keyboard skills.

Course content:

• Starting interactive SQL & changing session attributes
• The Database & terminology
• Processing SQL statements interactively
• SQL command prompting
• The Select statement
  • From clause
  • Where clause
  • Order by clause
• SQL column and scalar functions
• Joining tables
  • Different types of joins
  • Multi table joins
  • Unions
• Summarisation of data
  • Grouping records
  • The Having clause
• Nested sub – queries (sub selects)
• Data manipulation
  • The Insert statement
  • Isolation clause
  • Update statement (with SET and WHERE clause)
  • The Delete statement

Follow on Courses:

Delegates should consider the Introduction to Power RPG with SQL (ISSQE) for RPG developers course.

Schedule: