Preferred method of contact:

Relational Database Design, Tools and Techniques



Course Number



4 Days

View Schedule

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
  • Normalize and denormalize your data to optimize performance
  • Work with integrity constraints
  • Automatically generate database documentation using CASE tools

Important Course Information


  • Access is used as the front-end to an Oracle database and/or a standalone system
  • Oracle's free SQL Developer tool is used as a cross-platform tool to generate SQL/build a database

Course Outline

  • Introduction

An overview of DBMS technology

  • How data is accessed, organized 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 optimizer
  • 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 modeling

  • 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

Normalizing data to design tables

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

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 denormalization vs. accidental denormalization
  • 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
  • Customizing 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


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

Course Schedule

Attend this live, instructor-led course In-Class or Online via AnyWare.

Hassle-Free Enrollment: No advance payment required.
Tuition due 30 days after your course.

May 30 - Jun 2 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare

Jun 27 - 30 Herndon, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare

Aug 8 - 11 AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare

Sep 12 - 15 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare

Oct 31 - Nov 3 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare

Dec 12 - 15 Herndon, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare

Jan 23 - 26 AnyWare Enroll Now

How would you like to attend?

Live, Online via AnyWare

Guaranteed to Run

Bring this Course to Your Organization and Train Your Entire Team
For more information, call 1-888-843-8733 or click here






Course Tuition Includes:

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 course exam on the last day of your course and receive a Certificate of Achievement with the designation "Awarded with Distinction."



Call 1-888-843-8733 or click here »

An experienced training advisor will happily answer any questions you may have and alert you to any tuition savings to
which you or your organization may be entitled.

Training Hours

Standard Course Hours: 9:00 am – 4:30 pm
*Informal discussion with instructor about your projects or areas of special interest: 4:30 pm – 5:30 pm

FREE Online Course Exam (if applicable) – Last Day: 3:30 pm – 4:30 pm
By successfully completing your FREE online course exam, you will:

  • Have a record of your growth and learning results.
  • Bring proof of your progress back to your organization
  • Earn credits toward industry certifications (if applicable)
  • Make progress toward one or more Learning Tree Specialist & Expert Certifications (if applicable)

Enhance Your Credentials with Professional Certification

Learning Tree's comprehensive training and exam preparation guarantees that you will gain the knowledge and confidence to achieve professional certification and advance your career.

Earn 23 Credits from NASBA

This course qualifies for 23 CPE credits from the National Association of State Boards of Accountancy CPE program. Read more ...

"Before taking the Relational Database course, I had tried to learn database design concepts from books. But I found it challenging to follow the technical terminology. Not so in this course--the instructor defined and clarified the basic terms at a level that worked for all of us. Plus, I am now able to run crude queries that help me with the many analyses I need to perform."

- G. Meyrick, Computer System Analyst


Please Choose a Language

Canada - English

Canada - Français