Your image sometimes cover parts of the models you are explaining. You should consider not staying up on screen for the whole video or just getting off the screen entirely. You might chose to pop up at the beginning or end…
Thank you for this👌👌. Does anyone know of any relational data modeling exercises resources that have solutions? I want this relational modeling business to be intuitive. Thanks.
Thank you Data Guy! first video I've seen from you and it was so clear and simple. I have nothing to do with databases and I've followed every stage of your explanation easily. Thank you for bring this kind of material to us!
Awesome video you have here, I will be sharing this with my team👏🏽. Slight improvement that could be applied is taking away customerID from payment table (data redundancy) as the customer can be traced back using their orderID.
@@chinyerenwigwe5166 the order_id will always reference the customer. It doesn’t matter how many times the customer ordered a product. The order_id will always be different in the payment table.
This looks a whole lot like taking JSON/arrays from a website and putting it in MySQL with PHP scripts. Hopefully I have a leg up with that experience...
I have an interview for a software consultancy firm in the UK. My task I will be doing is "data modelling for a hypothetical system" how can I prep for this? I'm a full stack developer but not dealt with data modelling yet :)
My best recommendation would be getting a free trial in one of the database providers like snowflake and attempting to design your own database schema model by creating several tables, and organizing them in one of the described database model formats!
No problem! Can definitely do that, you can also use Astronomer to deploy Airflow on AWS, check out a free trial www.astronomer.io/ no credit card needed and you can deploy directly onto aws infra
Your image sometimes cover parts of the models you are explaining. You should consider not staying up on screen for the whole video or just getting off the screen entirely. You might chose to pop up at the beginning or end…
Thanks for the tips!
But it gives feel of live course, I mean in person. Please find better alternative. But be on screen. @@thedataguygeorge
Two of my college classes explained in 19 minutes. Excellent refresher and general explanation 👍
Hahahahaha thanks Jesse, happy to hear I'm up to college par!
The data dog distracts me 🐕
Hahahahaha apologies, he distracts me as well!
Great! video Captain America with eye glasses 🤓 Love Data Dog 😍
Hahahahahaha thank you for the new nickname! Data Dog loves you back!
Thank you for this👌👌. Does anyone know of any relational data modeling exercises resources that have solutions? I want this relational modeling business to be intuitive. Thanks.
Thanks! Not off-hand but let me look into it and get back t you!
Thank you Data Guy! first video I've seen from you and it was so clear and simple. I have nothing to do with databases and I've followed every stage of your explanation easily. Thank you for bring this kind of material to us!
Thank you so much for the kind words!
Awesome video you have here, I will be sharing this with my team👏🏽. Slight improvement that could be applied is taking away customerID from payment table (data redundancy) as the customer can be traced back using their orderID.
That may or may not be right cause what if the if the customer ordered goods twice
@@chinyerenwigwe5166 the order_id will always reference the customer. It doesn’t matter how many times the customer ordered a product. The order_id will always be different in the payment table.
This looks a whole lot like taking JSON/arrays from a website and putting it in MySQL with PHP scripts. Hopefully I have a leg up with that experience...
Definitely good experience to have!
I’m new to being data focused but not new to tech. Is data modeling just like diagramming with uml?
Yes definitely an apt comparison!
For OrderLine Entity LineID should be PK and OrderID should be FK
Ahhh good catch! Thank you!
Insightful video! Thanks - What’s your verdict on Data Vault as data model?
thank you data guy ..... l dont have an experience in data modelling and its part of my courses this semester...this really helped me
In the OrderLine, should the OrderID be the FK and LineID the PK?
Ooooo maybe, good catch!
I was thinking exactly the same thing.
I have an interview for a software consultancy firm in the UK. My task I will be doing is "data modelling for a hypothetical system" how can I prep for this? I'm a full stack developer but not dealt with data modelling yet :)
My best recommendation would be getting a free trial in one of the database providers like snowflake and attempting to design your own database schema model by creating several tables, and organizing them in one of the described database model formats!
How did it go?
@@frumiousgamingam interested to know as well
lol the dog
He's the best!
Thank you for this amazing piece
Thanks so much for tuning in Emmanuel!
Please make videoes on SCD or CDC?it will be helpful for all DE
Yes forsure, just to make sure I know I'm hearing you right, you mean Slowly Changing Dimensions and Change Data Capture right?
Yes, you are right
@@thedataguygeorge
Amazing, will have videos out next week!
Thanks for the video. Would love to see one on ways to set up Airflow in AWS
No problem! Can definitely do that, you can also use Astronomer to deploy Airflow on AWS, check out a free trial www.astronomer.io/ no credit card needed and you can deploy directly onto aws infra
@@thedataguygeorge❤
Nice video... keep it up ✨
Thanks Mohammad!
Thank you.
No problem!
New subscriber 😊
Thanks for subbing!
Love you brother
Love you too brother!
Thank you so much.🎉 Could you consider speaking a bit slower for your foreign listeners pls 😊
Yes working on it!