Articles Cookbook
28 Sep 2023
Ignacio L. Bisso

How to Use ROW_NUMBER OVER() in SQL to Rank Data

Sometimes you need to know the position of rows in a result set. Learn how using ROW_NUMBER and OVER in SQL 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
28 Sep 2023
LearnSQL.com Team

New Monthly SQL Practice for October 2023!

In our October 2023 SQL Practice, you meet Sophie. She manages an online business for publishing and printing books and needs you to access and present various statistics to help her grow her business. Can you use your SQL skills to help? It should not be too hard if you have finished our SQL Basics courses or otherwise understand core SQL concepts. Our interactive SQL course is a great way to test your skills and see if you can put what you've learned so far into practice.
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 Buffa

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

SQL Practice: 11 SQL Window Functions Practice Exercises with Detailed 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
7 Sep 2023
Ignacio L. Bisso

COUNT OVER PARTITION BY: An Explanation with 3 Practical Examples

In SQL, combining the COUNT() function with the OVER() clause and PARTITION BY opens the door to a totally different way to count rows. In this article, you’ll learn how to do several COUNTs in a single query and calculate expressions based on the result of the COUNT function. In this article, we will cover how you can use the COUNT() function combined with the clauses OVER() and PARTITION BY.
Read more
5 Sep 2023
Tihomir Babic

SQL Joins: 12 Practice Questions with Detailed Answers

In this article, we dig into our SQL JOINS course and give you 12 join exercises to solve. But don’t worry – all the exercises have solutions and explanations. If you get stuck, help is there! This is, after all, made for practicing and learning.  SQL joins can be tricky. It’s not just the syntax, but also knowing what joins to use in what scenarios. Joins are used when combining data from two or more tables in SQL.
Read more