MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Relational Database Design

Course Summary

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

  • +

    Course Syllabus

    • Introduction
      • Welcome
      • Things You Should Know Before Starting This Course
      • Tools You Need For Database Design
      • How To Set Up MySQL Workbench
    • Database Basics
      • What Is A Database?
      • Different Types of Databases?
    • Relational Databases
      • Store Data for Each Component
      • Removes Duplicate Information
      • Ensure Records are Complete
      • Prevent Inconsistent and Conflicting Data
      • Combine Different Data Sets Easily
      • Increased Security
    • Data Modelling Process
      • What Is Data Modelling And The Design Process?
      • Determine The Goal Of The Database
      • Consider the Current System
      • Gathering Requirements of the Database
      • Finding Exceptions to the Rules
    • Database Design
      • Identifying Entities
      • Defining the Attributes
      • Normalisation
      • First Normal Form - Part 1
      • First Normal Form - Part 2
      • Relationships
      • Second Normal Form - Part 1
      • Second Normal Form - Part 2
      • Third Normal Form
    • Design Considerations
      • Data Types and Precision
      • Integrity Constraints
      • Naming Conventions
      • Lookup Tables and Auditing
    • Conclusion
      • Implementation and Next Steps

Course Fee:
USD 67

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Open Source and Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top