Advanced SQL (Structured Query Language)

Course:   SQLA
Duration:   3 Days
Level:   II
On our website at:   http://www.verhoef-training.com/courses/SQLA.html
 
Course Summary

The SQL Language has evolved and improved in recent years, and this course focuses on these newer language features and how to exploit them correctly and efficiently. The course is aimed at experienced SQL programmers, and assumes prior knowledge of traditional projection, selection, and join techniques, as well as INSERT, UPDATE, DELETE, COMMIT and ROLLBACK statements. The course will combine lecture, text, and a progressive series of nine workshops (approximately three per day) to gain practical experience with newer SQL language elements.

Topics Covered In This Course

REVIEW OF UNIQUE, REFERENTIAL, and

  • TABLE CHECK CONSTRAINTS.

TRIGGERS

  • subject tables
  • trigger events
  • trigger activation time
  • transition variables and tables
  • event monitors

ISOLATION LEVELS

  • Repeatable Read
  • Read Stability
  • Cursor Stability
  • Uncommitted Read

SPECIAL REGISTERS

  • CURRENT DATE / TIME
  • CURRENT DEFAULT TRANSFORM GROUP
  • CURRENT DEGREE
  • CURRENT EXPLAIN MODE
  • CURRENT EXPLAIN SNAPSHOT
  • CURRENT PATH
  • CURRENT QUERY OPTIMIZATION
  • CURRENT SCHEMA
  • CURRENT SERVER

FUNCTIONS

  • Extensive Review of important column functions, scalar functions, as well as row and table functions currently available in latest SQL versions.

SQLCA and SQLDA.

  • Thorough examination of all information available in the SQL Communications Area and SQL Descriptor Area.

STUDY OF LESS-FAMILIAR SQL STATEMENTS

  • CALL (Calling Stored Procedures)
  • COMMENT ON
  • COMMIT
  • CREATE DISTINCT TYPE
  • CREATE EVENT MONITOR
  • CREATE PROCEDURE
  • CREATE TRIGGER
  • CREATE VIEW
  • CREATE GLOBAL TEMPORARY TABLE
  • PREPARE
  • EXECUTE
  • EXECUTE IMMEDIATE
  • EXPLAIN
  • SIGNAL SQLSTATE
  • Statements related to CURSOR MANAGEMENT.
What You Can Expect

After taking this course the student should be able to utilize application programs to embed SQL statements within batch or on-line programs using DB2 or similar SQL-based database management systems.

Who Should Take This Course

Experienced developers who will be using the SQL Language to extract data from DB2 or other relational database systems.

Recommended Prerequisites

Past professional experience using the SQL Language.

Training Style

This class is taught by lecture, text, and progressive hands-on workshops.

Related Courses
Code Course Title Duration Level
SQL
Structured Query Language (SQL)
3 Days
I
Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.