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
JOIN OPERATION IN PostgreSQL: In PostgreSQL, the JOIN clause is used to combine rows from two or more tables based on a related column or condition. It specifies how the tables should be joined and on which columns the join should be performed. There are… Read More
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
In PostgreSQL, “ALTER” and “UPDATE” are two different SQL commands used to modify data in a database. “ALTER” is used to modify the structure of the database, while “UPDATE” is used to modify the data stored within the database. Update: The UPDATE command plays a… Read More
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
CREATING A NEW TABLE You can create a new table by specifying the table name, along with all column names and their types. Syntax for table creation: CREATE TABLE table_name( column1 datatype, column2 datatype, column3 datatype, columnN datatype, PRIMARY KEY (one or more columns) ); An example for creating table on weather… Read More
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 PostgreSQL Through YUM & RPM Methods These are another two methods of installation of PostgreSQL in Linux systems: 1 – YUM Installation. 2 – RPM Installation Installation of PostgreSQL through YUM package manager in Linux System: If you are using a Linux system,… Read More
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. 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. 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 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
Installation of PostgreSQL Linux using Source Code: To begin, connect to the Linux virtual Machine via PuTTY using IP address. To obtain the IP address, log into the virtual machine and enter the command ‘ifconfig’ in the terminal. Now open Putty and enter the IP… Read More
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 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 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
Guide to Installing VirtualBox on Windows for Running Linux Virtual Machines: If you’re a Windows user, who wants to learn PostgreSQL on a Linux Platform, one of the best solutions is to use Linux virtual machines in VirtualBox. In this article, we’ll guide you through… Read More
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 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 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
