SQL Cheat Sheet: What is SQL, SQL Commands, and SQL Injection

11:04 Database development, Statements

Using Structured Query Language (SQL) can seem complicated at first, but further, it will become...
Read More

SQL JOINs Tutorial with Examples

10:18 Database development, Statements

In this article, we are going to takes a close look at SQL Server JOINs. We will review all supported SQL Server JOIN types with syntax,...
Read More

Drop Temp Table in SQL Server and PostgreSQL

12:01 Database development, Statements, Tables

This article explains different ways to drop the temp table in SQL Server and PostgreSQL. As the name suggests, temporary tables are used...
Read More

How to Use SQL Server T-SQL Function SUM: 5 Use Cases

09:43 Database development, Statements

The T-SQL SUM function is one of the fundamental functions. Its purpose is to calculate the sum of...
Read More

Is SQL DISTINCT Good for Removing Duplicates in Results?

05:57 Database development, Statements

Is SQL DISTINCT good (or bad) when you need to remove duplicates in results? Some say it’s good and add DISTINCT when...
Read More

SQL OR Statement: The Basics

10:23 Database development, Statements

Now and then, you need to create a complex SQL query using multiple statements together. While these query types can be tedious to create,...
Read More

How to Use SQL SUM Function

10:01 Database development, Statements

SQL is a powerful and widely-used programming language for data storage, retrieval, and...
Read More

How to Use REPLACE in SQL

10:12 Database development, Statements

When querying data with SQL, the need to manipulate string-based results is very common. There are many options across the major relational...
Read More

SQL BETWEEN-Smart Tips to Scan for a Range of Values

10:50 Database development, Statements

SQL BETWEEN is an operator used to specify a range of values to test. The returned value can be inclusive or within the range. Or it can be...
Read More

SQL ORDER BY: The 5 Do’s and Don’ts to Sort Data Like a Pro

10:24 Database development, Statements

Ugly. That’s what unsorted data looks like. We make data easy for the eyes by sorting them. And...
Read More