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 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
4 days   *   Advanced   *   Lecture and Labs

Course Summary:
Structured Query Language (SQL) is the most popular language used to communicate with Relational Databases. SQL statements are used to perform tasks such as defining, loading, updating or retrieving data from a database. SQL supports a number of advanced features that make your queries more intelligent and efficient. This course will provide delegates with the SQL skills needed to build simple or complex interactive queries against data which is stored in DB2 (or similar) databases. A progressive series of hands-on exercises provide the student with experience in using the language.

Target Audience:
Anyone who will be using SQL to extract data from DB2 or other Relational Database Management System.

Recommended Prerequisites:
Delegates for this course should have a good working knowledge of the SQL SELECT statements.

Course Objectives:
After completing this course, the delegate should be able to:

  • Exhibit SQL knowledge and literacy
  • Develop and use of SQL to an advanced level
  • Apply SQL performance related practices to their code
  • Apply knowledge with relevant practical exercises

    Assessments are done throughout the course in the form of practical assignments that the delegates are required to complete as part of the course content.

    Key Topics:

  • Relational Database Systems
  • SQL for Basic Data Retrieval
  • Using the SQL Built-in Functions
  • Using Subqueries
  • JOIN Review and JOIN Techniques
  • CASE, CAST and Summary Tables
  • Using Temporary Tables
  • Common Table Expressions and Recursive SQL
  • Performance Considerations

    Last modified: 13-Dec-2017

  • 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