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 👉👉👉Please check the below video 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… 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
