Relational Database Design

Learn how to create an effective relational database design to use in your IT career or even a personal project.

Intermediate 0(0 Ratings) 0 Students enrolled English
Created by Nam Phạm Tuấn
Last updated Tue, 11-Feb-2025
+ View more
Course overview

Learn how to design a proper relational database with this course!

This course will teach you how to create an effective relational database design using proven concepts and industry knowledge.

Effective database designs will help make systems faster, improve data quality, and ensure future changes are easier.

If you want to improve your software development career, get into database admin or database design, or are just curious on this topic, this course is for you.

You don't need to know SQL or have any programming experience to be able to take this Relational Database Design course.

This course includes:

  • Almost three hours of video lessons
  • Included PDF files of the database diagrams at keys steps will help you learn all about database design.
  • The topics covered include normalization and the normal forms, identifying tables and columns, primary and foreign keys, and setting up relationships.

The videos include explanations of the key topics in the process, as well as demonstrations on how to set up a database using an Entity Relationship Diagram.

I also show you how to download and install the software that is being used for this.

What topics are covered in this database design course?

The topics covered are:

  • We'll walk through a sample database
  • Reason or why the database is needed
  • Some advantages of relational databases
  • Identify entities for the tables and attributes
  • Create tables and columns
  • Reorganise them to make the layout and design more efficient.


If you want to know how to design a database and improve the overall quality of your databases and software, then this is the course for you.

You'll learn all you need to be able to design an effective database!

Curriculum for this course
32 Lessons 00:00:00 Hours
Introduction
4 Lessons 00:00:00 Hours
  • Welcome
    .
  • What Is A Database?
    .
  • Diffierent Types of Databases?
    .
  • Benefits of Relational Databases
    .
Data Modeling Process
7 Lessons 00:00:00 Hours
  • Consider the Current System
    .
  • Gathering Requirements of the Database
    .
  • Finding Exceptions to the Rules
    .
  • Identifying Entities
    .
  • Defining the Attributes
    .
  • What is Data Modeling And The Design Process?
    .
  • Determine The Goal Of The Database
    .
Database Design
6 Lessons 00:00:00 Hours
  • First Normal Form: Student
    .
  • First Normal Form
    .
  • Normalization
    .
  • First Normal Form: Subject
    .
  • First Normal Form: Teacher
    .
  • First Normal Form: University
    .
Second Nomal Form
5 Lessons 00:00:00 Hours
  • Second Normal Form: University
    .
  • Second Normal Form: Teacher
    .
  • Second Normal Form: Student and Subject
    .
  • Relationships
    .
  • Second Normal Form
    .
Third Normal Form
4 Lessons 00:00:00 Hours
  • Third Normal Form Completed
    .
  • Third Normal Form: Teacher and University
    .
  • Third Normal Form: Student and Subject
    .
  • Third Normal Form
    .
Design Considerations
6 Lessons 00:00:00 Hours
  • Implementation and Next Steps
    .
  • Auditing Tables
    .
  • Lookup Tables and Auditing
    .
  • Naming Conventions
    .
  • Integrity Constraints
    .
  • Data Types and Precision
    .
+ View more
Other related courses
14:42:00 Hours
Updated Fri, 27-Dec-2024
0 6 10.499.000₫
00:00:00 Hours
0 1 597.687₫ 292.706₫
00:00:00 Hours
0 0 391.485₫ 194.708₫
00:00:00 Hours
0 1 292.637₫ 194.708₫
00:00:00 Hours
0 0 244.822₫ 194.708₫
About instructor

Nam Phạm Tuấn

0 Reviews | 4 Students | 56 Courses
Student feedback
0
0 Reviews
  • (0)
  • (0)
  • (0)
  • (0)
  • (0)

Reviews

12.124.127₫
Includes: