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

Database Design

Course Summary

Learn relational database Design with practical concepts and examples. This series works with any database system!


  • +

    Course Syllabus

    • Introduction to Databases and Database Design
      • Introduction
      • What is a Database?
      • What is a Relational Database?
      • RDBMS
      • Introduction to SQL
      • Naming Conventions
      • What is Database Design?
      • Data Integrity
      • Database Terms
      • More Database Terms
      • Atomic Values
    • Relationships
      • Relationships
      • One-to-One Relationships
      • One-to-Many Relationships
      • Many-to-Many Relationships
      • Design One-to-One Relationships
      • Designing One-to-Many Relationships
      • Parent Tables and Child Tables
      • Designing Many-to-Many Relationships
      • Summary of Relationships
    • Keys
      • Introduction to Keys
      • Primary Key Index
      • Look up Table
      • Superkey and Candidate Key
      • Primary Key and Alternate Key
      • Surrogate Key and Natural Key
      • Should I use Surrogate Keys or Natural Keys?
      • Foreign Key
      • NOT NULL Foreign Key
      • Foreign Key Constraints
      • Simple Key, Composite Key, Compound Key
      • Review of Keys and Key Points
    • Introduction to Modeling
      • Introduction to Entity Relationship Modeling
    • Resources
      • Blog Posts


Course Fee:
Free

Course Type:

Self-Study

Course Status:

Active

Workload:

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
REDHERRING
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