SQL Tutorial

In this tutorial, we will expand on what we’ve learned about JOIN and combine multiple tables with filtering and viewing useful information. #Table of ContentsQuery 1. Check the overdue

We covered the primary use of CASE. In this post, we will discuss advanced queries that use CASE to calculate based on values that meet specific criteria. #Table of ContentsQuery

Now that we've learned a few things about strings let's try some numeric functions. There are many kinds of numeric functions we've already covered in previous lessons (AVG/MIN/MAX/

In this tutorial, we will learn about the functions you can use to manipulate string data easily. There are many functions for strings, and sometimes different databases such as Oracle,

Our SQL tutorials have covered how to look up data, navigate it, and perform simple calculations. But in practice, we want to extract specific data from specific tables, not all

Finally! We’ve covered most of the basics! This tutorial will use everything we learned so far to write some subqueries. #Table of ContentsQuery 1. SUBQUERY with whereSELECT customer_id,

In the previous tutorial, we learned how to combine tables with  INNER JOIN . Today we’re going to cover the RIGHT JOIN and LEFT JOIN queries. 🆕 🌟 📌OUTER LEFT JOIN: combine

We’ve learned many things so far and covered most of the basics of SQL. But until now, we’ve only been working on one table at a time. During

Last time we used GROUP BY and HAVING to learn how to group and condition data in a particular column. Now let’s use a query called CASE to figure

In the last couple of tutorials, we’ve been dealing with SQL queries that handle numeric data. Now we’re going to learn how to group that data in a

This time we will look at some queries that help manage the numeric data covered in the last tutorial. We will use AVG/MIN/MAX to see the average, minimum,

It’s time to learn how to manage numeric data. Let’s learn how to use COUNT and SUM. 🆕 🌟 📌COUNT: find the number of rows that match specified criteria 📌SUM:

Today, we will cover AS, DISTINCT, IS NULL. They’re pretty simple and very commonly used, so let’s get started. 📌AS: used to rename columns 📌DISTINCT: used to see

The next query on our list is LIKE. This is used for finding patterns when we don’t know the exact data. # Table of ContentsQuery 1: Using LIKESELECT title, description

If you’ve been following our tutorials, you have a good grasp of some basic SQL queries. This time, we’re going to cover three new queries. AND, OR, and

Now that we know how to use SELECT, FROM, and WHERE in SQL, we can delve deeper into marketing and data analysis. Next, we will sort the results by using

If you finished downloading QueryPie and connecting to the database already, it’s time to manage and find data. Let’s go over what we can do with the query