Database Design Step-By-Step Beginner Tutorial Using SQL Server

In this installment of the API Series, we share the process of designing a database for a new design in SQL Server. Using SQL Server Management Studio ( SSMS ), we provide a step-by-step guide to database design.

Database design is the foundation of any application that manipulates or has dependencies on data and/or databases. This video is a must if you ever want to build an API ( REST API ) as a developer to support an application, whether that is a mobile application or web application.

Videos Included in the Web API Series

3. Database design (this video)

0:00 - Intro
0:17 - About the channel (don't forget to subscribe)
0:54 - Database design process outline
1:59 - Diagram the necessary database entities needed
20:02 - Create the new database using SSMS (SQL Server Management Studio)
33:25 - Inserting new test data
39:21 - Conclusion

#sql #database #thedevlife

[ronaldodiaz]

This video is exactly what I was looking for. I needed to see someone's design process from conceptual to logical to physical. Awesome video man thank you !

[joegodindata]

Thanks for this awesome quick video. Just did my first database design and creation.

[jeff.thecoder]

Excellent video. Explained in simple terms in a calm cool tone. I look forward to the foreign key

[iam_kundan]

Awesome video. Very well explained end-to-end database design. Just one small suggestion : please don't add background music while you are explaining, it makes it difficult to concentrate on the content. Apart from that, you explained the whole thought process so well that everything was clear for me in one go, I have watched many YouTube videos regarding database design but you made it so easy to understand. Thanks for the video!

[MoGraceu-og]

This series looks like it will be useful for me, coming from a database model using DBF tables. Your approach makes it much easier to understand the transition than most SQL tutorials. I really appreciate that!

[guillermomorrison]

great video on a design framework for database design. Just started learning SQL and love seeing how the learning I'm doing coincides with your database design.

[laronantungwana]

please make this into a series, its helping us new analysts.

[sivakrishna]

This hands-on explanation is amazing, I can't find the continuation of this video on building relationships and constraints, please help me to find one, if haven't made one, please do whenever you can!! Thanks...

[Naveedqureshi]

I don't usually comment on videos but this one is the the masterpiece.... Superb man 👍 great explanation.

[joaquinperez]

awesome videos, great explanations. Thank you for taking the time to prepare and do this video, it helped me a lot. I am building my own website. I had paid three developers that they did not do the database, thus I am doing it myself. It worked.... Yes!...sir

[Kikikuku]

The video was very helpful, many thanks!

[rafacancode]

7:56, why do you need the extra make table? you said it was to prevent miss spellings but you would always give the user a pre-set of selection so that wouldn't be a problem as the name wouldn't be misspell, so what are the benefits really? also you would have repeated make data but you would also end up repeating the id from the table instead of the make so that also doesen't matters. The only reason that make sense is that int takes less space than string but you are creating an entire table vs a simple string column. thank you for your answer

[zbmat]

38:34 a small correction...In the "Models" table you had to enter "Civic" instead of "Honda"... Great work touching explaining from ground up...Keep going !

[toupocallen]

I love your videos. Please keep making them.

[DesignDensity]

I personally think the "Cars" table should have been called the "CarAds" or "CarItems" or "CarListing" table because this is what the user mostly interacts with from the frontend side, this gives it a distinct name which is easy to understand 😊😊
The "Makes" should read "CarMarks" and the same for Models > "CarModels", this makes things easier at first glance.

Overall enjoyed the video, thank you for this tutorial.

[ladefected]

That was fun.... Very well done presentation! Thx.

[nguyenhongson]

Thanks. Your Video is very useful. It's helped me understand more about how to use Databases in SQL.

[nickt]

@9:32, in the cars table, wouldn’t the MakeID be dependent on the ModelID, and the ModelID is dependent on the CarID?

Thats means Make_ID is transitively dependent on Car_ID. If thats the case then that table is not in the 3rd normal form, right?

[JeffersonCanedo]

Thankyou very nice video I needed this

[kokebzerai]

Thank you so much this step by step instruction very popular method. I hope you will come with more courses.