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.

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

How To Create New Database In Postgresql Using Dbeaver?

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

How to create table in SQL/Postgresql database?

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

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

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

How to rename one or multiple columns using python pandas?

October 15, 2022
There are several ways to change the name of columns in a Python pandas data frame or series. In your...
Read More
Tags:, , ,