Different types of availability options Azure offers different types of availability options which includes. 1. No infrastructure redundancy required. 2. Availability zone 3. Virtual machine scale set 4. Availability set 1. No infrastructure redundancy required. • This does not provide any redundancy. • When you… Read More
KILLING SESSIONS: In PostgreSQL, you can terminate or “kill” a session using the pg_terminate_backend function. This function allows you to forcefully terminate a specific session, which can be helpful in scenarios where a session is unresponsive or causing issues. We can kill PostgreSQL session in… Read More
How to create the azure account Step-1: Go to google browser and search for portal azure login. Step 2: It will open Microsoft Azure Portal in that select sign in. Step 3: It will open like this, click on to start free for access. Step… Read More
Creation of Image for a VM in Azure Before the creation of an image of the virtual machine install all the software that you want to be installed in all the virtual machines that you want to create with the help of the image you… Read More
Roles In MongoDB Part – 2 User-Defined roles: MongoDB provides many built-in roles to manage the access to the database.but when the built-in roles did not meet your requirement privileges then you can go for creating your own roles. Creation of user-Defined role: To create… Read More
Roles in MongoDB MongoDB uses Role Based Access Control (RABC) to provide access to any MongoDB system. MongoDB supports multiple authentication methods like x.509 Certificate Kerberos Authentication and may like these authentication methods and the access to the database granted through the role-based authorization. There… Read More
Remote connection from pgadmin4 to a Linux server running PostgreSQL: To establish a remote connection from pgadmin4 to a Linux server running PostgreSQL, Follow the below steps: 1. Install Pgadmin4: First install pgadmin4 on your local machine. You can download it from the official website… Read More
Databases In MongoDB In MongoDB the databases are divided in to two types based on the data they store they are. 1. Default databases 2. Non default databases Non default databases: The databases that are created explicitly depend on the needs of the users. Default… Read More
Remote Connections in PostgreSQL: Remote connections will allow you to connect to a PostgreSQL server from a different machine or network. In this article, we will explore the steps to establish remote connections in PostgreSQL and provide best practices for securing these connections. This article… Read More
MongoDB Commands On Operators To create a collection called student data.
|
1 |
Atlas atlas-dsrabt-shard-0 [primary] practisedata> db.createCollection("studentdata") |
To get all the documents in a collection called student data without any filter.
|
1 |
Atlas atlas-dsrabt-shard-0 [primary] practisedata> db.studentdata.find() |
To get all the documents whose total marks is equals to 560.
|
1 |
Atlas atlas-dsrabt-shard-0 [primary] practisedata> db.studentdata.find({totalmarks:{$eq:560}}) |
To get all the documents… Read More
