Preferred method of contact:

Relational Database Design, Tools and Techniques



Course Number



4 Days
Request Team Training

PDF Add to WishList

Relational databases often drive the company-critical and web-enabled applications essential for achieving success in a highly competitive market. This training course is designed to deliver the groundwork for building and working with relational databases — including Oracle, SQL Server, and MySQL — and enabling you to develop and use relational databases in your environment.

You Will Learn How To

  • Design, build, and use a relational database using proven methods
  • Ensure database designs accurately model business requirements
  • Normalise and denormalise your data to optimise performance
  • Work with integrity constraints
  • Automatically generate database documentation using CASE tools

Important Course Information

  • Software

    • Oracle's free SQL*Developer Data Modeler is used to design and generate a database
    • PostgreSQL RDBMS along with the SQL Workbench/J IDE are used for database demonstrations and samples
    • Concepts apply to any relational database environment

Course Outline

  • Introduction

An overview of DBMS technology

  • How data is accessed, organised and stored
  • The database development process

DBMS and related user tools

  • Query and application development tools
  • CASE tools for database analysis and design
  • How a Relational DBMS Works

Relational technology fundamentals

  • Tables, attributes and relationships
  • Primary and foreign keys
  • Relational integrity constraints
  • Manipulating data: selection, projection, join, union, intersection, difference

Components of a relational DBMS

  • An integrated, active data dictionary
  • The query optimiser
  • Designing Relational Databases

A step-by-step approach and techniques

  • Developing the logical data model
  • Mapping the data model to the relational model
  • Specifying integrity constraints
  • Defining the data in the data dictionary

Entity-relationship modelling

  • Capturing entities, attributes and identifiers
  • Describing relationships: one-to-one, one-to-many, many-to-many
  • Optional and mandatory relationships
  • Resolving many-to-many relationships for implementation

Normalising data to design tables

  • Avoiding update anomalies
  • Identifying functional dependencies
  • Applying rules for normalisation

Working with a CASE tool

  • Generating the SQL to build the database
  • Reverse engineering to capture the design of an existing database

Physical database design

  • Assigning tables to disk files for performance and maintenance
  • Fragmenting large tables
  • Planned denormalisation vs. accidental denormalisation
  • Indexing for performance and integrity
  • Building and Querying a Relational Database

Fundamentals of SQL

  • A dynamic and evolving language
  • ANSI and ISO standards

Creating a relational database

  • Defining the database and its objects: tables, keys, views and indexes
  • Declaring integrity constraints

Accessing the database with SQL

  • Querying the database to retrieve desired information
  • Updating data while maintaining database integrity

Constructing and using views

  • Defining views for simplicity and security
  • Customising windows into the database
  • Querying and updating through views
  • The Future of Database Design

Enforcing business rules for data integrity

  • Defining declarative constraints
  • Server-side programming in a procedural language


  • Modelling in analysis and design
  • Focusing on business rules
  • Creating an intelligent server
Show complete outline
Show Less

Exclusive Private Team Training Course

Enhance your team's effectiveness and boost productivity with this course, delivered privately to your organization or to any preferred location, including options for hybrid or all-virtual delivery via AnyWare.

This training course could be customized, and combined with other courses, to meet the specific needs of your team's training.

Preferred method of contact:

Attendee Benefits

After-Course Instructor Coaching
When you return to work, you are entitled to schedule a free coaching session with your instructor for help and guidance as you apply your new skills.

Free Course Exam
You can take your Learning Tree course exam on the last day of your course or online any time after class.


- ,

Chat Now

Please Choose a Language

Canada - English

Canada - Français