DataBasics: OLTP and OLAP

⏯RELATED VIDEOS⏯
• DataBasics: What is a ...
In this video, I'm going to cover what OLTP and OLAP databases are, and how they can be used for data analysis. I'll also discuss the advantages and disadvantages of each type of database, and give you a brief overview of columnar storage technologies.
If you're unfamiliar with these terms, or want to learn more about how they can be used for data analysis, then this video is for you. By the end of this video, you'll have a better understanding of what OLTP and OLAP databases are, and how they can be used to improve your data analysis skills.

[@juanrassis]

Hi, mate. Awesome content!! So, would you suggest the created of a OLAP based database (one that would follow a star schema), which would pull, merge, aggregate and transform data from the OLTP database? Would that be a good approach?

[@hasibulhayat9572]

Your channel is criminally underrated man! Keep up the awesome work. btw, are you on LinkedIn?

[@GARFEDEN]

Great explanation!