Contact

 fidel@fidelcaptain.com
  +1 284 542 4404
  +1 284 542 4404

SiteLock

Follow

Video Lectures
An excellent complement to the Six-Step Relational Database Design™ book that guides you through the six-step database design process in a simple, step by step manner. It is a perfect teaching aid for lecturers using the book as a main or supplemental text, and a great learning aid for anyone wanting to learn the six-step database design process.

 

The first lecture, The Six Steps, teaches you how to create implementable relational database models in six steps. It goes through the six steps outlined in the book detailing each step using a case study to reinforce the methodology. This lecture is recommended for persons wanting to learn the details of each step in the six-step relational database design process.

You can preview all of the videos in the lecture below before you purchase them, and in some instances you can watch the entire video. You can also watch these previews and videos directly on my YouTube channel  .

The downloadable files for the videos are in the .mov and .mp4 formats, and you are free to use them for your own personal use or as part of classroom teaching and learning activities. The videos are NOT to be shared or distributed in any format or on any medium whatsoever. Instructors, please direct your students to this site if they would like to have their own copies of the videos. ALL SALES ARE FINAL.

The Six Steps

  • Overview of The Six-Steps video lecture

    Overview of The Six-Steps video lecture

    This video covers what six-step relational database design is all about; who six-step relational database design is for; and what the six-step database design video series will teach you.

    Watch Video

  • Relational Database Design and the Six-Step Process

    Relational Database Design and the Six-Step Process

    This video covers relational database design; the relational database design process; and relational database design in six easy steps.

    MOV FILE
    FILE SIZE: 32MB
    DIMENSIONS: 1280x720 HD
    DURATION: 6:16
    PRICE: US$1.99
    Watch Video

    MP4 FILE
    FILE SIZE: 190MB
    DIMENSIONS: 1920x1080 HD
    DURATION: 6:16
    PRICE: US$1.99
    Watch Video

  • Step 1 - Discover Entities and Assign Attributes

    Step 1 - Discover Entities and Assign Attributes

    Step one of the six-step relational database design process - Discover entities and assign attributes to these entities.

    This video lecture covers the first step of the six-step relational database design process, which is divided into three sub-steps:
    * Step 1-1: Discover the entities
    * Step 1-2: Assign attributes to each entity discovered
    * Step 1-3: Select identifiers, keys and primary keys from the attributes of each entity discovered

    MOV FILE
    FILE SIZE: 94MB
    DIMENSIONS: 1280x720 HD
    DURATION: 17:52
    PRICE: US$8.99
    Watch Preview

    MP4 FILE
    FILE SIZE: 628MB
    DIMENSIONS: 1920x1080 HD
    DURATION: 17:52
    PRICE: US$8.99
    Watch Preview

  • Step 2 - Derive Unary and Binary Relationships

    Step 2 - Derive Unary and Binary Relationships

    Step two of the six-step relational database design process - Derive unary and binary relationships.

    This video lecture covers the second step of the six-step relational database design process, which is divided into two sub-steps:
    * Step 2-1: Build the Matrix
    * Step 2-2: Fill in the Matrix

    MOV FILE
    FILE SIZE: 56MB
    DIMENSIONS: 1280x720 HD
    DURATION: 10:01
    PRICE: US$6.99
    Watch Preview

    MP4 FILE
    FILE SIZE: 319MB
    DIMENSIONS: 1920x1080 HD
    DURATION: 10:01
    PRICE: US$6.99
    Watch Preview

  • Step 3 - Create Simplified Entity-Relationship Diagram

    Step 3 - Create Simplified Entity-Relationship Diagram

    Step three of the six-step relational database design process - Create simplified Entity-Relationship diagram.

    In this video lecture, we will cover the third step of the six-step relational database design process, which has only one sub-step:
    * Step 3-1: Create simplified E-R diagram

    MOV FILE
    FILE SIZE: 35MB
    DIMENSIONS: 1280x720 HD
    DURATION: 5:57
    PRICE: US$4.99
    Watch Preview

    MP4 FILE
    FILE SIZE: 208MB
    DIMENSIONS: 1920x1080 HD
    DURATION: 5:57
    PRICE: US$4.99
    Watch Preview

  • Step 4 - List Assertions for all Relationships

    Step 4 - List Assertions for all Relationships

    Step four of the six-step relational database design process - List assertions for all relationships.

    In this video lecture, we will cover the fourth step of the six-step relational database design process, which has only one sub-step:
    * Step 4-1: List assertions using the simplified E-R diagram

    MOV FILE
    FILE SIZE: 54MB
    DIMENSIONS: 1280x720 HD
    DURATION: 9:08
    PRICE: US$5.99
    Watch Preview

    MP4 FILE
    FILE SIZE: 344MB
    DIMENSIONS: 1920x1080 HD
    DURATION: 9:08
    PRICE: US$5.99
    Watch Preview

  • Step 5 - Create Detailed E-R Diagram Using Assertions

    Step 5 - Create Detailed E-R Diagram Using Assertions

    Step five of the six-step relational database design process - Create detailed E-R diagram using assertions.

    In this video lecture, we will cover the fifth step of the six-step relational database design process, which has only one sub-step:
    * Step 5-1: Use assertions and the simplified E-R diagram to create detailed E-R diagram

    MOV FILE
    FILE SIZE: 51MB
    DIMENSIONS: 1280x720 HD
    DURATION: 8:04
    PRICE: US$5.99
    Watch Preview

    MP4 FILE
    FILE SIZE: 317MB
    DIMENSIONS: 1920x1080 HD
    DURATION: 8:04
    PRICE: US$5.99
    Watch Preview

  • Step 6 - Transform Detailed E-R Diagram Into an Implementable R-M Diagram

    Step 6 - Transform Detailed E-R Diagram Into an Implementable R-M Diagram

    Step six of the six-step relational database design process - Transform detailed E-R diagram into an implementable R-M diagram.

    In this video lecture, we will cover the sixth step of the six-step relational database design process, which is divided into four sub-steps:
    * Step 6-1: Many-to-many relationships
    * Step 6-2: One-to-many relationships
    * Step 6-3: One-to-one relationships
    * Step 6-4: Combine results to create R-M diagram

    MOV FILE
    FILE SIZE: 78MB
    DIMENSIONS: 1280x720 HD
    DURATION: 13:29
    PRICE: US$8.99
    Watch Preview

    MP4 FILE
    FILE SIZE: 515MB
    DIMENSIONS: 1920x1080 HD
    DURATION: 13:29
    PRICE: US$8.99
    Watch Preview

  • Summary of the six steps

    Summary of the six steps

    Summary of the six-step relational database design process - The six steps summarized.

    In this video lecture, the six steps of the six-step relational database design process are briefly described and summarized.

    MOV FILE
    FILE SIZE: 45MB
    DIMENSIONS: 1280x720 HD
    DURATION: 5:53
    PRICE: US$4.99
    Watch Preview

    MP4 FILE
    FILE SIZE: 219MB
    DIMENSIONS: 1920x1080 HD
    DURATION: 5:53
    PRICE: US$4.99
    Watch Preview

  • 1