Explore

s24 CSD 3103 Lesson Plans

Day 2 May 15

6 Forms of JavaScript

⁠

https://coda.io/@peter-sigurdson/mastering-javascript-functions-a-comprehensive-lab-workbook-for-⁠

Day 1 May 8

May 8 Activity A Lab Worksheet:

Watch this video on Service Oriented Architecture patterns:

⁠

https://www.youtube.com/watch?v=Oscvl1YWjng ⁠

;

Worksheet for setting up our Build tooling : MVSC and Node.js

⁠

https://coda.io/@peter-sigurdson/csd3103-practices-of-node-js-npm-application-development-with-vi ⁠

;

Lucid Chart Visual Diagram:

⁠

https://lucid.app/lucidchart/960cec38-835b-4ae4-9f45-c9229ba9f291/edit?view_items=.DevXA9r1Snt&invitationId=inv_09ec3895-cb28-409e-b757-cde0df4a0560⁠

Mind Map Visual Learning Roadmap:

⁠

https://share.mindmanager.com/#publish/RO9QdBMbcCRUZe2b2wAzrpnK3APet_xMQMSlqK4v⁠

Lecture Dictation

⁠

https://otter.ai/u/4T69U_TFs4gefYrF9LqJZGs_KfY?utm_source=copy_url⁠

Course PowerPoint Workbook:

⁠

https://www.dropbox.com/scl/fi/y493kw8fsif6i4lg23ab2/CSD-3103-JavaScript-Fundamentals-2023S.pptx?cloud_editor=powerpoint&dl=0&rlkey=q711ucyaclfcgtoob4woz4z6n⁠

Lab Work Book:

⁠

https://coda.io/@peter-sigurdson/csd3103-practices-of-node-js-npm-application-development-with-vi⁠

⁠

The BOM and the COM

⁠

https://coda.io/@peter-sigurdson/javascripts-role-in-browser-object-model-bom-and-html-document-o ⁠

;

⁠

https://coda.io/@peter-sigurdson/npmjs-com-and-the-nature-and-structure-of-building-npm-applicati⁠

⁠

Last modified: Wednesday, 15 May 2024, 12:53 PM

Labs:

⁠

https://coda.io/@peter-sigurdson/the-mongoose-library⁠

⁠

https://coda.io/@peter-sigurdson/the-mongo-db-college-enrollment-system⁠

Week 5 June 3-7

THU June 6 s2 PM Session:

Today’s work is to introduce the backend persistence layer of our MVC Application.

⁠

Otter.ai⁠

Dictation:

https://otter.ai/u/VdLIQPm9DcetK4uZqERTZVA6wtw?utm_source=copy_url⁠

⁠

Deliver Assignment 1 :

https://coda.io/@peter-sigurdson/s24-june-5-csd-3103⁠

⁠

To do this Assignment, you will need:

Express.js web server with Routes Setup (started)

Mongo DB Database

DONE:

Get setup with Node.js, NPMJS.com, and Visual Studio Code

TO DO:

done → Getting setup with

MONGODB.com⁠

⁠

Make an Account on MongoDB.com

Learn how to use JSON data storage in MONGO

Mongoose Code Drills: Learn how to do CRUD in

NPMJS.com⁠

package called MONGOOSE

⁠

Mac Users:

https://coda.io/@peter-sigurdson/creating-an-admin-root-id-on-your-mac-os⁠

⁠

Download LINK for MONGODB Server :

⁠

https://www.mongodb.com/docs/manual/tutorial/install-mongodb-on-windows/⁠

⁠

Lab Workbook: Introduction to JSON and MongoDB

1. What is JSON? 2. What is MongoDB.com? 3. Setting Up MongoDB Server 4. CRUD Operations with JSON in MongoDB 5. Mongoose Code Drills 6. Lab Exercises

---

1. What is JSON?

**JSON (JavaScript Object Notation)** is a lightweight data-interchange format that is easy for humans to read and write, and easy for machines to parse and generate. It is primarily used to transmit data between a server and a web application as text.

**Example JSON:** ```json { "name": "John Doe", "email": "john.doe@example.com", "age": 30, "skills": ["JavaScript", "Node.js", "MongoDB"] } ```

**Key Features of JSON:** - **Human-readable:** JSON is written in a readable format with key-value pairs. - **Language-independent:** JSON is used across various programming languages. - **Lightweight:** JSON files are smaller in size compared to XML.

### 2. What is MongoDB?

**MongoDB** is a NoSQL database that stores data in flexible, JSON-like documents. This makes data integration for certain types of applications faster and easier.

**Key Features of MongoDB:** - **Schema-less:** MongoDB collections do not require their documents to have the same schema. - **Scalable:** MongoDB scales horizontally using sharding. - **Document-Oriented:** Data is stored in BSON format (Binary JSON).

### 3. Setting Up MongoDB

