Verhoef  Training

DB :: DB2 Operations and Recovery

"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 Fundamentals
» DB2 Administration
» 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

3 days   *   Intermediate   *   Lecture and Labs

Course Summary:
This course will provide students with design skills needed to design relational databases. The course is based on the relational theory and is suitable for all platforms running relational or object relational databases such as DB2, Oracle, Sybase and mySQL.

Target Audience:
System and business analysts, Database administrators and programmers that will be involved in the logical data design aspects of systems.

Recommended Prerequisites:
A basic understanding of SQL. A basic understanding of DB2 or attending Verhoef Training's DB2 Overview course would be helpful.

Course Objectives:
Delegates will gain an understanding of what to look for during the design phase. The students will be exposed to all the relevant aspects of logical design and the practical exercises will expose the student to a number of modeling techniques.

Key Topics:

Introduction to relational theory

Entity relationship diagrams

Data normalization

Integrity rules

Data Warehouses

Last modified: 11-Feb-2010

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
  •