Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
After connecting to the database in PostgreSQL, you may want to change the user you are connected to. You may want to read the article …
Read More »
Which Queries Fill The Tempdb
Tempdb is the most important of the system databases in terms of performance. Therefore, it is necessary to correctly configure tempdb in instances that …
Read More »How To Create a .profile File To Connect The Oracle
To connect to Oracle with sqplus you need to load the environment. You need to use the .oraenv or .profile file to load the …
Read More »Spool Concept in Execution Plan(Eager Spool, Lazy Spool)
Sometimes we see operators like Eager Spool, Lazy Spool In the Execution Plan . In this article we will see what these operators do. …
Read More »How To Connect To Oracle With sqlplus
In this article, I will tell you how to connect to the oracle database with sqlplus after connecting to server with ssh. We are …
Read More » How To Create a User On PostgreSQL And List All Users
To create a user in PostgreSQL, we first connect to PostgreSQL. To connect to PostgreSQL You can read the article named “How To Connect To …
Read More »JOIN Types In SQL Server Execution Plan
In this article, we will examine the join types in the execution plan. Before you read this article, you can get more from this …
Read More »How To Create a Table and List All Tables On PostgreSQL
You can use the following commands to create tables in PostgreSQL Databases and to list all the tables in the database. CREATE TABLE …
Read More »How To Connect To Database On PostgreSQL
You can use pgadmin or psql to connect to the PostgreSQL database. I do not prefer to do database administration with pgadmin. You can …
Read More »
How To Connect To Oracle With Toad
To connect to Oracle with Toad, you need to download and install Toad. TNS Information You must write the tns information of the database you …
Read More »