From SQL to NoSQL: A Gentle Introduction For Devs

| 2 min read

From SQL to NoSQL: A Gentle Introduction For Devs

Databases

TL;DR

I map SQL concepts to MongoDB equivalents, cover four big advantages of document databases, and explain the three mindset shifts you need to make when moving from SQL to NoSQL.

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