SQL Tutorial 17. Learn Advanced JOIN queries! In this tutorial, we will expand on what we’ve learned about JOIN and combine multiple tables together to filter and view useful information. #Table of ContentsQuery 1. Check the

SQL Tutorial 16. Learn Advanced CASE queries! We learned covered the basic use of CASE. In this post, we will discuss advanced queries that use CASE to calculate based on values that meet certain criteria. #Table of

SQL Tutorial 15. Learn SQL Numeric functions — TRUNCATE, ROUND, MOD 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

SQL Tutorial 14. Learn SQL String Functions — MySQL CONCAT, LENGTH, SUBSTR In this tutorial, we will learn about the functions you can use to manipulate string data easily and quickly. There are many kinds of functions for strings, and sometimes different

SQL Tutorial 13. Learn SQL DATE_FORMAT, DATEDIFF Our SQL tutorials so far have covered how to look up data, navigate it, and perform simple calculations. But in practice we want to to extract specific data from specific

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

SQL Tutorial 11. Learn SQL LEFT / RIGHT JOIN 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

SQL Tutorial 10. Learn SQL INNER JOIN 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

SQL Tutorial 9. Learn SQL CASE 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

SQL Tutorial 8. Learn SQL GROUP BY/HAVING 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 together that data in

SQL Tutorial 7. Learn SQL AVG/MIN/MAX 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,

SQL Tutorial 6. Learn SQL COUNT/SUM 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:

SQL Tutorial 5. Learn SQL AS/DISTINCT/IS NULL 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

SQL Tutorial 4. Learn SQL LIKE 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

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

SQL Tutorial 2. Learn SQL ORDER BY Now that we know how to use SELECT, FROM, and WHERE in SQL, we can delve deeper into the world of marketing and data analysis. Next, we will sort the

SQL Tutorial 1. Learn SQL SELECT/FROM/WHERE 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