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.
Search Results for: INSERT
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.
Introduction to SQL Escape
January 24, 2023This article will provide an introduction to SQL escape characters for using special characters and their characteristics.
Learn the PostgreSQL COALESCE command
January 19, 2023This article will make you learn the Postgres Coalesce command with examples.
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 […]
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.
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 […]
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, […]
SQL Server Tutorial
December 23, 2022This article is a SQL Server Tutorial. If you want to learn how to install and start with SQL Server from 0, this is the place to start. We will teach you to install SQL Server, start your first queries, and explain the basics to start with SQL Server Integration Services (SSIS), SQL Server Reporting […]
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 […]
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.
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.
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 […]
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.
PostgreSQL Join overview with examples
December 2, 2022In this article, we will learn about different types of PostgreSQL joins with examples.
SQL Boolean Tutorial
November 28, 2022The SQL Boolean data type is not included in SQL Server. Other databases like Oracle and MySQL include the Boolean data type that accepts the values of TRUE, and FALSE.
INT vs BIGINT in SQL Server with Examples
November 22, 2022SQL Server provides int, bigint, smallint and tinyint data for storing exact-number data. In this article, we will focus on int and bigint data types.
Using parameterized queries to avoid SQL injection
November 18, 2022In this article, we will explain what the SQL injection attack is, why it could be hazardous, and how to defend our SQL database from this attack using parameterized queries and some third-party tools.
ODBC drivers for Azure SQL
November 9, 2022Introduction In previous articles, we saw how to connect with ODBC to SQL Server using the ODBC Data Source Administrator in Windows. This time, we will connect to Azure and export the data from one table in Azure to SQL Server on-premises using SSIS.
SQL Subtract dates
November 7, 2022In this article, we will show how to subtract dates using SQL Server. This article will be a learn-by-example article with a problem and a solution. But first, I will add some theory to understand the syntax of the DATEDIFF function which is the base of this article.
Getting started with procedures in Azure Database for PostgreSQL
October 26, 2022In this article, we will learn how to work with procedures in Azure Database for PostgreSQL.
Changing the location of FILESTREAM data files in SQL Database
October 14, 2022This article explains different ways to change the location of the FILESTREAM data files. The FILESTREAM feature was introduced in SQL Server 2008 version. We can efficiently store the BLOBs in the SQL database using FILESTERAM.
Reporting data from Azure Database for PostgreSQL using Power BI
October 12, 2022In this article, we will learn how to use Power BI to source data from an instance of Azure Database for PostgreSQL, transform this data and load it into Power BI for reporting.
SQL Commands to check current Date and Time (Timestamp) in SQL Server
October 7, 2022This article explores different SQL Commands (functions) to return the current Date and Time (Timestamp) in SQL Server.
Querying data from Azure Database for PostgreSQL using psql
October 3, 2022In this article, we will learn how to query the data as well as database objects hosted in an instance of Azure Database for PostgreSQL using psql and export the results of the query to a file.
