Databases for Data Science

on YouTube ↗45m

" summary

Shows concrete claims and runnable tools not buzzwords: compares Postgres, MongoDB, Cassandra and Neo4j with query examples, mentions MongoDB aggregation pipeline and visualiser Compass, explains CAP tradeoffs and surprising detail that Cassandra writes faster than reads, and notes JSON-in-Postgres vs MongoDB schema enforcement. Covers install/ops tips (homebrew, replica copies), libraries like SQLAlchemy and Eve, and small demos of queries. Watch if needing actionable comparisons and tools; skip if only high-level theory suffices.

AI-written summary · about

" chapters (13)

1. 0:00Introduction
2. 4:23Why databases matter
3. 7:40Relational databases overview
4. 10:36NoSQL databases types
5. 14:08ACID vs BASE models
6. 16:35Comparing database systems
7. 20:07Data types and schema
8. 23:18Querying languages
9. 27:59Setup maintenance scalability
10. 31:13Integration with systems
11. 35:25Data structures visualization
12. 37:10Choosing the right database
13. 39:29Q&A

" related talks

• 35mAn Ode to 17 Databases in 39 minutesToby Hede · RubyConf AU 2014
• 38mAn Ode to 17 Databases in 33 MinutesToby Hede · RailsConf 2014
• 01h 02mStoring Non-Scalar DataDerick Rethans · PHP UK Conference 2019
• 23mFANTASTIC DATABASES AND WHERE TO FIND THEMChris Hasinski · Euruko 2023
• 44mAn ode to 17 databases in 29 minutesToby Hede · Rocky Mountain Ruby 2013
• 34mData Storage: NoSQL Toasters and a Cloud of Kitchen SinksCasey Rosenthal · RailsConf 2013
• 38mNoSQL Databases: Its not a free lunchPramod Sadalage · Agile Singapore Conference 2016
• 01h 00mThe Modern Database Debate: Documents, Tables, or Documents in Tables?Franck Pachot · IntelliJ IDEA Conf 2025