From SQL to NoSQL: A Gentle Introduction For Devs

Thanks for coming to my talk, From SQL to NoSQL: A Gentle Introduction For Devs. Here you will find all the resources discussed during the talk.

About

“I have heard about NoSQL databases, but don’t know what they are. What’s the difference between NoSQL and relational databases like SQL?” Does this sound like you? In this talk, you will learn about the current NoSQL landscape and how you as a JS developer can take advantage of NoSQL databases.

Slides

Video

Talk Outline:

Map terms & concepts from SQL to MongoDB
- MongoDB stores data in Documents
- Modelling data in MongoDB v SQL
- Schemaless database
- Document -> Row
- Field -> Column
- Collection -> Table
- Database -> Database
- Index -> Index
- Embedding -> JOIN
- $lookup (Aggregation pipeline) -> Left Outer JOIN
- Multi-record ACID Transaction -> Multi-record ACID Transaction
Discover the 4 humongous advantages of MongoDB
- Scale cheaper
- Program faster
- Query Faster
- Pivot Easier
Change your mindset in 3 key ways
- Not all documents in a collection need to have the same fields
  - Polymorphic Pattern
  - Outlier Pattern
- Data that is accessed together should be stored together
- Stop using transactions regularly
Recap/Overview/Questions