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

General Concepts: First of all, the database has two files by default. These are data file with mdf extension (called Primary Data File) and transaction …

I described creating an updateable view in the article “How To Create an Updatable View in PostgreSQL“. In this article I will describe how to …

In PostgreSQL, we can perform insert, update and delete operations on the relations specified in the view via views. Restrictions Of course there are some …

When designing a database, it is necessary to analyze the disk requirement correctly and determine the size of the disks from the beginning. Sometimes things …

Error: When clients attempts to connect to the database, they can not connect with the error “ORA-12502: TNS: listener received no CONNECT_DATA from client”. Reason: …

  In this article, we will first talk about how to configure the file group structure when the database is first created or comes from …

PROBLEM: The error “java.sql.SQLException: OALL8 is in an inconsistent state” is being retrieved when the query is executed. REASON: The database version is incompatible with …

You can regularly query your queries written with the Common Table Expression by converting them to Recursive View. We have already done an example of …

  With CTE we can generate recursive queries. We can create a code block and use it over and over again. In this article, I …

By using Materialized Views in PostgreSQL, you can access data faster by physically holding the data in the view. I will go over an example …