Mongo Db learning objectives

[gregdyke]

The following is a description of the current learning objectives and my suggestion of what to keep/add/get rid of. I would move the overall aim from "learn a lot about mongodb" to "learn just enough about mongodb and move towards understanding how full stack rest apps work". Comments/feedback welcome

MongoDb syllabus learning objectives

• keep this learning objective if there is a comment I'm thinking this should maybe be a stretch goal
• [] don't keep this learning objective
• [][x] unsure whether it's worth having material specifically oriented towards this objective
• Proposed new learning objective

W1: (this is currently in week 1)

Overall

• [?] W1: familiarise with mongo queries and returning the single/array result of those queries through express endpoints
• [?] W2: create/update/remove documents programmatically mongodb in node, or manually in atlas
• [?] W3: revisit/consolidate the creation of REST endpoints, integrate into understanding of how full stack applications work

Full stack

• W3 Can answer: What is the data flow for typical operations in a full stack app (e.g. imdb: show list of movies matching criteria, modify a movie, add a movie)

Databases

• W1 Can answer: What is a database management system?
• W1 Can answer: Why do we use a database management system?

MongoDb

• W1 Can answer: How is data organised in mongodb? As we have server/cluster -> db -> collection -> document, it might be worth being clear when we have multiple/single of these
• W1 Can answer: In what format is data represented in mongodb?
• W1 Can: use a mongo connection URI (including understanding where username and password go)
• [] W1 Can: open and close a client with every request
• W1 Can: connect to a specific db
• W1 Can: connect to a specific collection
• [] W1 Can: use find().toArray(callback)
• [] W1 Can answer: what is an ObjectId and what is the difference between the BSON object and the string representation
• [] W1 Can: convert a string to an ObjectId
• W1 Can: write a query object with a single field
• W1 Can: use findOne
• W1 Can: write a query object with multiple fields
• [] W1 Can: write a query object with $or should use $in instead as per the mongodb instructor
• W1 Can: write query objects with $in, $ne, $gt, $gte, $lt, $lte $ne is not in the query exercises I wrote, but worth including
• [] W2 Can: sign up to an account on atlas, create a db and connect to that db from a node app this took forever, so would rather make that into a tutorial
• [] W2 Can: create a collection and create/remove documents from atlas
• W2 Can: use docs.mongodb.com
• [] W2 Can: use insertOne
• [] W2 Can: use findOneAndUpdate
• [] W2 Can: use deleteOne
• W3 Can: use compass to run queries/verify results of insert/update

Javascript

• [] W1 Can: use a reference to a callback function as an argument to another function
• [][x] W1 Can: write a lambda callback function (as an argument) Inherenlty part of using express/node, so no need to recap?
• [] W1 Can: write a function that takes as argument and executes a callback function
• [][x] W1 Can: convert a string query param to a number useful to not entirely abstract away? or is it not on the critical path?
• [] Can: use String.split to create an array from a comma separated set of strings

Express

• W1 Can: write a (request, response) => { ... response.send(...)}
• W1 Can: send an array as a response
• W1 Can: send a single document as a response
• [][x] W1 Can: add an endpoint with query parameters (to create a search) useful to not entirely abstract away? or is it not on the critical path?
• W1 Can: send different http statuses probably already known from nodejs module?
• W1 Can: add an endpoint with a route parameter (e.g objectid)
• W2 Can: query an express server locally (how to connect to the right port in browser/postman)
• [] W2 Can: convert a set of query parameters into a mongo object ready for insertion
• [] W2 Can: perform validation on the query paramters

Nodejs

• W1 Can: put secret values in process.env keep the version that Neil sent, in class or as homework?
• W2 Can: run an express server locally
• W2 Can: npm install mongodb
• W3 Can: git clone and run npm install
• Use nodemon to avoid having to keep restarting the server
• Use npm test to check exercise implementation

http

• W1 Can answer: when are 404, 400, 200, 500 used?
• W2 Can answer: when is POST used?
• W1 Can answer: when is GET used?
• W2 Can answer: when is PUT used?
• W2 Can answer: when is DELETE used?

glitch

• [] Can: edit, run and debug app hosted on glitch.com as the end goal is to run an express server locally, suggest not using it

[gregdyke]

(Not yet included, would probably move to Mongoose for the consistency of the API - there is previous discussion about this on Slack)

[ChrisOwen101]

[] W2 Can: sign up to an account on atlas, create a db and connect to that db from a node app this took forever, so would rather make that into a tutorial

This should be covered in the preparation materials

https://syllabus.codeyourfuture.io/mongodb/preparation

Happy to add changes there as you see fit

[] W1 Can: use a reference to a callback function as an argument to another function

Callback functions are really hard for us to teach throughout all of JS1/2/3 - I think we should focus on it being taught earlier rather than include as an LO here

[][x] W1 Can: write a lambda callback function (as an argument) Inherenlty part of using express/node, so no need to recap?

Yeah, best to assume they already have this knowledge - and if they don't it's because something has gone wrong earlier in the course

[] W2 Can: use insertOne
[] W2 Can: use findOneAndUpdate
[] W2 Can: use deleteOne

Whats the thinking about removing these?

[ChrisOwen101]

[] W2 Can: perform validation on the query parameters

I think that's still a valuable LO