SQL Advanced Functionality (Cross Platform)
Duration: 3 Days
The course provides advanced relational data base concepts and using SQL (DDL, DML, and DCL (Overview) both for Mainframe, LUW (Linux and Windows) and SQL Server for the relevant version in use by the customer.
The course contains numerous practical exercises on all platforms to consolidate the theory sessions of the course. The exercises will use either SPUFI/ QMF, Data Studio, Control Centre or Query editor (Whichever is appropriate for the version employed by the customer).
Emphasis throughout the course is placed on using SQL efficiently.
The testing environment can be undertaken at the customers premises or using Verhoef Environment.
The course is fully documented. Each student is provided a manual.
Topics Covered In This Course
Multiple Query Blocks:
Table Expressions and Views:
Solving Complex Problems with SQL:
Managing Transactions and Units of Work:
Access paths (Overview):
Differences between DB2 on z/OS, Linux and Microsoft SQL Server reviewed and discussed.
Who Should Take This Course
This course is for Users, Developers or Analysists who will be using Advanced SQL to access the data.
Prospective delegates are expected to have attended the Fundamentals course
Lecture and Hands on Workshops with the differences between DB2 for z/OS, Linux and Microsoft SQL Server reviewed and explained.
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]