Articles

PostgreSQL: Clauses and filters

Clauses and filters: Like clause: college=# select * from report where temp_hi:: text like ‘4%’; place | temp_lo | temp_hi | date | humidity | precp ———————————————————– VZG | 32 | 43 | 2023-05-10 | 21 | HYD | 32 | 43 | 2020-07-19 | 24… Read More

MongoDB Query Operators

MongoDB Query Operators There are different types of Operators available in MongoDB which are used to filter the data. 1 – Comparison operator 2 – Logical operator 3 – Element 4 – Evaluation 5 – Geospatial 6 – Array 7 – Bitwise operators 8 –… Read More

MongoDB CRUD Operations

MongoDB CRUD Operations 1 – To create a new database called sample data. Atlas atlas-dsrabt-shard-0 [primary] myFirstDatabase> use sample data. 2 – To create a new collection called students. Atlas atlas-dsrabt-shard-0 [primary] sampledata> db.createCollection(“students”). 3 – To insert one document in to the collection called… Read More

Basic MongoDB Commands Operations

Basic MongoDB Commands Operations 1 – To shows all the databases Atlas atlas-dsrabt-shard-0 [primary] myFirstDatabase> show dbs 2 – To use the database called sample_airbnb Atlas atlas-dsrabt-shard-0 [primary] myFirstDatabase> use sample_airbnb 3 – To show all the collections in a database Atlas atlas-dsrabt-shard-0 [primary] sample_guides>… Read More

Installation Of Robo 3T On Windows

Installation Of Robo 3T On Windows Robo 3T: Robo 3T is a free and open-source MongoDB GUI tool that allows users to manage their MongoDB databases with ease. Robo 3T provides features such as code autocompletion, a built-in query editor, and the ability to save… Read More

Installation Of Studio 3T On Windows

Installation Of Studio 3T On Windows. Studio 3T: Studio 3T is a professional GUI and IDE for MongoDB that allows developers to manage and analyze data quickly and efficiently. With Studio 3T developers can import and export data to and from MongoDB with ease, visualize… Read More

Create an account in MongoDB atlas

Create an account in MongoDB atlas. Steps to create an account in MongoDB atlas 1 – Open the following link in your browser like chrome, edge then you get like the image displayed below. Link: https://www.mongodb.com/atlas/database 2 – Click on try for free which you… Read More

Working with databases in MongoDB Atlas

Working with databases in MongoDB Atlas After setting the databases with clusters, now one organization is created which contains projects and, in that project, we will have clusters. 1 – The organization name is displayed at the top left you can have multiple organisations. 2… Read More

Collection Management In MongoDB

Collection : It is a group of documents in a database.collection is like a table in a relational database. The database contains collections,collections contains documents and the documents contain data in it. Naming restriction for collections in MongoDB: 1. Collection name must begin with a… Read More

About JSON and BSON

About JSON and BSON Both JSON and BSON are data interchange formats used for the representation and transmission of data between applications. JSON: (Java script Object Notation) It is text based format that is lightweight and also human readable format. Based on the javascript syntax… Read More

Installation of MongoDB on Windows Operating System

Installation of MongoDB on Windows Operating SystemInstallation of MongoDB on Windows Operating System To download community version, follow these steps. → Click on the link https://www.mongodb.com/try/download/community. → In version section select the version of MongoDB to download. → In platform select windows. → In package… Read More

OPERATORS IN PYTHON

OPERATORS IN PYTHON Operator: It is defined as a symbol which is responsible for a particular operation between two operands. Python supports different types of operators: 1.Arithmetic Operators               2.Assignment Operators            3.Logical Operators                    4.Comparison Operators            5.Bitwise Operators                    6.Identity Operators                    7.Membership Operators              Arithmetic Operators: They are… Read More

Installation of PostgreSQL

Installation of PostgreSQL As PostgreSQL is an open source, we can download it from official website (www.postgresql.org) by following below steps: Go to official website >> Click on Download >> Choose your System OS >> Click “Download the installer” Select latest version (15.2 present) of… Read More

Introduction to MongoDB

Introduction to MongoDB MongoDB is an open and free NoSQL database management system. It is a document oriented database, i.e. it will store all the data in semi-structured Binary JSON like documents. Features of MongoDB Document Object Data Model: MongoDB stores the data as Binary… Read More

More Latest News »