Compass Installation

Installation

Starting MongoDB Server and Client Connection

Database vs Collection vs Document vs Data

Understanding Database In MongoDB

Creating a Database Part I

Database Naming Rules In MongoDB

Deleting a Database

Understanding Collection in MongoDB

Naming Rules for Collection

Creating Collection

Understanding MongoDB Data Type

Understanding JSON and BSON

JSON Syntax

Array in JSON

Understanding MongoDB Document

Embedded Nested Documents by Example

Embedded Documents

Array Containing Object

Important Points on Embedded Documents

Patterns in Document Writing

Important Points on Mongo DB Document

Understanding Document Insertion

Example I Lab

Example I Board

Syntax

Finding Documents in a Collection

Example II Lab

How to Manually Insert id Lab

Example II Board

How to Manually Insert id Board

Error Inserting Existing id

Example 1 Lab

Custom ID

Example 1 Board

Syntax

Understanding insert

Insert by Example

Option Ordered Default

Option Ordered False

Understanding Brackets in JSON

Exercise and Solution 2

Exercise and Solution 1

Exercise and Solution 4

Exercise and Solution 3

Exercise and Solution 5

Exercise and Solution 6

Sample Data

Importing CSV file to MongoDB Using Compass

Converting String to Double

No Match

Query Operators

Exercise and Solution II

Exercise and Solution I

Understanding findOne

Exercise and Solution I

Exercise and Solution II

Understanding Projection

Projection with find

Query Operators with find

Understanding find

Querying Array Elements

Embedded Documents

Exercise 1

Exercise 2

Exercise 3

Querying Array Elements with IN ALL and SIZE

Multiple Fields Update

Understanding updateOne

UnpdateOne by Example

Options in updateOne

Update Operators set inc min max rename mul unset

USA Cities Dataset

World Cities Dataset

Exercise and Solution unset multi updateMany

Understanding updateMany and update

Exercise and Solution set multi updateMany

Understanding how to update multiple documents

Exercise and Solution min update

Exercise and Solution mul updateMany

Exercise and Solution rename

Understanding the difference between setOnInsert and set II

Understanding the difference between setOnInsert and set III

Understanding the difference between setOnInsert and set IV

Understanding the difference between setOnInsert and set I

Introduction to Deleting Documents

Exercise and Solution remove I

deleteOne Part II

deleteOne Part I

Exercise and Solution justOne

Exercise and Solution remove II

remove

Exercise and Solution deleteMany

deleteMany

Understanding Limit II

Understanding Limit I

Understanding Skip II

Combining Limit and Skip I

Combining Limit and Skip II

Understanding Skip I

Understanding sort II

Understanding sort I

How to Create Indexes

Unique Index

Compound Fields Indexing

MultiKey Index

Understanding Indexes

Listing Indexes

Deleting Indexes Example 1

Deleting Indexes Example 2

Deleting Indexes

OPTIONS in Creating Indexes

MongoDB Operator Types In General

Documents Dataset for Practice

lt Exercise and Solution 1

gt Exercise and Solution 1

gt Exercise and Solution 2

Understanding Comparison Operators

lte Exercise and Solution

gte Exercise and Solution

lt Exercise and Solution 2

eq Exercise and Solution

in Exercise and Solution 2

in Exercise and Solution 1

ne Exercise and Solution

nin Exercise and Solution

and Exercise and Solution 1

and Exercise and Solution 2

or Exercise and Solution 1

or Exercise and Solution 2

Understanding Logical Operators

nor Exercise and Solution

not Exercise and Solution

Secret to Writing Effective Query

exists Exercise and Solutions 1

Understanding the Element Operators

exists Exercise and Solutions 2

exists Exercise and Solutions 4

exists Exercise and Solutions 3

type Exercise and Solutions 1

type Exercise and Solutions 2

type Exercise and Solutions 3

Dataset

mod Possible Errors

mod Syntax with an Example

mod Floating Points Arguments

mod Exercise and Solution

text Understanding the text Operator

text Searching for a Single Word

text Searching for Different Words

text Searching for a Phrase

text Exclude Documents That Contain a Term

text language Searching in Other Language

text caseSensitive

Understanding the Evaluation Operators

text search Search Score

text diacriticSensitive

text Score & Sort

text Sorting

text Score & Sort II

Handson Understanding Regular Expression

Handson Anchors

Understanding Regular Expression

Anchors

Quantifier

Handson Quantifier

Handson Common MetaCharacters

Group Range

Common MetaCharacters

Handson Character Classes

Handson Group Range

Handson Options

Character Classes

Options

Geometry Types

Introduction to GeoSpatial

Inserting GeoSpatial Data Example I

Inserting GeoSpatial Data Example III

Inserting GeoSpatial Data Example II

GeoSpatial Syntax

Importing Restaurants & Neighbourhoods GeoJSON Data via Terminal

GeoSpatial Operators

Importing Restaurants & Neighbourhoods GeoJSON Data via Compass

Ways of Creating Index on Document of GeoSpatial Data

Querying GeoSpatial Data Without Index

nearSphere Exercise and Solution

Querying GeoSpatial Data With Index

geoIntersects Exercise and Solution

centreSphere with geoWithin Exercise & Solution

near Exercise and Solution

box with geoWithin Exercise and Solution

geoWithin Exercise and Solution

next Exercise and Solution I

Understanding MongoDB Cursor

next Exercise and Solution II

count

forEach

itcount

isExhausted

hasNext

limit skip sort

map

toArray

size

objsLeftInBatch

Cursor Methods

Manual Aggregation

Syntax

Understanding Aggregation in MongoDB

Stages Expression and Accumulators

Aggregation Example I

Aggregation Example II

Aggregation Example III

Comparing SQL and MongoDB ClausesOperating

Aggregation Example IV

match Exercise and Solution I

match Exercise and Solution II

match Exercise and Solution III

match Exercise and Solution IV

match Exercise and Solution V

project Exercise and Solution II

project Exercise and Solution I

project Exercise and Solution III

group Exercise and Solution I

group Exercise and Solution III

group Exercise and Solution II

group Exercise and Solution IV

group Exercise and Solution V

group Exercise and Solution VI

ifelse Syntax

ifelse Exercise and Solution 2

ifelse Exercise and Solution 1

ifelse Exercise and Solution 3

switchcase syntax

ifelse Exercise and Solution 4

switchcase Exercise and Solution 1

switchcase Exercise and Solution 2

Date

new Date & ISODate More Example

Understanding the MongoDB Dates and Times

Exercise and Solution 1

Exercise and Solution 2

new Date & ISODate

Example

Understanding MongoDB lookup

Validation Rules

Understanding MongoDB Schema Validation

Recommended operator for validation

Creating Validation for a New Collection by Example

Creating Validation for a New Collection by Example 2

Options in Validation

Creating Validation for an Existing Collection by Example

MongoDB vs MySQL TermConcept

Creating Tables Collection and Inserting Data LAB

Exercise and Solution 1 SQL vs MongoDB

Creating Tables Collection and Inserting Data

Exercise and Solution 2 SQL vs MongoDB

Exercise and Solution 3 SQL vs MongoDB

Exercise and Solution 5 SQL vs MongoDB

Exercise and Solution 6 SQL vs MongoDB

Exercise and Solution 4 SQL vs MongoDB

Exercise SQL vs MongoDB

Exercise and Solution 7 SQL vs MongoDB

Exercise and Solution 8 SQL vs MongoDB