How To
PostgreSQL ADD COLUMN Statement to Add One or Multiple Columns To a Table
If you have been looking for a tutorial on the ALTER TABLE command in Postgres, your search ends here. This statement changes the definition...
How to Create New Oracle Database in 4 Different Ways
TL;DR
There are four main ways to create a database in Oracle: using the CREATE DATABASE command, the DBCA GUI tool,...
Customized Hash Function Python Generator
In this article, we will show how you can take more control over the data in your database by using a custom hash function...
How to Create a New Database in PostgreSQL
In this article, we are going to describe different ways to create a PostgreSQL database from scratch. Here, you will find a tutorial...
How to Download and Install PostgreSQL Database on Windows
In this article, we will focus on starting a PostgreSQL server on your PC. Here, you will find a simple step-by-step PostgreSQL tutorial for...
How to ADD, RENAME, MODIFY, and DROP Column, using the ALTER TABLE Statement in Oracle
In this article, we are going to talk about the ALTER TABLE statement and different ways to use it in Oracle. The syntax provided...
How to Connect to MySQL Server Databases Remotely
Distributed environment is hardly a new notion in the world of software. For one, you no longer need to host MySQL servers and databases...
How to Rename a Table in Oracle: the Ultimate Guide
TL;DR
To rename a table in Oracle, use either the RENAME or ALTER TABLE RENAME TO command based on context. This...
Create Table in PostgreSQL: A Guide With Examples
The PostgreSQL CREATE TABLE command is used to define a new table and structure your data with specific column types and constraints. It’s one...
What Is InnoDB in MySQL? Tutorial with Examples and Performance Tuning Tips
There is a number of powerful MySQL storage engines at our disposal, and InnoDB is undoubtedly one of the most popular ones. It is...
