Course not currently available
SQL
Course
In Horsham ()
£ 675
+ VAT
Description
-
Type
Workshop
-
Duration
2 Days
Upon completion of the course, delegates should be familiar with using the SQL language. Suitable for: IT staff intending to use the SQL language.
About this course
DB2 Introduction course or equivalent.
Reviews
Have you taken this course?
Course programme
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).
Course objectives
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.
Who should attend
IT staff intending to use the SQL language.
Pre-requisites
DB2 Introduction course or equivalent.
Course synopsis
- DB2 data types
- Examples of data definition statements
CREATE, ALTER and DROP statements - SELECT statement
WHERE clause; range searches; wildcard searches; column functions; ORDER BY clause; GROUP BY clause; HAVING clause; UNION and UNION ALL clauses; joins and subselects; correlated subqueries; outer joins - INSERT statement
- UPDATE statement
- DELETE statement
- Examples of data control statements
GRANT and REVOKE statements - Performance consideration
SQL
£ 675
+ VAT