What is Data Modelling? Beginner's Guide to Data Models and Data Modelling

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!

[@jessegarris7037]

Two of my college classes explained in 19 minutes. Excellent refresher and general explanation 👍

[@thedataguygeorge]

Hahahahaha thanks Jesse, happy to hear I'm up to college par!

[@emmanuel5791]

Thank you for this amazing piece

[@thedataguygeorge]

Thanks so much for tuning in Emmanuel!

[@jeffrey6124]

Great! video Captain America with eye glasses 🤓 Love Data Dog 😍

[@thedataguygeorge]

Hahahahahaha thank you for the new nickname! Data Dog loves you back!

[@billyasterino8396]

Thanks for the video. Would love to see one on ways to set up Airflow in AWS

[@thedataguygeorge]

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

[@raushansingh7530]

​@@thedataguygeorge❤

[@OrcaChess]

Insightful video! Thanks - What’s your verdict on Data Vault as data model?

[@dayskasila]

Thank you.

[@thedataguygeorge]

No problem!

[@Ifeanyi4Ndu]

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]

That may or may not be right cause what if the if the customer ordered goods twice

[@Ifeanyi4Ndu]

@@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.

[@mohammadnezam360]

Nice video... keep it up ✨

[@thedataguygeorge]

Thanks Mohammad!

[@jonnybrown2318]

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 :)

[@thedataguygeorge]

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!

[@frumiousgaming]

How did it go?

[@edwinfcapidos]

In the OrderLine, should the OrderID be the FK and LineID the PK?

[@thedataguygeorge]

Ooooo maybe, good catch!

[@rhodaime79]

I was thinking exactly the same thing.

[@user-by2ql2my5u]

Please make videoes on SCD or CDC?it will be helpful for all DE

[@thedataguygeorge]

Yes forsure, just to make sure I know I'm hearing you right, you mean Slowly Changing Dimensions and Change Data Capture right?

[@user-by2ql2my5u]

Yes, you are right @@thedataguygeorge

[@thedataguygeorge]

Amazing, will have videos out next week!

[@annas6547]

For OrderLine Entity LineID should be PK and OrderID should be FK

[@thedataguygeorge]

Ahhh good catch! Thank you!

[@HighLearningBrighterFuture]

New subscriber 😊

[@thedataguygeorge]

Thanks for subbing!

[@evhwolfgang2003]

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...

[@thedataguygeorge]

Definitely good experience to have!

[@sa-pg6or]

Love you brother

[@thedataguygeorge]

Love you too brother!

[@YiraRosas]

The data dog distracts me 🐕

[@thedataguygeorge]

Hahahahaha apologies, he distracts me as well!

[@Animal-yb1rr]

lol the dog

[@thedataguygeorge]

He's the best!