How to Design DB Tables for any Application? (The Basics)
Вставка
- Опубліковано 30 лип 2024
- In this video, I have covered the basics of designing Database tables for a forum application as an example. I have covered the important points that one should focus on while deciding the structure of the tables and the columns of the tables.
This is a great video for beginners to understand how we define tables, their structure, columns, the relationship amongst tables, setup primary keys and foreign key constraints, etc. with a sample application example.
Also, follow us on Instagram: / study.tonight
Facebook: / studytonight
Twitter: / studytonight
#dbms #dbdesign
This playlist is perfection.. learned so much in very short time! THANK YOU!!
The part about how to design db of web application is awesome! thanks for the tutorial!
Thank you so much for all the videos in this playlist! Simple and clear explaination with a touch of humor :) Keep going bro!
One of the better videos on DB design I've come across. Thanks!
Such a wonderful tutorial sir !!! with a clear discription of every thing in normalization topic !! What i like the most in this tutorial is funny parts that you added which makes some relaxation to brain ... This was the type in tutorials that i always search for !! Thankyou sir !!!
I wanted to congratulate you on a job well done. I can see that you have put lot of effort and thoughts to make it precise and simple to understand. Keep up the good work. Keeping in mind what I just said, I would like to request you to make videos about Dimensional Modeling, and Data Modeling for No-SQL Databases. Thanks.
Thanks for such awesome series. Loved it!!
I have learnt a lot from you; thank you so much, sir.
Thank you brother for this amazing tutorial .🙂 I am now clear in basic database design, Please make more videos about database designs. Thanks 🙂
Great explaination.
Clearly explained with an example that is not to simple or to complex.
Wel done sir!
Great explanation!!!
Thank you sir!
It helped me a lot. ❤️
You are incredible sir.Your explanation is far more better than geeksforgeeks and tutorialpoints.I read DBMS topics from google and they are simply super....
Thank you sir.
Great video. You should dive deeper into how to split up a table now. For example, humans usually think of the storage of data into one large table as best, but we know machines do not. You should show why and how data from this large table should be divided, and then the type of joins can be used extrapulate the same dataset as if we had one large table.
This is clear tutorial it is big help for me. THANKS
Thank you so much bro. It's helping me a lot to learn.. Thank you
Please make a more video, i really like study tonight content on website as well as on UA-cam. So keep continue.
That was a great video, detailed yet concise.
Thanks.
Yes, this is how I design my database
More such videos needed. Great work, hats off.
Glad you liked it!
@@Studytonight could you post more such videos before 19 oct, as I have an interview on 19 oct. It will be a great help if possible.
Thanks in advance.
Nice course, thank you
My pleasure Arsen. Thank you for commenting. Checkout my other videos too.
you have explained it very well ,can you cover the topic as to how we know that the design is completely normalised ?
Can I have multiple tables in a single db that are independent from each other?
bro why stopped posting videos since last 8 months!!
Sir your playlist is amazing, plz make videos on Joins in DBMS
Do you have any plans of adding a few videos on advanced SQL queries? You can add diffrerent types of queries like - joins and nested queries and subqueries. No need to repeat the content of basic SQL part available on your site as videos. But, can you please expand the concepts introduced in Advanced SQL section (of your site) and some content on transactions? You make the content seem more approachable, whether in video or text. So if you could expand that section on your site or make videos for them, it will help a lot.
Really love all the content on your website and the youtube videos. Thanks for all the help.
Thank you Junaid for sharing your insights. I am already working on the DB transaction video and it should be Live in a day or two. Will also work on more Advanced SQL queries.
I have seen many people store status of an entity (like order) , in your case category, in same table as constants(TinyInt). Which would you suggest? Having separate or same table?
Having "Category" in a separate table and then having category_id in question to setup relation between them helps in multiple use cases like if in your application you want to have one page where you list down all the categories and user can click on any category to see questions belonging to that category.
To list down all the categories all you have to do is fire a SELECT query on category table.
Also, if you wish to restrict users to a certain set of categories, you have the control as you can keep the categories pre-defined in the category table and show them in a dropdown for user to select from it.
I hope this provides enough points to support this approach.
Well we would love to know more about the TinyInt approach, if you can explain.
@@Studytonight I know for category your approach is better. I was talking about status of an entity. Take Order, It cave many status. In this case what would be good storing status as constants in same table or storing the way you did for category here?
thank you studtonighty
Best Tutor!!!
Good Explanation and have one question...Why do we need an user_id in Answer table as we already have question_id as foreign key in Answer table.
sir so much much thanks
Vary good tutorial
Thank you :)
hello!! can you help me how can I make Database Table of My collage Project. Topic: task Management
Please continue playlist 😊
Can you suggest book to learn more about this topic ♥️
Will do soon
bro can u make a playlist on the sql Injection
sir please make a class on concurrency .
what's the most used normalization form and why?
Most used would be the First 3 forms together. Because whenever you design a basic Database, ideally you should follow the first 3 Normal forms at least, and I think every one follows it.
I can't understand why u have less subscribers..Your teachings are extraordinary.
Hello. I have a noob question. Is this video is still applicable for 2023? I’m just asking if its still applicable in a database admin environment. Making sure because I would like to get a Database admin job…
Yup, still very relevant and I think it will stay relevant as long as we have RDBMS, unless the whole concept of RDBMS is dropped or completely changed 😄
@@Studytonightthank you for your reply sir! already subscribed because of your great contents about db 😃
Asslam o Alaikum dear sir! I want to talk to you about some details of db for application
Yes, please share...
We need full playlist 😶
Its almost an year i don't think he will continue
Thank you brother for this amazing tutorial .🙂 I am now clear in basic database design, Please make more videos about database designs. Thanks