Part 2 is already available: Custom SQL Query Tutorial For Beginners | Data Analyst Portfolio Project (Part 2) ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Yw3oqqkhohY.html
@@LearnBI can i ask a question Do you think is better to focus on SQL in order to achieve more expertise (more engineering or programming like jobs) & money in data world or I have a naive argument here!?
If your aim is to go for data engineering or programming roles then SQL is essential. But it's also a skill that a lot of people have so isn't as valuable as knowing other less common languages. Programming isn't my field though so I'm the wrong person to ask about it. When it comes to BI, you'll need SQL, Excel and BI tools as the essentials.
I am wondering whether the direction of the arrows matters. For example, when you drag the "staff_id" in the 'rota' table towards the "staff_id" in the 'staff' table you're implying that "rota.staff_id" will be a foreign key for "staff.staff_id". Shouldn't the direction be always from the table where the selected field is "Primary Key" towards the table where it is a generic field? I was also confused by the relation between "rota.date" and "orders.created_at". From my understanding, the relation between tables should be "one to many"; however, dates can be repeated in both rota and orders table, which makes the relation "many to many". Could you clarify this point?
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)
Hello, thank you for the video. I’m extremely new to this whole world and have been taking the time to learn about building a database for a business. I have one question that has been confusing me, and I’m hoping you can help. If I build a database for a business. Do they have to install it on their computer and I run all the software from there login? Or do I create it on mine and the dashboard will show just their data. Thank you, and I hope this makes sense lol
Hi Mark, an RDBMS/databases can be installed on any computer. It does not need to be on the client's computers/servers. You can even rent an instance of most RDBMS in the cloud.
Thank you Adam for this amazing video. A question. Is the back-end tables coming from the front-end tables? Meaning is the OLAP tables that you are building coming from the OLTP tables.
I’m not sure I understand the premise of your question. There is just a single database that contains these tables. No difference between front and back end.
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?
It’s a good idea but it doesn’t really have any impact on what we’re trying to achieve with this project. I’m going to cover cardinality in a video coming soon 👍🏻
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 ❤
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.
@@LearnBI my apologies, I'm looking to make a database for a site that uses maps with pin locations that show the average rating out of 5 stars. It's something akin to Google maps where you can rate certain locations, how long would a database like this take do you think. I didn't go full detail but that is the just of it.
@@hogarthheathan As you can see from the video, creating the database doesn't take very long at all, it's inserting the data that would take a lot of work. If you are starting from scratch, you would need to scrape data from the web using something like Python. But that's not my wheel house.
What are the names of the tables? Should I copy the information? Is it possible to download the excel spreadsheet? Thank you very much. Good Information!
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
3 things. 1) the database we created is MySQL, not Postgres 2) some errors don’t stop you from creating and using the database, 3) Google is your friend
@@LearnBI 1) I am newbie and I am getting used to PostgreSQL. 2) I cannot create the database with that error 3) I have tried to ggl but still cannot understand, I am newbie, please kindly help
I think Adam - that the Pizza concept is one of the most fantastic Online Promo Marketing & Email List Growth - super scheme ever!!!! very funny and very smart!!!! Huge success for me!!!! Well Done Man!!!