Self-Reflection of MongoDB-Workshop

# Day1 (1st May 2021)

👉 Introduction of the file system?

🎯The data we will stored in file and that file we basically stored in folder but in comparison to mongodb which is basically nosql database we store data in form of documents .Documents stored in collection and collections are part of Database . So collections == table and record== documents.

👉 What is Data Model?

🎯Data model is the way to organise data in any database to enhance performance of the system and also the space complexity.

👉 What are SQL and NoSQL databases?

🎯In Sql we basically defined schema and all of the data would be part of that schema but in case of nosql database we will stored per document as schema based. So in better terms as soon we inserted data dynamic column added per record.

👉 Basic Introduction of MS. Excel

🎯MS Excel is a software from Microsoft that helps us to store data in the form of spreadsheets in rows and columns.

👉 What is schemaless DB?

🎯In Schemaless DB, the fields are not fixed and any field can be added anytime on the fly as per our requirement, this gives us the flexibility to store data.

👉 What is insert operation

🎯By the help of the Insert operation, we can add documents to the collection of our NoSQL database.

👉 What is Document oriented DB?

🎯A database in which each record is treated as a complete document is known as a document oriented database. Mongo DB is a type of document oriented database.

👉 How to configure MongoDB server?

🎯We have to set environmental variables in windows to set mongo server and program behind is mongod and mongo is client program to connecting mongo server.

👉 Introduction of JSON language

🎯Json is basically java script object notation which store data in key value pair and mongodb used this json as storing their object/documents in collection.

👉 How to configure compass(MongoDB GUI)

🎯There are 3 ways of accessing mongo server

1. mongocli
2. api
3. gui

🎯For the Gui program we will used one software know as compass and for the api we are using python and package name is pymongo

👉 How to upload dataset in MongoDB

🎯We can upload file as json and csv in mongodb using mongoinsert as program

👉 What are indexes?

🎯Indexes are a fast way to retrieve/search data from a document in a database as it improves input/output performance.

👉 What is the primary key?

🎯Primary key is a unique key assigned to every document in a NoSQL database.

# Day2 ( 8 May 2021)

👉 What is indexing in MongoDB ?

🎯Indexing- Indexes support the efficient resolution of queries. Without indexes, MongoDB must scan every document of a collection to select those documents that match the query statement.

👉 What is sharding in MongoDB ?

🎯Sharding is the process of grouping the data and splitting this data to multiple slave nodes also called as replica instances.

👉 What is Replica set in MongoDB ?

🎯By default in MongoDB find() scans the entire collection known as collection scanning(COLLSCAN) and if we use indexing then that scanning is IXSCAN.

👉 What is IXSCAN and COLLSCAN in MongoDB ?

1.IXSCAN is index scanning.

2.COLLSCAN is collection scanning : scans all the document present in a collection

👉 What is Compound Indexing in MongoDB ?

🎯When we create an index of two or more items at once then it is called compound indexing.

👉 What is MongoDB aggregation pipeline ?

🎯An aggregation pipeline is a framework provided by MongoDB by which we can create a set of queries or pipelines in the form of various stages.

👉 What is Mongo Router Program in MongoDB ?

🎯Mongo Router program in MongoDB is actually a router kind of a program present in the master node of the cluster. It holds the metadata of the data present in each slave node. So when there is a client query for the data it redirects the query to that particular slave node that contains the data.

👉 What is Referencing Model in MongoDB ?

🎯Referencing model is a kind of architectural design for storing the data into multiple documents.

👉 What is the use of MongoDB Atlas ?

🎯MongoDB Atlas is a cloud platform provided by MongoDB where we can create our cluster.

👉 What are clusters in MongoDB ?

🎯Cluster is an architectural design of master and slave nodes/target nodes to prevent the problem of single point of failure.

Thanks for reading !!