In this video I'll give you a full introduction to what data modelling is, what it's used for, why it's important, and what tools you can use to implement it!
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!
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
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.
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!
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...
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…