Verhoef  Training

DB :: 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 for z/OS SQL Performance and 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
  •