Channel | Publish Date | Thumbnail & View Count | Download Video |
---|---|---|---|
Database Star | 2022-01-25 22:00:14 | 76,648 Views |
Learn how to design an effective database and build it using SQL: https://databasestar.mykajabi.com/edd/?utm_sourceviddesc&utm_mediumyoutube&utm_campaign37
Designing a database is an important part of implementing a feature or building a new application (assuming you need to store data).
There are many different ways to store data. The database has some limitations, but many different techniques can still be used.
This may mean that some design concepts used should, in my opinion, be avoided.
I have listed these “database design mistakes” in this video. I explained what they are, why it's not a good idea to use them, and what the solution should be instead.
You may not agree with some of them, and you may have seen others in live production systems that work well. It's OK. This video explains why this is generally not a good idea and what the alternatives are.
Timestamp:
00:00 Introduction
00:25 Error 1 – business field as primary key
02:18 Error 2: storing redundant data
03:24 Error 3 – spaces or quotes in table names
04:49 Error 4 – low or no referential integrity
06:11 Error 5 – multiple information in one field
07:30 Error 6: Storing optional data types in different columns
09:04 Error 7: Using incorrect data types and sizes
Please take the opportunity to connect and share this video with your friends and family if you find it useful.