Articles Cookbook
12 Nov 2024
Jakub Romanowski

Your New Personalized SQL Learning Plan

SQL may not be as flashy as some other programming languages, but it's an absolutely essential skill if you're working with data. Whether you're aiming for a career in data analysis, managing databases, or even just looking to boost your current role, SQL is the tool that will make you more efficient. The best part? You don’t need a degree in computer science to learn it. Think of SQL as the key that opens doors to data.
Read more
7 Nov 2024
Maria Durkin

SQL Pivot Tables: A Step-by-Step Tutorial

Are you a data analyst looking to better your abilities? Or perhaps you want to discover what tools you need to succeed in this role? Today, we're going to look at one of the most important tools for data analysts: the SQL pivot table. An SQL pivot table is an essential tool for quickly arranging and summarizing data. In just a few lines of code, it helps analysts rapidly and effectively identify patterns and trends in data.
Read more
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