#20. Marketing/Data Analysis for Beginners We already learned about the JOIN function in lesson 13 and 14. In this tutorial, we will expand on what we’ve learned and combine multiple tables together to filter and view useful information. #Glossary: 📌Lesson 3 [https://blog.sqlgate.com/sql-basic-what-kind-of-data-is-in-the-film-table-learning-sql-select-from-where-2/] : SELECT / FROM

#19. Marketing/Data Analysis for Beginners In the 12th lesson, we learned about 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. #Glossary: 📌Lesson 3 [https://blog.sqlgate.com/sql-basic-what-kind-of-data-is-in-the-film-table-learning-sql-select-from-where-2/] : SELECT / FROM / WHERE 📌Lesson

#18. Marketing/Data Analysis for Beginners 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/SUM) and we’re going to use them again in this

#17. Marketing/Data Analysis for Beginners 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 databases such as Oracle, SQL Server, and MySQL have different methods. We will cover

#16. Marketing/Data Analysis for Beginners Our SQL tutorials so far have covered how to look up data, navigate through it, and perform simple calculations. But in practice we want to to extract specific data from specific tables, not all the data in all the tables. The queries we have

#15. Marketing/Data Analysis for Beginners #Glossary: 📌Lesson 3 [https://blog.sqlgate.com/sql-basic-what-kind-of-data-is-in-the-film-table-learning-sql-select-from-where-2/] : SELECT / FROM / WHERE 📌Lesson 4 [https://blog.sqlgate.com/sql-basic-how-to-sort-film-lists-by-price-rental-rate-using-the-sql-query-order-by/] : ORDER BY 📌Lesson 5 [https://blog.sqlgate.com/sql-basic-can-i-rent-a-3-hour-movie-thats-only-0-99-using-sql-and-or-in/] : AND / OR / IN 📌Lesson 6 [https://blog.sqlgate.com/sq

#14. Marketing/Data Analysis for Beginners #Glossary: 📌Lesson 3 [https://blog.sqlgate.com/sql-basic-what-kind-of-data-is-in-the-film-table-learning-sql-select-from-where-2/] : SELECT / FROM / WHERE 📌Lesson 4 [https://blog.sqlgate.com/sql-basic-how-to-sort-film-lists-by-price-rental-rate-using-the-sql-query-order-by/] : ORDER BY 📌Lesson 5 [https://blog.sqlgate.com/sql-basic-can-i-rent-a-3-hour-movie-thats-only-0-99-using-sql-and-or-in/] : AND / OR / IN 📌Lesson 6 [https://blog.sqlgate.com/sq

#13. Marketing/Data Analysis for Beginners #Glossary: 📌Lesson 3 [https://blog.sqlgate.com/sql-basic-what-kind-of-data-is-in-the-film-table-learning-sql-select-from-where-2/] : SELECT / FROM / WHERE 📌Lesson 4 [https://blog.sqlgate.com/sql-basic-how-to-sort-film-lists-by-price-rental-rate-using-the-sql-query-order-by/] : ORDER BY 📌Lesson 5 [https://blog.sqlgate.com/sql-basic-can-i-rent-a-3-hour-movie-thats-only-0-99-using-sql-and-or-in/] : AND / OR / IN 📌Lesson 6 [https://blog.sqlgate.com/sq

#12. Marketing/Data Analysis for Beginners 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 out how to assign values to data that corresponds to a specific condition. #Glossary:

#11. Marketing/Data Analysis for Beginners 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 a column and how to organize it. ⭐️ We will start a more condensed, short

#10. Marketing/Data Analysis for Beginners This time we will look at other queries to manage the numeric data covered in the 9th tutorial [https://medium.com/sqlgate/sql-basic-what-is-the-total-length-of-all-the-films-added-together-sql-count-sum-3808cc6b48da] . We will use AVG/MIN/MAX to see the average, minimum, and maximum of values. Here’s a quick review if

#9. Marketing/Data Analysis for Beginners It’s time to learn how to manage numeric data. But first, here’s our glossary: Lesson 3 [https://blog.sqlgate.com/sql-basic-what-kind-of-data-is-in-the-film-table-learning-sql-select-from-where-2/] : 📌SELECT: you’re asking the database to show you something 📌FROM: you’re giving the database a location to search 📌WHERE:

#8. Marketing/Data Analysis for Beginners We’re halfway through the basic SQL tutorials now, so let’s take a break from learning SQL and take a closer look at our database tables. Even though we’ve dabbled in other tables, our main focus has been on the film table

#7. Marketing/Data Analysis for Beginners Today, we will cover AS, DISTINCT, IS NULL. They’re pretty simple and very commonly used, so let’s get started. Here is our handy Glossary: Lesson 3 [https://blog.sqlgate.com/sql-basic-what-kind-of-data-is-in-the-film-table-learning-sql-select-from-where-2/] : 📌SELECT: you’re asking the database to show you something 📌FROM:

#6. Marketing/Data Analysis for Beginners Let’s go over what we’ve learned so far. Lesson 3 [https://blog.sqlgate.com/sql-basic-what-kind-of-data-is-in-the-film-table-learning-sql-select-from-where-2/] : 📌SELECT: you’re asking the database to show you something 📌FROM: you’re giving the database a location to search 📌WHERE: you’re narrowing down/specifying the

#5. Marketing/Data Analysis for Beginners If you’ve been following our tutorials, you have a good grasp of some basic SQL queries. So first, let’s review! Lesson 3 [https://blog.sqlgate.com/sql-basic-what-kind-of-data-is-in-the-film-table-learning-sql-select-from-where-2/] : 📌SELECT: you’re asking the database to show you something 📌FROM: you’re giving the

#4. Marketing/Data Analysis for Beginners Now that we learned 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 results by using another query: ORDER BY. # Table of Contents > Query 1: How

#3. Marketing/Data Analysis for Beginners If you finished downloading SQLGate 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 SELECT, FROM, and WHERE. All the examples here are based on the ‘sakila’ sample

#2. Marketing/Data Analysis for Beginners If you already grasp the idea of database and SQL, then the only thing left here is to download SQLGate. You can’t access the database or export the data unless you download the necessary program. We have prepared a step-by-step tutorial with visuals