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
ENVIRONMENT VARIABLES IN PostgreSQL: These are useful to avoid hard-coding database connection information into simple client applications, for example. To start a PostgreSQL server, you can run the following command:
|
1 |
[postgres@postgres1 ~]$ /usr/local/pgsql/bin/pg_ctl –D /u01/data start |
However, you can also use an environmental variable to create a shortcut for this… Read More
CLUSTER AND MULTICLUSTERS IN POSTGRESQL: In PostgreSQL Before you can start a PostgreSQL server, you need to create a cluster. A cluster refers to a collection of databases managed by a single instance of the PostgreSQL server. When you install PostgreSQL, It doesn’t automatically create… Read More
MongoDB Query Operators Part-3 Evaluation Query Operators MongoDB Evaluation operators are used to evaluate the structure of overall data or the individual fields in the document. They are of six types of Evaluations operators 1. mod ($mod) 2. text ($text) 3. where ($where) 4. jsonSchema… Read More
