Rajendra Gupta
Work with the email addresses using the SUBSTRING function

Understanding PostgreSQL SUBSTRING function

September 21, 2024 by

PostgreSQL is an open-source, object-oriented relational database system with reliability, performance, and robustness. It supports SQL (relational) and JSON (non-relational) queries.PostgreSQL’s popular features include Multi-Version Concurrency Control (MVCC), point-in-time recovery, granular access controls, tablespaces, and asynchronous replication.

Read more »
Nisarg Upadhyay
Graphical user interface, application Description automatically generated

Different ways to identify and change compatibility levels in SQL Server

July 22, 2024 by

Compatibility level in SQL Server refers to a database property that determines the syntax and behavior of the database, allowing it to be compatible with earlier versions of SQL Server. Each version of SQL Server introduces new features, improvements, and changes to the query optimizer, which may affect how queries are executed and how results are returned.

Read more »
Manvendra Singh
Backup storage redundancy updated for cosmos db account

Configure backup storage redundancy for Azure Cosmos DB account

May 15, 2024 by

This article will explain backup storage redundancy for Azure Cosmos DB. Backups are a critical feature to keep copies of our data to ensure data protection and recoverability in case of any accidental deletion, updating, or any kind of disaster. But this is not enough to run backups only to save its copies. We must also protect those backup copies from accidental deletes or corruption and ensure their proper resiliency should be in place to keep backups safe from any unforeseen circumstances. It depends on the criticality of your data whether you want to keep them locally to want to replicate them in other locations or regions to ensure their resiliencies.

Read more »
Arindam Mondal
SQL IN with Subquery

Understanding the SQL IN operator with examples

March 19, 2024 by

Today we will learn about the SQL IN operator. The RDBMS systems are very popular today in terms of data storage, data security, and data analysis. SQL stands for Structured Query Language which is used to create, update, or retrieve data in RDBMS or Relational Database Management Systems like SQL Server, Oracle, Microsoft Access, MySQL, and PostgreSQL.

Read more »
Manvendra Singh
Run SQL SELECT UNIQUE statement

Difference between SQL SELECT UNIQUE and SELECT DISTINCT

January 16, 2024 by

Today, we will learn the difference between SQL SELECT UNIQUE and SELECT DISTINCT in this article. As we all know that SQL is a query language that is used to access, create, delete, and modify data stored in a database system like SQL Server, Oracle, MySQL, etc. All these database systems have their query language like TSQL, PLSQL, etc. These query languages are based on ANSI standard SQL language which can also be used in these database systems to perform any transaction.

Read more »
Manvendra Singh
use case with ORDER BY clause

How to do a group by clause

April 12, 2023 by

Today, I am going to explain how to do a group by clause in your SQL queries. SQL (Structured Query Language) is a very popular query language that is widely used to access and manipulate records stored in a database. The GROUP BY clause is also a SQL statement that is used to group identical values. Let’s first understand this clause what it does and why we use this clause in SQL queries.

Read more »
Arindam Mondal
'HELLO',1,2

Understanding Substring in Oracle SQL

March 22, 2023 by

The Oracle SQL database provides many useful functions to use with your query or programming. The SUBSTR function is one of the most used string functions in the Oracle SQL database. I will also discuss a few important string functions TRIM, UPPER, and LOWER which can be used along with substring functions. In this article, we will discuss substring in Oracle SQL.

Read more »
Manvendra Singh
Compare PostgreSQL vs MySQL

PostgreSQL vs MySQL: Understanding their differences

March 13, 2023 by

Today, we will compare the two most popular database products PostgreSQL vs MySQL, and explain the differences between them in this article. There are many database systems based on the relations database management system (RDBMS) concept in the market. Some of them are Oracle, SQL Server, MySQL, PostgreSQL, etc. It’s really important to understand the differences between them before selecting any database product for your application. Keeping this in mind, I am writing this article to explain these two database systems i.e., PostgreSQL vs MySQL, and compare them from various aspects so that you can understand them before taking any decision for your requirements.

Read more »