Home | About Us | Courses | Schedules | Our Clients | News and Events | Contact Us | Careers  

Accredited SERVICES SETA Education and Training Provider as per www.serviceseta.org.za
Verhoef  Training

DB2 :: Advanced SQL for DB2 Workshop

"Going the extra mile with ICT"

PO Box 2466, Cape Town 8000, South Africa
tel: 0861-102017 • fax: +27 21 856-0042 • e-mail: training@verhoef.co.za

 

Related Courses
» DB2-SQL Application Programming
» DB2 Applications Performance/Tuning

Curricula Info
» MVS - z/OS - z/VM
» DB2 - SQL
» CICS TS
» IBM MQ
» Programming
» UNIX - Linux
» Networking
» Web Technologies
» Business Skills

Resources
» IBM Support
» IBM Redbooks
» Mainframe Month
» Mainframes.com
» z/Journal
» CIO Magazine
» Search390.com
» Linux Links
» XML Writer

Links
» CICS Central
» Programmer's Heaven
» Develoment Guru
» COBOL Centre
» COBOL User Groups
» REXXLA Home
» XML.com

Verhoef Sites:
» Verhoef USA
» Verhoef UK


 

Curriculum Description | Curriculum Roadmap | Curriculum Schedule | Course Enrolment
3 days   *   Advanced   *   Lecture and Labs

Course Summary:
This course will provide students with SQL skills needed to build simple or complex interactive queries against data which is stored in DB2 (or similar) databases. The course includes an introduction to the structure and function of the DB2 product, and a comprehensive examination of the SQL language, including a progressive series of hands-on workshops to provide the student with experience in using the language.

Target Audience:
Anyone who will be using SQL to extract data from DB2, SQL/DS, or other relational database management system.

Recommended Prerequisites:
Must have attended Verhoef’s DB2/SQL Application Programming course.

Course Objectives:
The course includes a comprehensive examination of the SQL language, including a progressive series of hands-on workshops to provide the student with experience in using the language. The acquired knowledge could also be utilized by applications programmers to embed SQL statements within batch or on-line programs using DB2, SQL/DS, or similar SQL-based database management systems.

Assessment processes are built into the course for delegates. Assessments are done throughout the training in the form of written knowledge questionnaires and practical assignments that the delegates are required to complete as part of the course content.

Key Topics:

  • Introduction to relational database systems
  • Overview of SQL and it’s various language interfaces
  • Plans and packages
  • Compile Procedures and language interfaces
  • Complex data retrieval
  • Using the COMMIT statement and database recovery
  • Introduction to Dynamic SQL and other DB2 features
  • Workshops using Dynamic and embedded SQL in host languages

    Last modified: 19-Dec-2016

  • Site Map

     Home
      |
      •-- About Us
      |----Our Mission
      |----BEE Strategy
      |----Complaints
      |----Careers
      |----PAIA manual
      •-- Courses
      •-- Schedules
      •-- Our Clients
      •-- News and Events
      •-- Contact Us
      •-- Your Privacy
      |
      •-- MVS - z/OS - z/VM
      |----Roadmaps
      |----Schedule
      |
      •-- DB2 - SQL
      |----Roadmaps
      |----Schedule
      |
      •-- CICS TS
      |----Roadmaps
      |----Schedule
      |
      •-- IBM MQ
      |----Roadmaps
      |----Schedule
      |
      •-- Programming
      |----Roadmaps
      |----Schedule
      |
      •-- UNIX - Linux
      |----Roadmaps
      |----Schedule
      |
      •-- Networking
      |----Roadmaps
      |----Schedule
      |
      •-- Web Technologies
      |----Roadmaps
      |----Schedule
      |
      •-- Business Skills
      |----Roadmaps
      |----Schedule
      •

     
    Home | About Us | Courses | Schedules | Our Clients | News and Events | Contact Us
     

      to top
    © 2004-2017 Verhoef Training. All Rights Reserved.


    This Site Tracked by OneStat.com