Django ORM | Case Study 1 | Database Design Build and Query | Ecommerce Inventory | Django

We design, implement and query an E-commerce inventory database in this case study. Creating a relational database is not and should not be hard to understand. This is not my words, but a quote from the Book “Database Design for Mere Mortals”. To help us develop the database in this case study, we follow components of the design methodology inspired by this excellent book which I recommend to all new developers. As we move through the design phase, it is essential to remember that I have tried to summarise many of the design stages, relevant details, and processes for use in the case study and the context in that you are new to database design. As and when we add other case studies to the course, I hope to unfold a more comprehensive design process.

Udemy Course Link: Django 4.x ORM Mastery
===================

Timeline: (todo)
00:00 Design - Design methodology
18.1.3. Design – Define the purpose
18.1.4. Design - Requirement analysis – Business Requirements
18.1.5. Design - Defining the preliminary list of fields
18.1.6. Design - Defining the preliminary subjects/entities
18.1.7. Design - Refining the fields and tables
18.1.8. Design - Naming fields and tables
18.1.9. Design - Establishing Keys
18.1.10. Design - Field Specifications
18.1.11. Design - Table Relationships
18.1.12. Design - Table Relationships – update fields
18.1.13. Design - Business Rules
18.1.14. Design – Django / Application Rules
18.1.15. Build – Create the tables and fields
18.1.16. Data – Create data - Django Admin Site
18.1.17. Data – Create data - Django fixtures
18.1.18. Data – Create data - Management command
18.1.19. Query – Return all products

Django ORM YouTube Playlist
===================

Code Repository:
===================

[vinodsagar]

Hi Zander, Please don't get demotivated from wrong comments... you are the best in your teaching skills.... please keep up good work and motivate Django fans.... Thank you so much

[veryacademy]

I will add a timeline tomorrow! Also - queries will come very soon. If you would like to see any particular query for this design - let me know in the comments!

Udemy Course Link: Django 4.x ORM Mastery

[djangodeveloper]

i never saw database topic in such depth. You are amazing as always. Followed your last Ecom v1, v2 tutorials. those were just speechless. waiting for next videos on it.

You just nailed it. <3

[salmansyyd]

This such a priceless video, I saved it and keep coming back for more.

[sirdoofalot]

I've never understood databases until I started watching a couple of your videos. It all is starting to make sense! Thank you!

[bakeery]

Amazing, everything is covered perfectly, thanks alot for the great content

[irabor]

Just found your content and subscribed! Fantastic stuff here, thanks for helping other devs out man!

[BobsProgrammingAcademy]

Excellent video. You've explained all the concepts very well. Please keep up the great work!

[FreeDomSy-nkue]

I skipped through, that's a tone of work you put in.
I think you should advertise your Patreon more e.g. in the beginning of every video, also, put the link the description of every video.
If I could, I would support you there. Maybe in the future, though.
I learnt a lot from you're Django videos over the past few years. Thank you

[omaral-halabiah]

I learn a lot of new information by this video, thanks very much

[iliandili]

Grate as always! Where we can found database design word doc that you are using?

[madusan]

You did define ProductAdmin in two places. Check your code line 34 and line 45. The error you got was warning so it let you ignore it by running again but the 'error/warning' is still in your code.

[be]

Thank you, it's simple and beautiful

[piotrshopin]

Hi Zander, excellent tutorial as usual. I think there is a mistake at 01:09:15. You changed the positions of the tables (Diagram 7.2) compared to the previous diagram (7.0), and now the relation is incorrect. Maybe you could add a sidenote in the description. Thanks for the great work.

[SeyedHasan_MirHosseini]

Thank you so much to dive deeper, is there any special book you recommend to study?

[DecodeWithMohit]

Hey, can I have an explainatory video, on User model in django.
Problem Statement: I want to make three type of users, School Students, College Students & Teachers. I want a separate profiles based on their categories. Suppose, while user registration if user choose their category as school student, a school student profile should be made. Is it possible to make it happen or requires writing custom user model & authentication process.
Please reply??

[emkjuslen]

nice tutorial. Is it possible for you to share the excel file you used to write all the requirements and detailed description

[bpitxbx]

thank you very much for the content it is absolute amazing, can you share the word doc?

[snowmanicy]

Your voice arouse me can’t concentrate