Relational Database Design - A Practical Approach

Course Overview

Students will learn the general principles involved in designing a database that complies with the relational database model.

Who Should Attend

Students enrolling in this course should have a need to design or modify the design of tables to be used in a relational database management system.

Course Objectives

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

  • Be conversant with the terminology used in reference to relational databases and be familiar with the design process.
  • Identify data as fields, group fields into tables, select key fields, and identify table relationships.
  • Identify data problems and apply data normalization techniques to solve them.
  • Use referential integrity and other data integrity techniques to support the accuracy of data in the database.
  • Use criteria and operators and perform appropriate table joins in queries.
  • Understand basic SQL queries and techniques for improving the performance of queries.

    Suggested Prerequisites

    Course Outline

    1 - Introduction to Relational Databases

    • The Basics of Relational Databases
    • Planning the Database

    2 - Designing Tables

    • Deciding on Tables and Fields
    • Selecting Primary Key Fields
    • Identifying Table Relationships
    • More on Keys and Relationships

    3 - Data Normalization

    • Solving Data Problems
    • Higher Normal Forms

    4 - Data Integrity

    • Referential Integrity
    • Field-level Integrity
    • Table-level Integrity
    • Reviewing and Finalizing the Database Design

    5 - Query Basics

    • Performing Queries
    • Multiple Table Queries

    6 - More on Queries

    • Other Types of Queries
    • SQL
    • Optimizing Query Performance

  • Enroll Today

    This is a 1-day class

    Price: $295.00
    Payment Options

    ILT Instructor‑Led Training

    OLL Online LIVE

    GTR  Guaranteed to Run

    Class times are listed Eastern time. This class is available for Private Group Training

    To sort by location or date, click the ‘When’ and ‘Where’ column headings.

    Class dates not listed.
    Please contact us for available
    dates and times.