Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

The article contains information about the while loop  in MySQL and its usage. While Loop in MySQL The while loop, which is one of the …

Below are some of the basic hygiene techniques and concepts we should keep in mind to get the maximum performance out of our query . …

We will install SQL Server 2019 on Ubuntu 18.04 in this article. Our Server Resource Information: CPU : 4 RAM : 16 Disk : 80 …

Logical Standby Database does not support replication of all data types, tables, commands and PL / SQL Packages. Therefore, before converting a Physical Standby database …

The article contains information about CASE WHEN Statement in MySQL as an alternative to the if condition. With the CASE statement used in MySQL as …

If you have more than one server you manage and if you connect to multiple servers with ssh and run single command on multiple linux …

If you are using Linux and want to securely connect to servers without using a username password, you can create a ssh key and connect …

In this article, we will see how to create a user in Centos and how to grant root privileges to a user in Centos. How …

The article contains information about MYSQL IF Statement, ELSEIF Statement and ELSE STATEMENT used to direct the command flow by condition in the MySQL VTY …

What is a logical standby database? Apart from Physical and Snapshot Standby Database, it is another type of Standby Database. It is an active database …