PostgreSQL tutorial to create a user

November 12, 2023 by Daniel Calbimonte

Introduction to the PostgreSQL tutorial to create a user

In this article, we will show a PostgreSQL tutorial to create a user using PgAdmin and PL/PgSQL.

MySQL substring uses with examples

October 14, 2023 by Rahul Mehta

This article will provide an understanding of different ways to use substring in MySQL.

An introduction to PostgreSQL Data Types with examples

September 15, 2023 by Arindam Mondal

This article will show PostgreSQL Data Types with various examples.

SQL Unit Testing reference guide for beginners

August 11, 2023 by Esat Erkec

In this article, we are going to learn the basics of SQL unit testing and how to write a SQL unit test through the tSQLt framework.

How to install PostgreSQL on Ubuntu

July 13, 2023 by Rajendra Gupta

This article covers the different methods to install Postgres on Ubuntu.

Different methods for monitoring MongoDB databases

June 14, 2023 by Hadi Fadlallah

This article explains what database monitoring is and why it is essential. Then, it illustrates the different methods for monitoring MongoDB NoSQL databases.

SQL Machine Learning in simple words

May 15, 2023 by Haroon Ashraf

This article is about SQL Machine Learning which is one of the most interesting topics equally attractive to both beginners and professionals of different areas of expertise.

Introduction to the SQL Standard Deviation function

April 21, 2023 by Gauri Mahajan

In this article, we will learn about one of the important statistical functions, the SQL Standard Deviation function. Read more »

How to do a group by clause

April 12, 2023 by Manvendra Singh

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.

PostgreSQL Tutorial for beginners

April 6, 2023 by Daniel Calbimonte

Introduction to the PostgreSQL tutorial

In this article, we will have a tutorial to learn PostgreSQL. According to Statista, PostgreSQL is the 4^th most popular database in the world (the other ones are Oracle, SQL Server, and MySQL). That is why we think it is an important DBMS to learn.

MySQL group_concat() function overview

March 28, 2023 by Rahul Mehta

This article will provide an understanding of how to effectively use group concatenation in MySQL.

Understanding Substring in Oracle SQL

March 22, 2023 by Arindam Mondal

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.

PostgreSQL vs MySQL: Understanding their differences

March 13, 2023 by Manvendra Singh

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.

Understanding the Scalability in Oracle Database

March 9, 2023 by Randheer Parmar

When an application grows the associated database grows automatically. It needs to be scaled to a larger machine or server and overall configuration needs to be increased to handle the application and database performance requirement.

Learn SQL: Insert multiple rows commands

March 6, 2023 by Hadi Fadlallah

This article explains the different approaches used to insert multiple rows into SQL Server tables.

MySQL Cluster in simple words

February 23, 2023 by Haroon Ashraf

This article provides an overview of MySQL Cluster in a simple understandable manner suitable for both database beginners and professionals.

SQL Cheat Sheet for Newbies

February 21, 2023 by Esat Erkec

In this SQL cheat sheet, we’ll look at sample SQL queries that can help you learn basic T-SQL queries as quickly as possible.

How to use the CROSSTAB function in PostgreSQL

February 17, 2023 by Rajendra Gupta

This article will explore the use of the CROSSTAB function in PostgreSQL.

PSQL stored procedures overview and examples

February 14, 2023 by Daniel Calbimonte

In this article, we will learn how to create PostgreSQL stored procedures using PSQL.

Migrating Oracle Database to Azure SQL Database

February 9, 2023 by Randheer Parmar

Data Modernization has become important nowadays. Organizations are looking into options to migrate their on-premises database to a cloud and some other heterogeneous databases. In this article, we will see the strategy and options to migrate the Oracle database to the Azure SQL database. We will be leveraging the SSMA tool for migrating the database.

A quick overview of MySQL foreign key with examples

February 7, 2023 by Gauri Mahajan

In this article, we will learn how to work with MySQL foreign keys with a few examples.

Common use cases of SQL SELECT Distinct

February 2, 2023 by Haroon Ashraf

This article talks about the commonly used scenarios of SQL Select Distinct in an easily understandable format equally suitable for beginners and professionals.

SQL Practice: Common Questions and Answers for the final round interviews

January 26, 2023 by Esat Erkec

In this article, we are going to make a SQL practice exercise that will help to prepare for the final round of technical interviews of the SQL jobs.

Introduction to SQL Escape

January 24, 2023 by Rahul Mehta

This article will provide an introduction to SQL escape characters for using special characters and their characteristics.

SQLShack