#### Step 1: Create a MongoDB Atlas Account 1. Visit [MongoDB Atlas](https://www.mongodb.com/cloud/atlas/register). 2. Sign up for a free account. 3. Follow the prompts to create your first cluster.

#### Step 2: Install MongoDB Compass 1. Download MongoDB Compass from [here](https://www.mongodb.com/products/compass). 2. Install MongoDB Compass and connect it to your MongoDB Atlas cluster.

#### Step 3: Install Node.js and NPM 1. Download and install Node.js from [nodejs.org](https://nodejs.org/). 2. Verify the installation by running: ```bash node -v npm -v ```

#### Step 4: Install Mongoose 1. Create a new project directory: ```bash mkdir myMongoDBProject cd myMongoDBProject npm init -y ``` 2. Install Mongoose: ```bash npm install mongoose ```

### 4. CRUD Operations with JSON in MongoDB

CRUD stands for Create, Read, Update, and Delete. These are the four basic operations you can perform on data in a database.

#### Create Inserting new data into the database. ```json { "name": "Alice", "email": "alice@example.com", "age": 28, "skills": ["Python", "Data Science"] } ```

#### Read Retrieving data from the database. ```json [ { "name": "Alice", "email": "alice@example.com", "age": 28, "skills": ["Python", "Data Science"] } ] ```

#### Update Modifying existing data in the database. ```json { "name": "Alice", "email": "alice.smith@example.com", "age": 29, "skills": ["Python", "Data Science", "Machine Learning"] } ```

#### Delete Removing data from the database. ```json { "name": "Alice" } ```

### 5. Mongoose Code Drills

#### Setting Up Mongoose

Create a file named `app.js` and add the following content:

```javascript const mongoose = require('mongoose');

// MongoDB Cloud URI const uri = "mongodb+srv://<username>:<password>@cluster0.mongodb.net/mydatabase?retryWrites=true&w=majority";

mongoose.connect(uri, { useNewUrlParser: true, useUnifiedTopology: true }) .then(() => console.log('Connected to MongoDB Cloud')) .catch((err) => console.error('Connection error', err)); ```

Replace `<username>` and `<password>` with your MongoDB Atlas credentials.

#### Define a Schema and Model

```javascript const mongoose = require('mongoose');

const userSchema = new mongoose.Schema({ name: String, email: String, age: Number, skills: [String] });

const User = mongoose.model('User', userSchema);

module.exports = User; ```

#### Create Operation

```javascript const User = require('./models/user');

const createUser = async () => { const user = new User({ name: 'John Doe', email: 'john.doe@example.com', age: 30, skills: ['JavaScript', 'Node.js', 'MongoDB'] });

try { const savedUser = await user.save(); console.log('User saved:', savedUser); } catch (err) { console.error('Error saving user:', err); } };

createUser(); ```

#### Read Operation

```javascript const User = require('./models/user');

const getUsers = async () => { try { const users = await User.find(); console.log('Users:', users); } catch (err) { console.error('Error getting users:', err); } };

getUsers(); ```

#### Update Operation

```javascript const User = require('./models/user');

updateUser(); ```

#### Delete Operation

```javascript const User = require('./models/user');

deleteUser(); ```

### 6. Lab Exercises

#### Exercise 1: Setup and Connect to MongoDB - Sign up for MongoDB Atlas and create a cluster. - Connect to the cluster using MongoDB Compass.

#### Exercise 2: Create a Mongoose Model - Define a schema for a new collection, e.g., `Product`. - Create a model for the schema.

#### Exercise 3: Perform CRUD Operations - Write scripts to perform Create, Read, Update, and Delete operations on the `Product` collection.

#### Exercise 4: Complex Queries and Aggregations - Write scripts to perform complex queries, such as finding products within a price range or aggregating products by category.

#### Exercise 5: Data Validation and Middleware - Implement data validation in your schema. - Use Mongoose middleware to log operations.

### Conclusion

This lab workbook provides an introduction to JSON and MongoDB, guiding you through setting up MongoDB, using JSON for CRUD operations, and practicing with Mongoose code drills. By the end of these exercises, you should have a solid understanding of how to work with MongoDB and Mongoose in a Node.js environment.

Building the College Enrollment System with JSON in MONGODB

Lab Workbook: Introduction to JSON and MongoDB

What is JSON?

What is MongoDB?

Setting Up MongoDB

CRUD Operations with JSON in MongoDB

Mongoose Code Drills

Lab Exercises

⁠

1. What is JSON?

JSON (JavaScript Object Notation) is a lightweight data-interchange format that is easy for humans to read and write, and easy for machines to parse and generate. It is primarily used to transmit data between a server and a web application as text.

Example JSON:

{

"name": "John Doe",

"email": "john.doe@example.com",

"age": 30,

"skills": ["JavaScript", "Node.js", "MongoDB"]

}

Key Features of JSON:

Human-readable: JSON is written in a readable format with key-value pairs.

Language-independent: JSON is used across various programming languages.

Lightweight: JSON files are smaller in size compared to XML.

