Articles Cookbook
10 Oct 2023
Martyna Sławińska

5 Easy SQL INNER JOIN Examples for Beginners

Looking for a clear explanation of joins in SQL? Check out these five INNER JOIN examples! In SQL, INNER JOINs can be difficult for beginners to master. But once you start working with them, you’ll learn they’re very useful! Let’s discuss five examples of SQL INNER JOINs. But first, let’s do a quick review of why JOINs matter. In relational databases, data is organized and stored within tables. Each table represents a specific type of information.
Read more
5 Oct 2023
Jill Thornhill

BigQuery Window Functions Explained

Keeping up with data analysis trends gives your organization – and your CV – the cutting edge. In this article, we'll look at BigQuery window functions and how you can use them to gain deeper insights into your data. Google's BigQuery, launched in 2010, is gaining traction as a popular choice with organizations needing to analyze large quantities of information quickly and to compare their own data against statistical data in the public domain.
Read more
3 Oct 2023
Maria Durkin

How SQL for Business Can Boost Profit and Effectiveness

Are you ready to unleash the power of SQL and transform your business? In this article, we'll look at all of the ways SQL can improve your company's performance, from decision-making capabilities to operational efficiency. Having the correct tools to traverse the sea of information is critical in today's data-driven corporate climate. Structured Query Language, or SQL, is an essential tool for this task—and it’s one that has endured the test of time.
Read more
28 Sep 2023
Ignacio L. Bisso

How to Use ROW_NUMBER OVER() in SQL

Sometimes you need to know the position of rows in a result set. Learn how using ROW_NUMBER and OVER can make it happen! Have you ever needed to add a sequential number to the records returned by an SQL query? Or perhaps you need to create a ‘top n’ report based on a specific ranking. In any of these cases, you need to calculate the position of the row in the ranking.
Read more
26 Sep 2023
Kamila Ostrowska

How SQL Can Help You Understand Your Clients Better

In this article, we will delve into how SQL can help businesses analyze customer data, uncover patterns, and make informed decisions to meet their clients' needs. Managing and understanding clients is crucial for any business, and this requires data. Client data, such as purchasing habits, preferences, and feedback, is typically stored in databases. To access and analyze this data, you need to be proficient in SQL, the language designed for managing and querying data in databases.
Read more
21 Sep 2023
Tihomir Babic

What Is FULL JOIN in SQL? An Explanation with 4 Examples

What is FULL JOIN – one of the often neglected SQL join types? In this article, we’ll show you how useful FULL JOIN  can be and teach you how to apply it to different scenarios. The four examples cover some of the typical uses. An SQL join is a construction for combining data from two or more tables. FULL JOIN is one of the types of joins. You’ll get the most from this article if you’re already familiar with SQL joins and how they work.
Read more
19 Sep 2023
Alexandre Bruffa

Python vs. SQL for Data Analysis

You surely have heard about SQL and Python. Maybe you’ve even worked with one of those languages. Both have strengths and weaknesses. When it comes to data analysis, which should you use? This article will demonstrate how Python and SQL are useful for data analysis and how knowing both languages can boost your data analysis journey. Decided to get into data analytics? Great! An increasing number of companies are looking for people who can analyze data and draw conclusions from it.
Read more
14 Sep 2023
Martyna Sławińska

11 SQL Window Functions Exercises with Solutions

In this article, we present 11 practice exercises involving SQL window functions, along with solutions and detailed explanations. SQL window functions are a powerful feature that lets us extract meaningful insights from our data easily, yet few SQL courses offer SQL window functions exercises. This makes practicing window functions quite difficult. In this article, we’ll give you 11 practice exercises that feature window functions. All exercises shown in this article come from our interactive courses Window Functions and Window Functions Practice Set.
Read more
12 Sep 2023
Maria Durkin

SQL for Project Managers: Enhancing Decision-Making

Did you know that SQL is a vital component in the project manager’s toolkit? In this article, we'll delve into how SQL for project managers enhances their workflow, promotes informed decision-making, and boosts operational efficiency. Data has become the foundation of decision-making across industries. In today's data-driven world, it's critical to arm yourself with the correct tools for dealing with the influx of data. One such tool that has stood the test of time is Structured Query Language, better known as SQL.
Read more
11 Sep 2023
Valentyn Kucherenko

An SQL Basics Primer for Non-IT Professionals

You don’t need to be an IT professional to understand SQL. Our quick primer of SQL basics is perfect for beginners without any computer science or programming background. If you’ve ever tried to learn a new software program, you know it takes more than just a few minutes. But it doesn’t mean you can’t learn it! The same is true if you want to learn SQL and databases. Even if you don’t have an IT background, you can do it.
Read more