Course not currently available

SQL

WDR

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.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

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