Relational Database Design Training: Tools and Techniques

Level: Foundation
Rating: 4.7/5 4.70/5 Based on 54 Reviews

This Relational Database Design 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 to design your database to model your business requirements, normalize and denormalize data to optimize performance, and automatically generate database documentation using CASE tools. You will also learn how to simplify code and improve performance by avoiding common database design errors.

Key Features of this Relational Database Design Training

  • After-course instructor coaching benefit
  • Learning Tree end-of-course exam included
  • After-course computing sandbox included

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

Choose the Training Solution That Best Fits Your Individual Needs or Organizational Goals


In Class & Live, Online Training

  • 4-day instructor-led training course
  • After-course instructor coaching benefit
  • Learning Tree end-of-course exam included
View Course Details & Schedule

Standard $3285 CAD

Government $2890 CAD




Team Training

  • Bring this or any training to your organization
  • Full - scale program development
  • Delivered when, where, and how you want it
  • Blended learning models
  • Tailored content
  • Expert team coaching

Customize Your Team Training Experience


Save More On Training with FlexVouchers – A Unique Training Savings Account

Our FlexVouchers help you lock in your training budgets without having to commit to a traditional 1 voucher = 1 course classroom-only attendance. FlexVouchers expand your purchasing power to modern blended solutions and services that are completely customizable. For details, please call 888-843-8733 or chat live.

In Class & Live, Online Training

Time Zone Legend:
Eastern Time Zone Central Time Zone
Mountain Time Zone Pacific Time Zone

Note: This course runs for 4 Days

  • Feb 15 - 18 9:00 AM - 4:30 PM EST New York / Online (AnyWare) New York / Online (AnyWare) Reserve Your Seat

  • Apr 11 - 14 9:00 AM - 4:30 PM EDT Ottawa / Online (AnyWare) Ottawa / Online (AnyWare) Reserve Your Seat

  • Aug 16 - 19 9:00 AM - 4:30 PM EDT New York / Online (AnyWare) New York / Online (AnyWare) Reserve Your Seat

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 — will run. Guaranteed.

Relational Database Design 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

Relational Database Design 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

Team Training

Relational Database Design Training FAQs

  • Which database environment does this course focus on?

    The database environments this course focuses on are relational databases including Oracle, SQL Server, and MySQL.

  • Can I learn relational database design online?

    Yes! We know your busy work schedule may prevent you from getting to one of our classrooms which is why we offer convenient online training to meet your needs wherever you want, including online training.

Questions about which training is right for you?

call 888-843-8733
chat Live Chat

Why do we require your location?

It allows us to direct your request to the appropriate Customer Care team.

100% Satisfaction Guaranteed

Your Training Comes with a 100% Satisfaction Guarantee!*

*Partner-delivered courses may have different terms that apply. Ask for details.

New York / Online (AnyWare)
Ottawa / Online (AnyWare)
New York / Online (AnyWare)
Why do we require your location?

It allows us to direct your request to the appropriate Customer Care team.

Preferred method of contact:
Chat Now

Please Choose a Language

Canada - English

Canada - Français