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

When I import the CSV files into MySQL for orders and rota tables, it says 0 records imported, and the tables are empty. Not sure why. All the other tables import just fine.

great job in explaining,although i could not find the link for the excel file. is there a link where i can download the excel file?

what if we don't have Navicat and don't want to pay for it?

With the full picture of all the tables, im having trouble understanding in items table what is 'SKU'. Can you explain by breaking it down that how the tables Items, Recipe, ingredients and inventory are connected to each other how are these values related? BTW Thank you and awesome tutorial ❤

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

how long do you reckon it would take to make a database for map related review leaving app?

what software are you using? and can I do this with postgresql?

Quick DBD is useful but flawed when it comes to properly establishing relationships amongst tables.

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

this guy sounds like the Kurgesagt guy

havent got it, how to write various items in the same order, exept for creating the same order as many times as many items it has. the same about ingredients. Can it be solved?

how to mention this project in our resume?
how would we describe the project in the resume ?

Thanks!

Where's the part 2?

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

Please how can I access the dataset used?

thanks for helping start my db journey!

this video was "best video of 2023 & beyond"

please help me to resolve this error when I try to create the schema with PgAdmin (PostgreSQL)
ERROR: there is no unique constraint matching given keys for referenced table "orders"
SQL state: 42830

how can i get the data file for this project. Anyone?