Explain By Example: OLTP vs OLAP

TL;DR:
Watch OLTP vs OLAP explained using a simple school analogy.

I had so much fun making the first video that I decided to start on the second one shortly after.

If you have read the actual blog post for this topic which is on OLTP vs. OLAP, you would notice that at the end I mention a section that describes the difference between normalisation vs. denormalisation. I originally planned to incorporate it into this video and even made all the animations and voice over but upon review, I decided I hated it. It was an awful example and I'm not sure why no one told me off for using it.

So, if you're wondering what happened to that section, there is a reason why it is missing. I suppose when you review old content you made almost two years ago, there are a lot of self-reflection (and possibly regrets) involved so I'll save you the horror even though it was only an extra minute long.

Thanks for watching. Remember to thumbs up/down, subscribe, and leave a comment below!

📔 Feel like reading instead? Go check out   / explain-by-example-oltp-vs-olap  
🇲 Want to stalk me? Follow me on: medium.com/@michelle.xie
🐦 Need someone to talk to? Tweet me: @mishxie