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

We will install Oracle grid infrastructure 11g on linux in this article. We are starting the Grid Infrastructure installation. We do this only on one …

We will install Oracle RAC 11g in this article. First, We check cluster services before starting Oracle installation. We do this in both nodes. (with …

This article contains information about oracle date functions such as sysdate, last_day, add_months, extract. Oracle Date Functions Oracle has several functions to operate on date …

Today, I will introduce you a nice extension that we can use instead of VACUUM FULL in PostgreSQL. I recommend using it in your prod …

This article contains information about oracle numeric/math functions and their usage. Numeric/Math Functions Oracle has several functions for processing numerical data. ABS Function in Oracle …

This article contains information about what is elasticsearch heap size, garbage collector and elasticsearch heap size recommended. What is Elasticsearch Heap Size? It is a …

We will install  couchbase Server on ubuntu 16.04 in this article. Please visit the link below for minimum system requirements. Link : https://docs.couchbase.com/server/current/install/plan-for-production.html WARNING: Make sure …

In this article, we will install apache cassandra on Centos 7 in a Standalone structure. Now let’s start installing our Cassandra NoSQL database on Centos …

What is real time apply in dataguard? If media recovery is started with the following command after installing Data Guard in versions prior to Oracle …

This article contains information about oracle string functions such as length, substr, concat, trim in Oracle database management system. What is Oracle string function? Oracle …