SQL Fundamentals (Cross Platform)
Duration: 2 Days
The course provides relational data base concepts and using SQL (DML) for both Mainframe, LUW (Linux and Windows) and Microsoft SQL Server for the relevant version in use.
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. A Manual is provided to each student
Topics Covered In This Course
Introduction to cross platform DB2 (z/OS Linux and Microsoft SQL Server)
Introduction to Terms/Terminology:
Relational Database Concepts:
Basic Data Retrieval:
Intermediate Data Manipulation:
Who Should Take This Course
This course is for Users, Developers or Analysists who will be using SQL to access the data.
Students should ideally be familiar with basic programming concepts.
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 firstname.lastname@example.org