FB

Advanced Database Modeling

This course teaches you a range of advanced tips and strategies for modeling different scenarios, and overcoming common issues found when designing databases.


You'll learn:

  • Some common issues when designing databases and how to avoid them
  • How to model commonly-used fields such as names, addresses, phone numbers, and emails
  • How to effectively use constraints, lookup tables, and audit tables

Get Access to All Courses Now

Access this course and all other courses (and more) in Database Star Academy instantly:

Course Topics:

Table Design

  • Introduction
  • Multiple Values in One Column
  • Alternatives in One Column
  • Entity Attribute Value
  • New Tables for Each Group
  • New Columns for Each Similar Value
  • Calculated Fields
  • Soft Delete
  • Audit Tables

Data Types and Fields

  • Names
  • Address
  • Phone Number
  • Currency
  • Email Address
  • IP Address
  • Use VARCHAR Instead of Char

Constraints

  • Primary Key Constraints with Duplicates
  • Lookup Tables and Check Constraints
  • Polymorphic Association
  • Not Null
  • Conclusion

© 2019 Database Star | Privacy | Terms of Service