Introduction to Relational Databases

Objectives
On successful completion of this course, attendees will be able to:

• Compare relational and other database technologies.
• Describe concepts and terminology involved with a relational database management system.
• Understand the benefits of data modelling, and the stages involved in producing the data model.
• Understand relational table design, and how the data model is mapped to a relational table.
• Describe physical database design, including the data storage and data handling components of a typical relational database and the relationships between them.
• Understand the use of Structured Query Language (SQL) to create relational objects, control security and manipulate data.
• Understand the functions of the relational database system including query execution and optimization, the data dictionary and access control.

Who Should Attend
This course will be of interest to anyone requiring an introduction to relational databases.
Prerequisites
No previous database experience is required, although a general understanding of data processing is assumed. Familiarity with the MVS operating system and TSO/ISPF would also be of benefit.
Duration
2 days
Course Code
DB01
Contents
Relational Database Concepts



Data Modelling



Relational Table Design



Structured Query Language



Functions Of The RDBMS




There currently exist many different relational database management systems. Whilst the vast majority all utilise Structured Query Language (SQL) to define, control, and manipulate data, and whilst there exists a standard for SQL, some differences still occur in the SQL syntax used between different systems. All examples of SQL statements used in this course are based on IBM''s Database 2 (DB2) relational database system, and reflect DB2 Version 9.