Overview
This 2-day workshop introduces the delegate to the SQL language, and includes practical sessions in using SQL in an ISPF/TSO environment under z/OS (OS/390).
This training may be available onsite; please contact us if you are interested.
Audience
IT staff intending to use the SQL language.
Skills Gained
Upon completion of the course, delegates should be familiar with using the SQL language.
By The End Of This Course You Will Have Learned
- The SELECT statement
- INSERT/UPDATE/DELETE statements
- how to use EXPLAIN PLAN.
Prerequisites
DB2 Introduction course or equivalent.
Course Outline
- DB2 data types
- Examples of data definition statements
- CREATE, ALTER and DROP statements
- SELECT statement
- INSERT statement
- UPDATE statement
- DELETE statement
- Examples of data control statements
- GRANT and REVOKE statements
- Performance consideration
The training course outline shown above is a standardised version representing all
the dates shown and may vary from the course you attend. You will be sent the actual
course outline when you enquire about a specific date.