Articles Cookbook
2 May 2023
Nicole Darnley

Top 7 Advanced SQL Queries for Data Analysis

Explore essential advanced SQL queries for data analysis. Structured Query Language, or SQL, is an indispensable tool for data analysts. Most people pick up the language relatively quickly and can begin in-depth data analysis after just a few lessons. Because of this, many data analysts tend to stay in the beginner/intermediate level of using SQL. This level of understanding allows you to “get the job done”, but it might not be the most efficient way to write a query.
Read more
28 Apr 2023
Jakub Romanowski

MySQL Crash Course - An Interview With Rick Silva

If you've read my articles before, you probably already know that I love reading. What's more, I also collect SQL books. It may sound weird, but I enjoy comparing different approaches and ways of writing about databases. The best ones end up in our recommended books lists, like The Best SQL Books. One of those books, MySQL Crash Course, has just been released. I was able to talk to its author, Rick Silva, and this is what he told me.
Read more
27 Apr 2023
Tihomir Babic

How to Use the SQL RANK OVER (PARTITION BY)

Ranking data in SQL is a breeze if you know how to use RANK() to rank over a partition. This article shows you how to do it, as well as how RANK() differs from DENSE_RANK() and ROW_NUMBER(). If you work with SQL in a professional setting, you have had to rank data at least once. Think of ranking months/years/quarters by revenue or costs, best-selling products, most viewed posts or streamed songs, employees by salary, most profitable branches, you name it.
Read more
25 Apr 2023
Alexandre Bruffa

Learn SQL in 10 Minutes

Want to learn SQL fast? Our simple guide will teach you the essentials in just 10 minutes! Start querying data in no time. In today’s world, we use data for everything, and knowing SQL helps you understand this data better. Learning SQL means you can find and use important information in databases. Knowing SQL is an essential skill in any data-driven industry. For beginners, learning SQL is made easy with the right guide.
Read more
20 Apr 2023
Jill Thornhill

CTE vs. Subquery in SQL: What’s the Difference?

What are Common Table Expressions (CTEs)? Are they the same as subqueries? When would you need to use CTEs? This article looks at the similarities and differences between CTE vs subquery. When I introduce a student to Common Table Expressions, their first reaction is “That’s just a subquery! Why do I need to learn that?”. Let’s answer this question by looking at what you can do with an SQL subquery and what extra advantages there are in using a CTE.
Read more
18 Apr 2023
Tihomir Babic

10 Beginner SQL Practice Exercises With Solutions

Solve these ten SQL practice problems and test where you stand with your SQL knowledge! Practice is the best way to learn SQL. In this article we show you ten SQL practice exercises for beginners, where you can test your basic SQL knowledge. Use them as a practice or a way to learn new SQL concepts. For more theoretical background and (even more!) exercises, there’s our interactive SQL Basics course.
Read more
13 Apr 2023
Crystal Frazier

How I Used SQL to Advance in My Career

SQL has become increasingly valuable in today’s job market.  In this article, I will share my personal experience with SQL. I hope it will inspire you to grow in your career and achieve your own goals! A few years ago, I felt stuck in a job that I didn’t fully enjoy. Sure, there were aspects of my job that I appreciated, like building budgets, analyzing the performance of promotional programs, and watching my team grow professionally.
Read more
11 Apr 2023
Nicole Darnley

The Best SQL Blogs to Follow

In this article, you’ll find a list of the best SQL blogs and why they’re worth checking out. SQL (short for Structured Query Language) has been around since the 1970s. It’s still a wildly popular coding language. It is based on the idea that data can be structured and built through relations. If you’re familiar with SQL, you’ve likely heard the term “relational database.” This means that the tables of the database have pre-defined relationships between them: One field in one table will match another field in another table.
Read more
6 Apr 2023
Maria Durkin

Best PostgreSQL Courses for Beginners

So you want to learn PostgreSQL but aren't sure how to get started? In this article, we look at some of the best online courses available on the Internet for learning PostgreSQL, so you can get started right away! What Is PostgreSQL? PostgreSQL is used in major companies such as Apple and Instagram. You may be wondering: should I learn PostgreSQL? PostgreSQL is a popular dialect of SQL, or Structured Query Language, a programming language for accessing and managing data in relational databases.
Read more
4 Apr 2023
Maria Durkin

How to Learn SQL in a Week

Need to learn SQL in a hurry? In this article, we’ll give you a learning path that will help you learn SQL in a week! So you want to learn SQL but don't know where to begin, how long it will take, or even if you have the time. In this article, we'll show you how you can learn SQL within a week using some resources that will get your SQL journey started in no time!
Read more