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

In this article we will see how to remove a database from oem. You should remove deleted databases from oem. First connect to oem and choose Targets-> All Targets as …

You can create database on PostgreSQL easily. You can specify some parameters when creating database. If you want more about Postgresql you may want to read our other articles from …

We can combine more than one table through equi-columns in tables and perform joins in a single result set. There are a few kinds of join types. The result set …

What are Oracle SQL Profiles? Oracle Profiles allow us to manage users according to certain policies in Oracle. Below you can find explanations of the most important ones from my …

First of all, the server you want to send mail from must have the permission to sed mail. You can get help from the Exhange team. mailx Linux Installation We …

I wrote this article for regularly checking the disk usage rates of the PostgreSQL databases that I manage. You can use the script which I will share to send disk …

What is a execution plan in SQL? Execution plan is a road map that determines how the query will work. Will the query use the index or will it scan …

What is Crontab? If you want to perform regular operations(for example schedule a task) on Linux, you should create a cron job. Create a Crontab Job To create a Crontab …

What is Unique Constraint in SQL Server? The Unique Constraint guarantees the uniqueness of the colum or column on the table. It can be created on one or more columns …

If you are reading this article, you should read my articles “What is Primary Key And Foreign Key” and “What is Unique Constraint” at first. After reading these articles, let’s …