Relational Database Design

This intensive 2-day course involves an in-depth study of Relational Database design and will provide delegates with a sound foundation in the techniques and underlying concepts concerned with this area of technology. It also examines the main components of a Relational DBMS and illustrates how SQL can be used to access the database. The course consists of formal lecture sessions, individual exercises, case studies and discussion groups.


Objectives

- The concepts and advantages of the Relational Database approach
- The techniques of good Relational Database Design
- The structures underlying Relational Databases
- Using SQL to access the database
Who Should Attend?
This course is aimed at anyone involved in the design and development of relational databases.


Course Content
Introduction
- Database concepts and
terminology
- DBMS Functionality
- Advantages of a DBMS
- DB Architecture
- External Schema
- Conceptual Schema
- Internal Schema

Data Modelling
- E/R Modelling
- Mapping to Relational Model
- The Relational Algebra
- Normalisation techniques
- Rules to apply to get to
1st, 2nd, 3rd, Normal Forms
- Whennotto Normalise

Relational DBMSs
- Fundamentals
- Tables
- Attributes
- Relationships
- Primary/Foreign Keys
- Indexes etc.
- Integrity
- Entity and Referential Integrity
- Main Components
- Data Dictionary
- Query Optimiser
- Concurrency and Recovery
Handling
- Data Security
- Integrity Enforcer
Physical Data Organisation & Design
- Disk Structures
- Indices
- Data Clustering
- Table Fragmentation

SQL to Access DB
- Defining DB Objects
(e.g. Tables, Indexes, Views)
using SQL
- Implementing Integrity
Constraints
- Manipulating the data using
SQL
- Controlling Access to the data
using SQL