This workshop will be held from 8:00am - 2:45pm with the following breaks: 10:00-10:15am and 11:30am-12:00pm.

Attendance at this workshop is by registration only and additional fee of $295.00. Register for the workshop via the conference registration form, or call 800-777-6734.

You finally have a grasp of SQL (Structured Query Language) basics. In fact, you are comfortable doing the simple things with SELECT, UPDATE, INSERT, and DELETE. However, when you try to go beyond the basics, attempting more complex SQL statements, it is a challenging and/ or a frustrating experience. If this is your experience, this six-hour workshop is for you. Bottom line is that this workshop is designed for those people that have a good understanding of SQL basics and want to take their SQL skills to the next level.

Morning:
The workshop will start with a quick review of some SQL basics and then progress to using SQL built in functions for data manipulation and analysis to derive a new column, name a derived column, reformat data, change data types, summarize data, and more. Next you will explore basic subselect,
scalar subselect, and the more advanced forms of subselect; and see how a single SQL statement with subselect can be used in place an RPG or Cobol (or C) program that would require many lines of code.

Afternoon:
The afternoon part of this workshop will show how the information from the morning session can be put to work for you. You will learn how to embed SQL in an RPG or Cobol (or C) Program including: embedded SQL source statement format, processing single and multiple rows using embedded SQL,
prompting of SQL statements within an RPG or Cobol source program, error handling, and program compilation tips. Next you will review the SQL procedure language and how it is used to create SQL stored procedures and SQL triggers. You will understand the difference between an external procedure and an SQL procedure, and an external trigger and an SQL trigger.
You will explore SQL triggers in detail and learn the difference between column, row, and statement level triggers, and you will learn the various parts that make up an SQL trigger and how to code the SQL trigger body.

After attending this workshop, you will understand how to use SQL built in functions to do data manipulation and analysis, and how to use subselect and scalar subselect to write complex SQL statements that reference multiple tables without having to do a table join. You will also understand how to embed and compile SQL statements in an RPG or Cobol (or C) program, create and use SQL (and external) stored procedures, and create and use SQL triggers. Skip Marchesani will combine lecture with live demonstrations (via the internet) to illustrate the SQL concepts and functions discussed in this workshop.