RajKishore

Rajkishore Sahoo is a Microsoft Azure consultant with more than 14 years of hands-on experience building cloud-native data solutions across Azure and AWS, focused on Azure SQL Database, Azure SQL Managed Instance, and the pipelines that connect them to production apps. Day to day, he provisions Azure SQL instances, configures firewalls and connection strings, tunes queries for cloud workloads, and wires databases into Azure Functions and Logic Apps. Read more

How to return a table in PostgreSQL function

by
Returning Record using PostgreSQL Function

In this PostgreSQL tutorial, I will demonstrate how to return table from function in PostgreSQL function. You will understand the syntax of the function, and you will also create a simple function to know how you can define your function with different parameters. How to return a table in PostgreSQL function Sometimes, you need to write … Read more >>

PostgreSQL Add Foreign Key If Not Exists

by
PostgreSQL Add Foreign Key If Not Exist Registrations to Courses

In this PostgreSQL tutorial, you will learn how to add a foreign key if it does not exist in PostgreSQL, where you will understand why you need to add the foreign key to tables. Also, you will use the PL\PGSQL with the table pg_constraint to check whether the existing table has a foreign key or … Read more >>

Postgres Length Function

by
Postgres Length Function on Tables

In this PostgreSQL tutorial, I will show you how to use the Postgres length function to find the length of the given string. Then I will explain how to use the Postgres length function with columns in the table. Additionally, you will understand the functions in PostgreSQL which return the length of the string in … Read more >>

Group By in PostgreSQL

by
Group By in PostgreSQL with More Than One Column

In this PostgreSQL tutorial, I will show you how to use GROUP BY in PostgreSQL with syntax. Also, you will understand how to use the GROUP BY clause with aggregate functions such as count(), sum() and etc. Additionally, I will show you how to use the GROUP BY clause with multiple columns and the JOIN … Read more >>

How to Use Postgresql Having Clause

by
Postgresql Having Clause with Count()

In this PostgreSQL tutorial, I will show you how to use PostgreSQL Having clause where you will learn how to filter the aggregated result using the HAVING clause based on the given condition. Additionally, I will show how to use different aggregate functions such as count(), sum(), min(), and max() along with the HAVING clause. … Read more >>

How to Delete Row in PostgreSQL

by
How to Delete Multiple Rows in PostgreSQL

In this PostgreSQL tutorial, I will teach you how to delete row in PostgreSQL. Also, you will learn about deleting a single row or multiple rows from the table. Then at the end, I will show you how to return the deleted rows from the table and also how to delete all the rows from … Read more >>

How To Check Oracle Database Read Write Mode

by
check read write in oracle database

In this Oracle tutorial, we will learn about what is read-write mode in the Oracle database. We will also learn the procedure of how to check the read-write mode in the Oracle database. What is Read Write in Oracle Database In Oracle Database, Read Write is basically a modifier that is used to alter the … Read more >>

How to Check and Set Database Timezone in Oracle?

by
Check Database and sessiontime in Oracle

In this Oracle tutorial, we will check different ways to check the timezone in an Oracle database. Also, I will show you how to set the database timezone and session timezone in Oracle. How to Check Oracle Database Timezone Time zones are used because it is easy for the clients in frequent communication to keep … Read more >>

PostgreSQL CASE Multiple Columns

by
PostgreSQL CASE Multiple Columns Simple CASE

In this PostgreSQL tutorial, we will learn about PostgreSQL CASE Multiple Columns with different examples such as using the simple and searched CASE. What are PostgreSQL CASE Multiple Columns? Similar to IF-THEN-ELSE statements in other programming languages, the CASE statement in PostgreSQL expresses a condition. It allows us to conditional login in SQL queries, which … Read more >>

PostgreSQL Insert Into Table Select * From Another Table

by
PostgreSQL Insert into Table Select from Another Table

In this PostgreSQL tutorial, we will know how PostgreSQL Insert Into Table Select * From Another Table with syntax and examples. PostgreSQL Insert Into Table Select * From Another Table Consider a situation where you need to insert the data from one table to another table, “What will you do?”. You will use the statement … Read more >>