How to Design a Database

  Рет қаралды 70,179

Database Star

Database Star

Күн бұрын

Пікірлер: 90
@DatabaseStar
@DatabaseStar Ай бұрын
Want to improve your database design skills? Get my Database Design project Guides here (diagrams, explanations, and SQL scripts): www.databasestar.com/dbdesign/?
@nicholassmith6412
@nicholassmith6412 Жыл бұрын
Videos like this are way more useful than the other bog standard stuff that litters the web - rather than over-explaining 'how to query a, b, c, d and e', your videos cover the more important fundamentals like how to design relational databases properly. The querying can just be googled as you develop, but leaning how to design a database cannot be googled so easily. Thank you
@DatabaseStar
@DatabaseStar Жыл бұрын
Thanks for the feedback and glad you found this useful!
@ayomideashiru554
@ayomideashiru554 Жыл бұрын
This is one of the best straight-to-the-point videos on designing databases on KZbin!!! Amazing!!!
@DatabaseStar
@DatabaseStar Жыл бұрын
Wow, thanks! Glad you liked the video and found it helpful!
@冉-q2u
@冉-q2u 11 ай бұрын
I like your video. I have been studying databases for some time, and I've come across tutorial project videos on KZbin. This is one of the best videos on designing databases on KZbin!!!
@DatabaseStar
@DatabaseStar 11 ай бұрын
Glad it was helpful!
@yassinebouchoucha
@yassinebouchoucha 2 жыл бұрын
most under-rated topic for web developer , keep-up the good work.
@DatabaseStar
@DatabaseStar 2 жыл бұрын
Thanks!
@MohammadNasim-p2b
@MohammadNasim-p2b Жыл бұрын
This amazing brother. No one is talking about these types of fundamental topics. This video is so helpful. Keep up good work.
@DatabaseStar
@DatabaseStar Жыл бұрын
Thanks, glad you like it!
@riccardolacamera
@riccardolacamera 7 ай бұрын
your video was absolutely helpful compared to class lectures about database management, do you have anything on how to design (even with pen and paper) other kind of relationship between tables? Thanks a lot!
@DatabaseStar
@DatabaseStar 7 ай бұрын
Thanks! I've got a couple of videos on my channel about many to many relationships, and one to many relationships. I've also got quite a few examples of designing a database, such as AirBNB or Instagram or school management.
@tech-systemdesign8891
@tech-systemdesign8891 Жыл бұрын
The best channel to learn db design, thank you so much!
@DatabaseStar
@DatabaseStar Жыл бұрын
Thanks!
@tech-systemdesign8891
@tech-systemdesign8891 Жыл бұрын
OMG, finally, your videos are so helpful, I was looking for a while. Thank you so much!!
@DatabaseStar
@DatabaseStar Жыл бұрын
Glad you like them!
@ravindrawaghela9072
@ravindrawaghela9072 7 ай бұрын
One of the best video . Very lucid to understand. ! Thank you from bottom of my heart. :)
@DatabaseStar
@DatabaseStar 7 ай бұрын
Thanks, I’m glad you liked it!
@mastermindrational1907
@mastermindrational1907 8 ай бұрын
This was helpful, although I have a massive database I’m planning. Maybe I will need to break it down into small chunks as I go?
@DatabaseStar
@DatabaseStar 8 ай бұрын
Thanks! Yeah breaking it down will be helpful
@piccell244
@piccell244 Жыл бұрын
I‘m starting out right now and this video is really helping, thanks a lot
@DatabaseStar
@DatabaseStar Жыл бұрын
No problem, glad to hear this video is helpful!
@czhablog9559
@czhablog9559 5 ай бұрын
Wow what an amazing explanation!!!
@DatabaseStar
@DatabaseStar 5 ай бұрын
Glad it was helpful!
@natkhat19jay
@natkhat19jay Ай бұрын
Awesome sir love from india
@DatabaseStar
@DatabaseStar Ай бұрын
Thanks!
@srourganoush5941
@srourganoush5941 2 жыл бұрын
You deserve more likes and subscribers
@DatabaseStar
@DatabaseStar 2 жыл бұрын
Thanks!
@samfreitag729
@samfreitag729 2 жыл бұрын
Wow! Super helpful video man. I wish I started here first....
@DatabaseStar
@DatabaseStar 2 жыл бұрын
Glad it was helpful!
@yoseees5493
@yoseees5493 2 жыл бұрын
This video was incredible! Thank you so much!
@DatabaseStar
@DatabaseStar 2 жыл бұрын
You're so welcome!
@Spkntei
@Spkntei 10 ай бұрын
Good teacher ❤
@DatabaseStar
@DatabaseStar 10 ай бұрын
Thanks!
@porobertdev
@porobertdev Ай бұрын
Extremely helpful!
@DatabaseStar
@DatabaseStar Ай бұрын
Glad to hear it!
@appstuff6565
@appstuff6565 Жыл бұрын
Hi there, thanks for this! I was wondering how we can do with multiple patients at the same time, perhaps create a separate table of patients and how will we identify other patients from that table list?
@DatabaseStar
@DatabaseStar Жыл бұрын
Glad it helped! Yes, you would have a separate table in between patients and appointments to store the patients for each appointment, as it is now a "many to many" relationship.
@debrain1647
@debrain1647 8 ай бұрын
Hello, nice tutorial.. what software is this? Would like to learn from you.
@DatabaseStar
@DatabaseStar 8 ай бұрын
Thanks! The tool I used is called LucidChart.
@-.-smile
@-.-smile 2 жыл бұрын
Ben your videos are amazing!
@DatabaseStar
@DatabaseStar 2 жыл бұрын
Thanks!
@luciusrex
@luciusrex Ай бұрын
i love this thanks!
@DatabaseStar
@DatabaseStar Ай бұрын
You’re welcome
@trishulcurtis1810
@trishulcurtis1810 9 ай бұрын
Excellent Video!
@DatabaseStar
@DatabaseStar 9 ай бұрын
Thank you very much!
@simondolapo1567
@simondolapo1567 2 жыл бұрын
Great video...I absolutely loved it... You're doing a great job...
@DatabaseStar
@DatabaseStar 2 жыл бұрын
Thank you so much!
@simondolapo1567
@simondolapo1567 2 жыл бұрын
@@DatabaseStar You're welcome...Words can't express how happy I felt when j went through some of your database videos...They were so helpful. Good job sir🙌
@SonAyoD
@SonAyoD 5 ай бұрын
Great video
@DatabaseStar
@DatabaseStar 5 ай бұрын
Thanks!
@AnneLopezlovesLife
@AnneLopezlovesLife 2 жыл бұрын
This is exactly what i need right now :)
@DatabaseStar
@DatabaseStar 2 жыл бұрын
Glad it was helpful!
@abdelrahmanmohamedowis7619
@abdelrahmanmohamedowis7619 5 ай бұрын
why u don't do generalisation principle
@DatabaseStar
@DatabaseStar 5 ай бұрын
What do you mean by "generalisation principle"?
@YangNotPractice
@YangNotPractice 4 ай бұрын
I think it’s called normalization
@tejassharma2006
@tejassharma2006 6 ай бұрын
Thanks man.
@DatabaseStar
@DatabaseStar 6 ай бұрын
No problem!
@rimshawaqar8073
@rimshawaqar8073 2 жыл бұрын
have you lectures on oracle apex complete series?
@DatabaseStar
@DatabaseStar 2 жыл бұрын
Unfortunately I don’t, as I don’t have any experience with apex
@rimshawaqar8073
@rimshawaqar8073 2 жыл бұрын
If you know someone good at apex, can you recommend (channel, lectures)
@hafedgabroun3242
@hafedgabroun3242 2 жыл бұрын
Keep up the good work! 👍
@DatabaseStar
@DatabaseStar 2 жыл бұрын
Thanks!
@naveenkumarmurugan1962
@naveenkumarmurugan1962 2 жыл бұрын
Your videos are awesome
@DatabaseStar
@DatabaseStar 2 жыл бұрын
Thanks!
@yahayahudu1745
@yahayahudu1745 2 жыл бұрын
You are really amazing, thanks 😊
@DatabaseStar
@DatabaseStar 2 жыл бұрын
Thanks!
@abdirahmanali3639
@abdirahmanali3639 Жыл бұрын
absolutely amazing, !!!!!
@DatabaseStar
@DatabaseStar Жыл бұрын
Thanks!
@smilingcookie1672
@smilingcookie1672 Жыл бұрын
Great video
@DatabaseStar
@DatabaseStar Жыл бұрын
Thanks!
@joelklovesmukisa
@joelklovesmukisa 8 күн бұрын
plz help share available databases if you dont mind
@DatabaseStar
@DatabaseStar 7 күн бұрын
What do you mean by available databases?
@pawegagorowski4410
@pawegagorowski4410 2 жыл бұрын
Great video!!
@DatabaseStar
@DatabaseStar 2 жыл бұрын
Thanks!
@lararawf6100
@lararawf6100 Ай бұрын
God bless u
@DatabaseStar
@DatabaseStar Ай бұрын
Thanks
@GenjaOrigins
@GenjaOrigins Жыл бұрын
I am trying to learn something. Lets say someone gives me some requirements how can i make a DB based on that. Or if have a DB how can i change it if somethng happnes therre must be some rules or theory. Like Pivot tables that connect 2 tables etc
@DatabaseStar
@DatabaseStar Жыл бұрын
This video shows you how to create a database design from an idea or from requirements. I've got a few other examples on how to do this on my channel as well. If you have a database and you need to change something, you would follow the same process. But it may be more complicated as you need to understand what is happening at the moment.
@GenjaOrigins
@GenjaOrigins 5 ай бұрын
@@DatabaseStar I think i need to Learn about 1-1, 1-N, N-1, N-N and when to use join table "pivot table". I think when 1-1 use foreign keys for everything else pivot table but i don't know how exactly. And i need learn normalization.
@wesleyong2970
@wesleyong2970 Жыл бұрын
What software is this?
@DatabaseStar
@DatabaseStar Жыл бұрын
This software is called LucidChart.
@hemanthanagoda8955
@hemanthanagoda8955 Жыл бұрын
max
@DatabaseStar
@DatabaseStar Жыл бұрын
Glad you like it (I think!)
@coderlady_
@coderlady_ Ай бұрын
Hi, Can you make a video about the mapping between tables to avoid teh infinit recursionStachOverflow problems? especially @manytoOne and @OnetoMany in each side of the tables
@DatabaseStar
@DatabaseStar Ай бұрын
What do you mean by recursionStackOverflow problem? I have a few videos on joining tables that may address it.
@coderlady_
@coderlady_ Ай бұрын
@@DatabaseStar I mean when 2 entities have bidirectional relationship: manytoone from 1side and onetomany from the other side, when serializing the 2 entities I get the erro: infinit recursionStackoverflow, I found solutions (like jsonmanagedreference and jsonbackreference) I'm wondering if there is a better way of managing the mapping, I've also read that OneToMany is to be avoid, because the entity loads list of the other one, so it leads to performence issues, is that correct? Thank you
@DatabaseStar
@DatabaseStar 22 күн бұрын
Thanks for clarifying. I assume you're using Java, but I'm not that familiar with these errors. A one-to-many database design is very common and is actually a good thing to have in a database. For example, one supplier has many products, one customer has many orders, one social media post has many photos. Regarding the "bidirectional relationship", does this mean that you have two tables, and they have two relationships between the tables (instead of one)?
How to Design a Database for Instagram
9:26
Database Star
Рет қаралды 39 М.
7 Database Design Mistakes to Avoid (With Solutions)
11:29
Database Star
Рет қаралды 86 М.
ТЫ В ДЕТСТВЕ КОГДА ВЫПАЛ ЗУБ😂#shorts
00:59
BATEK_OFFICIAL
Рет қаралды 4,3 МЛН
Long Nails 💅🏻 #shorts
00:50
Mr DegrEE
Рет қаралды 8 МЛН
How to Solve This Database Design Problem
8:09
Database Star
Рет қаралды 1 М.
Database Design for a Hotel Management System
12:14
Database Star
Рет қаралды 16 М.
6 SQL Joins you MUST know! (Animated + Practice)
9:47
Anton Putra
Рет қаралды 200 М.
From idea to Database design
38:56
Hitesh Choudhary
Рет қаралды 21 М.
Neo4j (Graph Database) Crash Course
1:23:08
Laith Academy
Рет қаралды 239 М.
eCommerce Database Design: Diagram & Explanation
16:06
Database Star
Рет қаралды 149 М.
Database Design Step-By-Step Tutorial for Beginners
38:58
thedevlife
Рет қаралды 29 М.
eCommerce Product Database Design: Step-By-Step
30:42
Database Star
Рет қаралды 24 М.
How to design database for a project
18:16
BBarters
Рет қаралды 96 М.
Андроид - мечта геймера!😍
1:00
Корнеич
Рет қаралды 1,3 МЛН
Лучший лайфхак для клавиатуры 🤡
0:57
ПРОСТО ЛЕШКА
Рет қаралды 2,7 МЛН