Verhoef Training USA

Training Courses and On-Line Classes Preferred By IT Pros

Visit us at:   http://www.verhoef-training.com

103 Hillside Ave., PO Box 1515
West Caldwell, NJ 07006
Main Office:  800.631.0410
Sales Office:  800.533.3893

SQL Fundamentals (Cross Platform)

Course:   SQLDB2CP
Duration:   2 Days
Level:   I
On our website at:   http://www.verhoef-training.com/courses/SQLDB2CP.html
 
Course Summary

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:

  • Subsystem
  • Instance
  • Database
  • Tablespace
  • Tables
  • Views
  • MQT
  • Attributes
  • Nulls
  • RI
  • DB2 catalog

Relational Database Concepts:

  • The Relational Model
  • Domains
  • Integrity and Relationships
  • Structured Query Language (SQL)
  • Unknown Values (NULL)
  • Basic Datatypes

Access Methods:

  • SPUFI
  • Data Studio
  • Control Centre
  • Query editor

Basic Data Retrieval:

  • SELECT Statement
  • Using SELECT
  • Projecting Columns Onto the Result
  • Basic Predicates
  • Expressions in the SELECT Clause
  • Expressions in the WHERE clause

Intermediate Data Manipulation:

  • Compound Conditions
  • Other WHERE Clause Operators
    • BETWEEN
    • IN
    • LIKE
    • IS NULL
    • Using DISTINCT
    • Basic Predicates
    • ORDER BY Clause

Built-in Functions:

  • Working with Datatypes and Casting
  • Functions Involving NULLs
  • CASE Statements

Aggregation:

  • SUM, AVG, MIN, MAX & COUNT Functions
  • Grouping Results with GROUP BY
  • Filtering Groups with HAVING
  • Scalar Functions

Joins:

  • Inner Equi-Join
  • Join Classification
  • Cartesian Products
  • Inner Joins of More than 2 Tables

Data Modification:

  • INSERT
  • UPDATE
  • DELETE
  • MERGE
  • COMMIT and ROLLBACK
Who Should Take This Course

This course is for Users, Developers or Analysists who will be using SQL to access the data.

Recommended Prerequisites

Students should ideally be familiar with basic programming concepts.

Training Style

Lecture and Hands on Workshops with the differences between DB2 for z/OS, Linux and Microsoft SQL Server reviewed and explained.

Related Courses
Code Course Title Duration Level
DB2LUW
DB2 LUW (Linux, UNIX, Windows) FOR PROGRAMMERS
4 Days
I
Details
SQLADB2C
SQL Advanced Functionality (Cross Platform)
3 Days
II
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.