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#

View the slides on SpeakerDeck

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 (I go deeper on this in my MongoDB schema design best practices talk)
  • Stop using transactions regularly
• Recap/Overview/Questions

You can view a complete list of my past and upcoming talks with video on my website joekarlsson.com/talk-archive

Related Links#

• MongoDB University
• MongoDB Community Forums
• Advanced Schema Design Patterns (webinar)
• Building with Patterns: A Summary (blog series)
• The MongoDB Docs
• JSON Schema Validation – Locking down your model the smart way
• JSON Schema Validation – Checking Your Arrays
• M121: The MongoDB Aggregation Framework