Rohit Naidu Latest Articles

How to rename a column in Postgresql database table in Dbeaver.
Postgresql

How to rename a column in Postgresql database table in Dbeaver.

RENAME COLUMN It can usually happen that you need to change an existing column in a database table. Possibly due...
Read More
How To Create New Database In Postgresql Using Dbeaver?
Postgresql

How To Create New Database In Postgresql Using Dbeaver?

CONNECT TO EXISTING DATABASE A database and user named postgres are automatically created when Postgresql is installed on your computer.The...
Read More
How to create table in SQL/Postgresql database?
Postgresql

How to create table in SQL/Postgresql database?

DATA DEFINITION LANGUAGE Table creation in SQL is a Data Definition Language (DDL) command. The database's structure is related to...
Read More
Postgresql SQL Joins – Inner | Left | Right | Full Join
Postgresql

Postgresql SQL Joins – Inner | Left | Right | Full Join

TABLE DETAILS Tables used for explaining Postgresql joins are : Courses, Subjects and Students -- CREATING COURSES TABLE create table...
Read More
How to rename one or multiple columns using python pandas?
Python Pandas

How to rename one or multiple columns using python pandas?

There are several ways to change the name of columns in a Python pandas data frame or series. In your...
Read More