Level 12 of 13 · about 1 week
Big data and analytics
OLTP versus OLAP as two different access patterns that both call themselves queries, data warehousing and the star schema, MapReduce and distributed batch processing, stream processing for events as they arrive, and column-oriented storage built for analytical queries.
Modules
Core: everyone needs it. Common: most jobs use it. Specialist: optional depth, safe to skip on a first read.
1
OLTP versus OLAP
two very different access patterns that both call themselves database queries, and why running them on one system causes trouble
Core 5 parts · about 2 hours
2
Data warehousing
pulling data from many operational systems into one place built for analysis, and the star schema that organizes it
Specialist 6 parts · about 2 hours
3
MapReduce and distributed batch processing
splitting a huge job across many machines by writing two small functions and letting the framework handle the rest
Specialist 6 parts · about 2 hours
4
Stream processing basics
processing events as they arrive instead of waiting for a batch job to run on yesterday's data
Specialist 6 parts · about 2 hours
5
Column-oriented analytics storage
storing each column together instead of each row, and why that shape fits analytical queries so well
Specialist 6 parts · about 2 hours