MongoDB for SQL Experts
Learn the difference between MongoDB Query Language and Structured Query Language (SQL). You'll also learn how to translate SQL create, read, update, and delete (CRUD) statements into MongoDB CRUD statements.
MongoDB for SQL Experts
Unit Overview
In this unit, you’ll learn how MongoDB differs from traditional relational database management systems (RDBMS). Then, you’ll learn how to translate a SQL INSERT statement into MongoDB insertOne and insertMany operations, and a SQL query into a MongoDB query. Next, you’ll learn how to translate SQL UPDATE, DELETE, and JOIN statements into MongoDB operations.
Prerequisites
To be successful in this unit, you should be proficient with SQL.
Lessons in This Unit
- Lesson 1 – Traditional RDBMS vs MongoDB
- Lesson 2 – Object Relational Mappers in MongoDB
- Lesson 3 – INSERT in MongoDB
- Lesson 4 – SQL SELECT in MongoDB
- Lesson 5 – BETWEEN, ORDER BY, LIMIT in MongoDB
- Lesson 6 – UPDATE in MongoDB
- Lesson 7 – Delete in MongoDB
- Lesson 8 – SQL JOINs in MongoDB
-
01.
-
02.Lesson 2: Object Relational Mappers in MongoDB
- Learn
- Practice
-
03.Lesson 3: INSERT in MongoDB
- Learn
- Practice
-
04.Lesson 4: SQL SELECT in MongoDB
- Learn
- Practice
-
05.Lesson 5: BETWEEN, ORDER BY, LIMIT in MongoDB
- Learn
- Practice
-
06.Lesson 6: UPDATE in MongoDB
- Learn
- Practice
-
07.Lesson 7: DELETE in MongoDB
- Learn
- Practice
-
08.Lesson 8: SQL JOINs in MongoDB
- Learn
- Practice
-
09.Conclusion
- Lesson
Xijing Zhang | University Curriculum Engineer
Xijing Zhang is currently a Curriculum Engineer here at MongoDB. Previously, she developed curriculum over at Docker after getting her degree in Electrical Engineering from the University of Southern California.
Parker Faucher | University Curriculum Engineer
Parker is a Curriculum Engineer on the Education team at MongoDB. Prior to joining MongoDB, he helped maintain a world class developer bootcamp that was offered in multiple universities. He is a self taught developer who loves being able to give back to the community that has helped him so much.
Sarah Evans | Senior Curriculum Engineer
Sarah is a Senior Curriculum Engineer on the Curriculum team at MongoDB. Prior to MongoDB, Sarah was a Curriculum Engineer on the Coding team at Trilogy | 2U, where she contributed to Full-Stack and Advanced Front-End courses. Sarah has a MAT degree from Columbia University Teachers College and studied Software Engineering at Flatiron School in Chicago, IL.
John McCambridge | University Curriculum Engineer
John is a Curriculum Engineer on the University team at MongoDB. Before his work as a Curriculum Engineer, he was an instructor and teaching assistant for coding boot camps at UT (Austin), and UCLA. Additionally, he worked as a QA engineer for a startup called Coder and spent five years at Apple Inc. John is a passionate software engineer and educator who enjoys taking complex topics and making them digestible for the community.
Vick Mena | Director, Curriculum
My name is Vick and I've been in the wild for over 25 years. I grew up at IBM working on the BIOS for the IBM eServer line in Austin, TX before moving to Wall St. I've worked on all phases of software development from low-level to middleware to UI but feel most comfortable in the middle. I also drank the devops kool-aid having moved a product line to AWS while at Dow Jones & Co with the help of an amazing team. I then pivoted into the secure space and worked on software/hardware reverse engineering. I always thought I'd eventually teach and this role lets me leverage all of my experience to lead this motley crew of passionate educators.
Welcome! This unit is designed for SQL users who want to learn how to perform CRUD operations in MongoDB.
I’m Xijing. I’m a Curriculum Engineer here at MongoDB, and I’ll be working with you through this unit.
In the upcoming lessons, you’ll learn how MongoDB differs from SQL. You’ll also learn how to translate the CRUD statements you’re so familiar with in SQL to MongoDB. By the end of this unit, you’ll be able to interact with your data in MongoDB databases.
The lessons in this unit consist of video lectures followed by quiz questions and labs so that you can practice what you learned.
First, you’ll learn how MongoDB differs from a traditional relational database management system.
Then, you’ll learn how object relational mappers, or ORMs, fit in MongoDB.
You’ll translate a SQL INSERT statement into a MongoDB insertOne or insertMany operation.
Then, you’ll translate a SQL query into a MongoDB query. You’ll learn how to find documents in MongoDB by using find and findOne, and project the fields that you want returned.
Afterward, you’ll sort the returned documents and limit the results. You’ll also learn how to obtain information about your query.
Next, you’ll translate a SQL UPDATE statement into a MongoDB updateOne or updateMany operation.
You’ll also translate a SQL DELETE statement into a MongoDB deleteOne or deleteMany operation.
Finally, you’ll translate a SQL JOIN statement into a MongoDB $lookup aggregation stage.
Let’s get started!
