SQL Database Design Tutorial for Beginners | Data Analyst Portfolio Project (1/3)

In this video, I show you how you’d go about designing and building a relational database from scratch. I take you step-by-step through the process and show you a cool tool you can use to make your job a lot easier.

Timestamps
00:00 Intro
01:12 Project brief
02:10 Orders data
08:37 Placing fake orders
09:30 Stock control data
11:13 Staff data
12:56 Export SQL code
13:42 Creating the database
14:05 Creating the tables
15:11 Outro

🛠 TOOLS USED IN THIS VIDEO

🧰 TOOLS & SKILLS

📊 DATA ANALYST PROJECTS

🎥 RECOMMENDED VIEWING

📕 FREE EBOOKS

📊 DATA HUBS & WEBSITES:

DISCLAIMER: Some of the above links are affiliate links where I'll earn a small commission if you make a purchase using them, at no additional cost to you. It really helps support the channel so thanks in advance if you do use them 🙏

✅ LET'S CONNECT!

#databasedesign #sqltutorial #businessintelligence #dataanalyst

[markwilhelm]

Fantastic! This is easily the simplest and best introduction to databases and SQL I have seen.... Thank you so keep up the great work!

[anexusthanatos]

This is incredibly informative! Sweet, concise, and powerful. Keep up the good work!

[HeartandMindoftheFather]

Hi Adam, this video was Absolutely Awesome!! I'm highly interested in watching more.

[Aksinia]

Thank you so much!
Your teaching style is great, so clear and easy to understand.

[aiasaiascon]

Again ! This is a fantastic video with Clarity and Simplicity!!!! Thank you Thank you and Bravo !!!! magnifique!!!!

[framemaze]

Thank you so much for this. I’m just starting to learn SQL, and this is invaluable. Thank you, and keep up the good work 👍

[alexisluna]

everything ive learned from sql has come from you, GREAT WORK!

[angelleal]

Great Tutorial ! Eager to see the parts to follow this one. Keep up the good work.

[vickarkhan]

So to the point content. Amazing. Excitedly anticipating the further videos on this subject

[kunjd]

10:08 Make it thing more complicated! 😀 We need that

[lifesuccess]

Just waoo..! What a systematic approach.

[Kewaynes]

Just want to re-iterate the other comments. This is awesome stuff having all this straigh forward guidance in one place. Kudos!

[ahmedroberts]

Great Video! I will definitely be following along. Thank you.

[satishb]

Thank you very much it was very intutive and easy to understand with concepts of the use case

[Igzanda]

thanks for helping start my db journey!

[zacpaolo]

Couple questions - is it important to designate the difference between partial and total participation? Strong entities and weak entities? Should customer and staff have a super class because of their similar attributes? (first name, last name)

[xA]

The Quick Database Diagrams tool will definitely simply creating diagrams for each table and any relationships between them in a database.

[GenNextAnalyst]

Thank you for the most strightforward database design! Hope you can update tutorial with cost of goods sold calculation.

[ntzkfsp]

The relationship between a recipe and its ingredients is not a one-to-many relationship as the author has suggested. It is, in fact, a many-to-many relationship, whereby each ingredient can be used in multiple recipes and a recipe can involve many ingredients.

[AMINE-ddqy]

really enjoyed the video thank you so much <3