Call for Latest Dates
Call us on 0870 7777 388 for availability on this course.
Have questions or need a better city/date? Ask now.
|
Course 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). 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
How to make a booking for the CM104 course
|
