The purpose of this article is to give newbies some basic advice about SQL performance tuning that helps to improve their query tuning skills in SQL Server.
Read more »Understanding the SQL IN operator with examples
March 19, 2024Today 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 »Finding Duplicates in SQL
February 7, 2024This article will provide an understanding of identifying duplicate values in SQL.
Read more »Difference between SQL SELECT UNIQUE and SELECT DISTINCT
January 16, 2024Today, 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 »An overview of SQL Server monitoring tools
December 12, 2023This article explains some of the popular SQL Server monitoring tools and techniques.
Read more »PostgreSQL tutorial to create a user
November 12, 2023Introduction 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.
Read more »MySQL substring uses with examples
October 14, 2023This article will provide an understanding of different ways to use substring in MySQL.
Read more »An introduction to PostgreSQL Data Types with examples
September 15, 2023This article will show PostgreSQL Data Types with various examples.
Read more »SQL Unit Testing reference guide for beginners
August 11, 2023In 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.
Read more »How to install PostgreSQL on Ubuntu
July 13, 2023This article covers the different methods to install Postgres on Ubuntu.
Read more »Different methods for monitoring MongoDB databases
June 14, 2023This article explains what database monitoring is and why it is essential. Then, it illustrates the different methods for monitoring MongoDB NoSQL databases.
Read more »SQL Machine Learning in simple words
May 15, 2023This 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.
Read more »Introduction to the SQL Standard Deviation function
April 21, 2023How to do a group by clause
April 12, 2023Today, 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 »PostgreSQL Tutorial for beginners
April 6, 2023Introduction to the PostgreSQL tutorial
In this article, we will have a tutorial to learn PostgreSQL. According to Statista, PostgreSQL is the 4th 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.
Read more »MySQL group_concat() function overview
March 28, 2023This article will provide an understanding of how to effectively use group concatenation in MySQL.
Read more »Understanding Substring in Oracle SQL
March 22, 2023The 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 »PostgreSQL vs MySQL: Understanding their differences
March 13, 2023Today, 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 »Understanding the Scalability in Oracle Database
March 9, 2023When 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.
Read more »Learn SQL: Insert multiple rows commands
March 6, 2023This article explains the different approaches used to insert multiple rows into SQL Server tables.
Read more »MySQL Cluster in simple words
February 23, 2023This article provides an overview of MySQL Cluster in a simple understandable manner suitable for both database beginners and professionals.
Read more »SQL Cheat Sheet for Newbies
February 21, 2023In this SQL cheat sheet, we’ll look at sample SQL queries that can help you learn basic T-SQL queries as quickly as possible.
Read more »How to use the CROSSTAB function in PostgreSQL
February 17, 2023This article will explore the use of the CROSSTAB function in PostgreSQL.
Read more »PSQL stored procedures overview and examples
February 14, 2023In this article, we will learn how to create PostgreSQL stored procedures using PSQL.
Read more »Migrating Oracle Database to Azure SQL Database
February 9, 2023Data 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.
Read more »