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 :: SQL Curriculum

"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

 

Site Search

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


 

Curriculum Description | Curriculum Roadmap | Curriculum Schedule | Curriculum Feedback

SQL Fundamentals
  » course outline
  » schedule
  » enrolment
  » top
1-day hands-on class
The SQL Fundamentals course covers the basics of the SQL language as used in relational database management systems. This is a generic course with the objective to provide students with the base skills needed to use the SQL language.

DB2 Fundamentals
  » course outline
  » schedule
  » enrolment
  » top
1-day lecture only class
This course is a basic introduction to Database/2 (DB2), IBM's Relational Data Base Management System. It will present the student with a comprehensive overview of the DB2 Product and how it relates to their current environment.

DB2-SQL Application Programming
  » course outline
  » schedule
  » enrolment
  » top
4-day hands-on class
This course will provide delegates with the skills to code moderately complex applications using embedded SQL commands to access data stored in DB2 databases. Hands-on workshops are used to provide delegates with experience of using embedded SQL. The course examines design and performance considerations unique to SQL transaction processing in on-line environments.

Advanced SQL Workshop
  » course outline
  » schedule
  » enrolment
  » top
4-day hands-on class
This course will provide students with additional SQL skills needed to build 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.

DB2 Administration
  » course outline
  » schedule
  » enrolment
  » top
4-day hands-on class
This course will cover DB2 Physical Storage, Data Definition, Application Programming Considerations, Load Related Utilities, Performance Issues, Referential Integrity Implications, DB2 Catalog, Security end Auditing, and the Backup and Recover Processes. Application programmers may find this course to be an excellent tool to sharpen their DB2 skills.

DB2 Applications Performance/Tuning
  » course outline
  » schedule
  » enrolment
  » top
4-day hands-on class
The course provides detailed coverage of DB2 Application Performance Tuning for DB2 4.1. It is intended for DBA’s, analysts and programmers. A good working knowledge of DB2 is a prerequisite.

DB2 Operations and Recovery
  » course outline
  » schedule
  » enrolment
  » top
5-day lecture only class
The course provides detailed coverage of DB2 for z/OS System Recovery and Restart. It is intended for DBAs, systems programmers and anyone responsible for system-wide recovery.

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
  •

  Modified: 
Home | About Us | Courses | Schedules | Our Clients | News and Events | Contact Us
Privacy Statement
 
to top
© 2004-2017 Verhoef Training. All Rights Reserved.


This Site Tracked by OneStat.com