This 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 »
A quick overview of MySQL foreign key with examples
February 7, 2023In this article, we will learn how to work with MySQL foreign keys with a few examples.
Read more »
Common use cases of SQL SELECT Distinct
February 2, 2023This article talks about the commonly used scenarios of SQL Select Distinct in an easily understandable format equally suitable for beginners and professionals.
Read more »
Top Power BI Interview Questions and Answers
January 31, 2023Microsoft Power BI is a very popular data visualization tool. In this article, we will discuss the most frequently asked Power BI Interview Questions and Answers.
Read more »
SQL Practice: Common Questions and Answers for the final round interviews
January 26, 2023In 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.
Read more »
Introduction to SQL Escape
January 24, 2023This article will provide an introduction to SQL escape characters for using special characters and their characteristics.
Read more »
Learn the PostgreSQL COALESCE command
January 19, 2023This article will make you learn the Postgres Coalesce command with examples.
Read more »
Learn SQL standard deviation function
January 17, 2023This article will show the SQL standard deviation function with several examples.
Read more »
Getting started with SQL LIMIT clause
January 13, 2023Today, I am going to explain how to use the SQL LIMIT clause to limit output values. We all know RDBMS systems are one of the popular ways to store, protect, access, and analyze data in a structured way. We can store enormous sizes of data and then further can access them with the help of SQL language to get our desired output to analyze it. SQL stands for Structured Query Language which is used to perform activities like creating, modifying, and accessing data from the databases hosted on RDBMS systems like SQL Server or MySQL, etc. This article will explain one of the SQL query statements LIMIT which we use to limit the number of records returned in the output result.
Read more »
How to create Power BI reports
January 11, 2023In this article, we will learn how to create Power BI Reports. This article is created for newbies to start the Power BI world with a simple example. We will connect to SQL Server, show how to transform data from SQL Server in Power BI, and then we will create some reports, and play with the options available in Power BI.
Read more »
Common SQL Interview Questions and Answers
January 6, 2023If you are working on SQL programming or learning SQL or how to write queries and looking to test your knowledge or prepare for any SQL interview, the below article can help you.
Read more »
Overview of the SQL Median function
January 4, 2023In this article, we will learn how to implement the median functionality and wrap it into a SQL median function
Read more »
SQL Subtract Dates with Examples
January 2, 2023SQL Server provides various dates and time functions for different needs. In this article, we will focus on SQL subtract date functions with various examples.
Read more »
5 Best Practices for writing SQL queries
December 30, 2022In this article, we are going to learn some best practices that help to write more efficient SQL queries.
Introduction
Queries are used to communicate with the databases and perform the database operations. Such as, we use the queries to update data on a database or retrieve data from the database. Because of these functions of queries, they are used extensively by people who also interact with databases. In addition to performing accurate database operations, a query also needs to be performance, fast and readable. At least knowing some practices when we write a query will help fulfill these criteria and improve the writing of more efficient queries.
Read more »
An overview of the SQL GROUP BY clause
December 28, 2022This article briefly explains the SQL group by clause, when it should be used, and what we should consider when using it.
Read more »
Understanding the difference between SQL and MySQL
December 26, 2022This article will explain the difference between SQL and MySQL. Many people get confused between several database terms like SQL, MySQL, SQL Server, or other SQL-related phrases. If you are a database professional, then you should be aware of the difference between SQL and MySQL or other phrases which have SQL words included like PostgreSQL, Cloud SQL, TSQL, etc. Most of these terms are divided between a query language and database software like TSQL and SQL are query languages whereas MySQL, SQL Server, and PostgreSQL are database software.
Read more »