This article is all about creating and querying Python PostgreSQL database in a simple and easy way.
Read more »
Languages and coding
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 »
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, 2023
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, 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 »
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 »
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 »
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 »
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 »
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 »
Use of the RESTORE FILELISTONLY command in SQL Server
December 21, 2022This article explores the RESTORE FILELISTONLY command in SQL Server with examples.
Introduction
Performing a database backup is an integral part of a DBA’s job. Backups are taken to ensure that data can be recovered in an emergency. There are different restore mechanisms, and the SQL Server DBA needs to understand them to make the right decision in each situation.
Read more »
Python serverless functions to query Azure SQL DB
December 19, 2022This article will show how to get data from Azure SQL in the Serverless Python app.
Read more »
The difference between WHERE and HAVING clause in SQL
December 16, 2022This article aims to explain the WHERE, GROUP By, and HAVING clauses in detail. Also, we will see the difference between WHERE and HAVING with examples.
Read more »
How to add or subtract dates in SQL Server
December 15, 2022This article explores SQL Server functions to add or subtract dates in SQL Server.
Read more »
Understanding the SQL SUM() function and its use cases
December 13, 2022Today, I will describe the SQL SUM () function along with its use cases in this article. There are various mathematical calculations we need to do in day-to-day business requirements. SQL Server offers various system functions which I have listed below to get these mathematical calculations easily by using them. One such requirement is to get the sum of values stored in a numeric column. We can use SQL Server system function SUM () to easily get the sum of the values stored in a numeric column of the table.
Read more »
Why do we need Correlated Subqueries in SQL
December 9, 2022This article speaks about correlated subquery and why we need it when querying a SQL database.
Additionally, we are going to understand the difference between simple subqueries and correlated subqueries with the help of some easily understandable examples.
Read more »