Preferred method of contact:

Relational Database Design Training: Tools and Techniques



Course Number



4 Days

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

  • Extract core business data requirements from source documents
  • Design both conceptual and logical data models using requirements
  • Recognize and accurately model complex data relationships
  • Apply data normalization methods to refine data models
  • Physically deploy a relational schema from a logical model complete with tables, indexes, keys, and constraints

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

  • An Overview of DBMS Technology
  • How data is accessed, organized, and stored
  • Relational and NoSQL database comparisons
  • Roles involved in database design, development, and administration
  • The database development process

  • How a Relational DBMS Works

Relational technology fundamentals

  • Terminology and definitions
  • Tables, attributes and relationships
  • Primary and foreign keys
  • Manipulating data: selection, projection, join, union, intersection, difference

Components of a relational DBMS

  • An integrated, active data dictionary
  • Databases, accounts, and schemas
  • Designing Data Models

A step-by-step approach and techniques

  • Extracting core business information from requirements
  • Generating conceptual data entities
  • Transforming a conceptual model into a logical one
  • Building a physical database from a logical model
  • Building database documentation

Conceptual modeling

  • Capturing core entities
  • Identifying entity attributes
  • Creating unique identifiers
  • Graphically representing a conceptual model

Logical modeling

  • Apply data types to entity attributes
  • Describing relationships: one-to-one, one-to-many, many-to-many
  • Building recursive relationships
  • Understanding different modeling notations
  • Normalization Techniques
  • Avoiding update anomalies
  • Identifying functional dependencies
  • Applying rules for normalization
  • Normalizing multi-valued attributes
  • Building a Relational Database

Physical database design

  • Implementing keys from unique identifiers
  • Building foreign keys from relationships
  • Enforcing business rules with check constraints

Working with design software

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

Applying best practices to database design

  • Natural versus surrogate keys
  • Exploring lookup table deployment options
  • Examine vertical and horizontal data partitioning strategies
  • Using record timestamps

Show complete outline
Show Less

Convenient Ways to Attend This Instructor-Led Course

Hassle-Free Enrollment: No advance payment required to reserve your seat.
Tuition due 30 days after you attend your course.

In the Classroom

Live, Online

Private Team Training

In the Classroom — OR — Live, Online

Tuition — Standard: $2990   Government: $2659

Sep 3 - 6 ( 4 Days)
9:00 AM - 4:30 PM EDT
New York / Online (AnyWare) New York / Online (AnyWare) Reserve Your Seat

Oct 29 - Nov 1 ( 4 Days)
9:00 AM - 4:30 PM EDT
Ottawa / Online (AnyWare) Ottawa / Online (AnyWare) Reserve Your Seat

Dec 3 - 6 ( 4 Days)
9:00 AM - 4:30 PM EST
Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Reserve Your Seat

Jan 21 - 24 ( 4 Days)
9:00 AM - 4:30 PM EST
Toronto / Online (AnyWare) Toronto / Online (AnyWare) Reserve Your Seat

Mar 3 - 6 ( 4 Days)
9:00 AM - 4:30 PM EST
New York / Online (AnyWare) New York / Online (AnyWare) Reserve Your Seat

Apr 28 - May 1 ( 4 Days)
9:00 AM - 4:30 PM EDT
Ottawa / Online (AnyWare) Ottawa / Online (AnyWare) Reserve Your Seat

Jun 2 - 5 ( 4 Days)
9:00 AM - 4:30 PM EDT
Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Reserve Your Seat

Show all dates
Show fewer dates

Guaranteed to Run

When you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time, location — will run. Guaranteed.

Private Team Training

Enrolling at least 3 people in this course? Consider bringing this (or any course that can be custom designed) to your preferred location as a private team training.

For details, call 1-888-843-8733 or Click Here »

This event has been added to your cart.




In Classroom or





Private Team Training

Contact Us »

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.

After-Course Computing Sandbox
You'll be given remote access to a preconfigured virtual machine for you to redo your hands-on exercises, develop/test new code, and experiment with the same software used in your course.

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


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

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. NOTE: Only live, in-class attendance qualifies for NASBA CPEs. 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

Chat Now

Please Choose a Language

Canada - English

Canada - Français