2. What is MongoDB?

MongoDB is a NoSQL database that stores data in flexible, JSON-like documents. This makes data integration for certain types of applications faster and easier.

Key Features of MongoDB:

Schema-less: MongoDB collections do not require their documents to have the same schema.

Scalable: MongoDB scales horizontally using sharding.

Document-Oriented: Data is stored in BSON format (Binary JSON).

3. Setting Up MongoDB

Step 1: Create a MongoDB Atlas Account

Visit

MongoDB Atlas⁠

Follow the prompts to create your first cluster.

Step 2: Install MongoDB Compass

Download MongoDB Compass from

here⁠

Install MongoDB Compass and connect it to your MongoDB Atlas cluster.

Step 3: Install Node.js and NPM

Download and install Node.js from

nodejs.org⁠

Verify the installation by running:

bash

Copy code

node -v

npm -v

Step 4: Install Mongoose

Create a new project directory:

mkdir myMongoDBProject

cd myMongoDBProject

npm init -y

Install Mongoose:

npm install mongoose

4. CRUD Operations with JSON in MongoDB

CRUD stands for Create, Read, Update, and Delete. These are the four basic operations you can perform on data in a database.

Create

Inserting new data into the database.

{

"name": "Alice",

"email": "alice@example.com",

"age": 28,

"skills": ["Python", "Data Science"]

}

Read

Retrieving data from the database.

json

Copy code

[

{

"name": "Alice",

"email": "alice@example.com",

"age": 28,

"skills": ["Python", "Data Science"]

}

]

Update

Modifying existing data in the database.

json

Copy code

{

"name": "Alice",

"email": "alice.smith@example.com",

"age": 29,

"skills": ["Python", "Data Science", "Machine Learning"]

}

Delete

Removing data from the database.

json

Copy code

{

"name": "Alice"

}

5. Mongoose Code Drills

Setting Up Mongoose

Create a file named app.js and add the following content:

⁠

const mongoose = require('mongoose');

// MongoDB Cloud URI

const uri = "mongodb+srv://<username>:<password>@cluster0.mongodb.net/mydatabase?retryWrites=true&w=majority";

mongoose.connect(uri, { useNewUrlParser: true, useUnifiedTopology: true })

.then(() => console.log('Connected to MongoDB Cloud'))

.catch((err) => console.error('Connection error', err));

Replace <username> and <password> with your MongoDB Atlas credentials.

Define a Schema and Model

const mongoose = require('mongoose');

const userSchema = new mongoose.Schema({

name: String,

email: String,

age: Number,

skills: [String]

});

const User = mongoose.model('User', userSchema);

module.exports = User;

Create Operation

javascript

Copy code

const User = require('./models/user');

const createUser = async () => {

const user = new User({

name: 'John Doe',

email: 'john.doe@example.com',

age: 30,

skills: ['JavaScript', 'Node.js', 'MongoDB']

});

try {

const savedUser = await user.save();

console.log('User saved:', savedUser);

} catch (err) {

console.error('Error saving user:', err);

}

};

createUser();

Read Operation

javascript

Copy code

const User = require('./models/user');

const getUsers = async () => {

try {

const users = await User.find();

console.log('Users:', users);

} catch (err) {

console.error('Error getting users:', err);

}

};

getUsers();

Update Operation

javascript

Copy code

const User = require('./models/user');

const updateUser = async () => {

try {

const user = await User.findOne({ email: 'john.doe@example.com' });

if (user) {

user.age = 31;

const updatedUser = await user.save();

console.log('User updated:', updatedUser);

}

} catch (err) {

console.error('Error updating user:', err);

}

};

updateUser();

Delete Operation

javascript

Copy code

const User = require('./models/user');

const deleteUser = async () => {

try {

const user = await User.deleteOne({ email: 'john.doe@example.com' });

console.log('User deleted:', user);

} catch (err) {

console.error('Error deleting user:', err);

}

};

deleteUser();

6. Lab Exercises

Exercise 1: Setup and Connect to MongoDB

Connect to the cluster using MongoDB Compass.

Exercise 2: Create a Mongoose Model

Define a schema for a new collection, e.g., Product.

Create a model for the schema.

Exercise 3: Perform CRUD Operations

Write scripts to perform Create, Read, Update, and Delete operations on the Product collection.

Exercise 4: Complex Queries and Aggregations

Write scripts to perform complex queries, such as finding products within a price range or aggregating products by category.

Exercise 5: Data Validation and Middleware

Implement data validation in your schema.

Use Mongoose middleware to log operations.

Conclusion

Lab Lesson Workbook: Building a College Enrollment System Using MongoDB

#### Table of Contents

1. Introduction: Make a VSC Program 2. Setting Up MongoDB and Mongoose 3. Defining Schemas and Models 4. Inserting Sample Data 5. CRUD Operations with Mongoose 6. Using Aggregation Pipeline for Predicate Joins 7. Lab Exercises

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.