Articles Cookbook
5 Nov 2024
Valentyn Kucherenko

LearnSQL.com’s Top Free SQL Resources

In this article, you’ll get an overview of the top 10 free SQL resources from LearnSQL.com. I’ll start with the most basic and progress towards more advanced resources. Each one of those was carefully crafted to help you learn SQL.  Whether you are taking your first steps in your professional path or already have some experience with SQL, you’ll need plenty of SQL training tools if you want to get good at this language.
Read more
1 Nov 2024
Jakub Romanowski

Course of the Month: Customer Behavior in PostgreSQL

Ever wondered how top businesses understand their customers so well? The secret lies in data analysis, and we're offering you the key – for free – in our Customer Behavior Analysis in PostgreSQL course! Are you familiar with the basics of PostgreSQL and eager to delve deeper into customer behavior analysis? Our November 2024 Course of the Month, Customer Behavior Analysis in PostgreSQL, has you covered! And the best part?
Read more
31 Oct 2024
Jakub Romanowski

What Tools do I Need to Use SQL? A Guide For Beginners in Data Analysis

Welcome! In this guide, I’ll introduce you to the most essential SQL tools to help you start working with data quickly and efficiently. Whether you're new to SQL or looking to improve your skills, these tools will simplify your workflow and accelerate your progress. When I started learning SQL, I felt overwhelmed. So many databases, tools, and platforms were out there and I didn't know where to begin. But, after some time, I realized it’s not about knowing everything—it’s about understanding the right tools to help you along the way.
Read more
30 Oct 2024
LearnSQL.com Team

New Monthly SQL Practice for November 2024!

Ready for a new advanced SQL challenge? Help Nolan Roots, the owner of a landscaping business, by analyzing his sales data and compiling important reports about his clients. Get ready to dive into the world of SQL queries as you help Nolan improve his business. Welcome to the November SQL Practice course! In our November 2024 SQL Practice, you will help Nolan, the owner of a landscaping business. He has hired you, an SQL specialist, to gain important insights into his business.
Read more
29 Oct 2024
Ekre Ceannmor

SQL Project for Beginners: AdventureWorks Sales Dashboard

Building an SQL project on your own is a great way to sharpen your skills and gain practical experience. This SQL project example for beginners will show you how to create a sales dashboard with SQL and the AdventureWorks sample database. If you're an SQL beginner who wants to take their skills beyond simple query exercises, it’s a good idea to tackle an SQL data analysis project. Not only will it challenge you to apply what you've learned, it will also give you a deeper understanding of how SQL works in real-world scenarios.
Read more
24 Oct 2024
Agnieszka Kozubek-Krycuń

NULLs and Handling Missing Data in SQL

Handling missing data (i.e. NULLs) in SQL can be challenging. NULLs can pose a lot of traps, especially if you don’t understand how they work. In this article, we’ll talk about dealing with NULL in SQL. We’ll also explain how to avoid common mistakes when working with NULLs. Having missing data in your database is an unavoidable reality of life. There are many reasons why you may have missing data in your database: the complete data isn’t yet available, users provide incomplete information, changes to the database schema, database malfunctions, human error, and more.
Read more
22 Oct 2024
Gustavo du Mortier

How SQL Helps Optimize Healthcare Workflows

SQL is a universal language for healthcare data management and workflow optimization. In this article, we will see how to use SQL for everything from scheduling medical appointments to monitoring vital signs. Healthcare professionals must adhere to various processes to perform their duties. These processes, or workflows, are adapted to various situations – patient reception, diagnosis, monitoring, billing, clinical documentation, etc. While these workflows vary by type of care, setting (hospital, clinic, telemedicine), and the role of the practitioner, they all require the efficient and accurate handling of large volumes of critical information.
Read more
17 Oct 2024
Tihomir Babic

The ORDER BY Clause in SQL Window Functions

In this article, you’ll get an overview of ORDER BY in window functions. You’ll learn how it compares to PARTITION BY and the regular ORDER BY all accompanied by examples and explanations. If you want to create reports that go beyond simple aggregations, you’ll need SQL window functions. Window functions help you create rankings, compute running totals and moving averages, and find the difference between rows. To use window functions effectively, you must understand the role of the ORDER BY clause.
Read more
15 Oct 2024
Ekre Ceannmor

19 Aggregate Function Exercises

Solve these 19 SQL aggregate function exercises and sharpen your SQL skills! Practice using aggregate functions with GROUP BY, HAVING, subqueries, and more. Includes a solution and detailed explanation for each exercise. Aggregate functions are an important part of SQL. They allow you to calculate different statistics and generate reports that you would not have been able to with single-row operations like filtering. It’s important to practice aggregate functions often, as they are a crucial part of your SQL skill set.
Read more
10 Oct 2024
Radu Gheorghiu

Building Analytical Data Pipelines with SQL

If you’re trying to build an analytical data pipeline, then SQL is the perfect tool for the job. It will help your organization build a data analytics foundation that turns data into business value. Why should you care about building data pipelines with SQL? This might sound like a technical challenge, but a strong data pipeline is one of the most essential tools for turning raw data into actionable insights.
Read more