SQL Tutorial 17. Learn Advanced JOIN queries! 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
SQL Tutorial 16. Learn Advanced CASE queries! 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
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 (AVG/MIN/MAX/
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. There are many functions for strings, and sometimes different databases such as Oracle,
SQL Tutorial 13. Learn SQL DATE_FORMAT, DATEDIFF 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
SQL Tutorial 12. Learn SQL Subquery 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,
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 that data in a
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 three 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 marketing and data analysis. Next, we will sort the results by using
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