Advanced SQL (Structured Query Language)
Duration: 3 Days
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
SQLCA and SQLDA.
STUDY OF LESS-FAMILIAR SQL STATEMENTS
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.
Past professional experience using the SQL Language.
This class is taught by lecture, text, and progressive hands-on workshops.
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.
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]