Articles Cookbook
13 Jan 2022
Karolina Niewiarowska

Top 10 Beginner Online SQL Courses in 2022

Ready for New Year’s changes? Good, because now you have a perfect chance to achieve something new: Improve your skills by learning SQL! In this article, we’ll point you toward some great online SQL courses to help you meet this goal. SQL, or Structured Query Language, is the language used to communicate with relational databases. When you know SQL, you can add, delete, change, and make calculations using the data in a database.
Read more
11 Jan 2022
Himanshu Kathuria

The Most Popular Databases for 2022

With the number of database products increasing with each passing year, it is important to understand which database best fits your use case. This article lists the top-ranking databases available in the market today. When something that first became popular in the early 1980s is not slowly fading away but is still evolving and becoming more relevant, you know it had to be an important invention. The database is no exception.
Read more
6 Jan 2022
Jakub Romanowski

The Best SQL Books for 2022

Many of our users keep asking what SQL books they should read to develop their skills. This is a great way to extend the knowledge you gained in online courses. Here are my picks for the SQL-related books you should read in 2022. It's January – a time of planning and New Year's resolutions. Put reading and learning SQL on your list. I've read many books on SQL. Some were great, while others were quite mediocre (to say the least).
Read more
4 Jan 2022
Jakub Romanowski

Free Course of the Month – PostgreSQL JOINs

Our PostgreSQL JOINs course will help you consolidate your knowledge of working with data from two or more tables in a PostgreSQL database. Throughout the month of January, this awesome SQL course is absolutely FREE! Wondering why we want to give you this SQL course for free? We've been doing this for a long time. Every month, we choose one of our interactive online SQL courses and give users free access to it.
Read more
1 Jan 2022
LearnSQL.com Team

New Monthly SQL Practice for January 2022!

Ready for our new SQL challenge? This time, we have prepared some slightly more difficult SQL tasks. Here’s January’s SQL Practice course! This time you will be helping Monica, the owner of an online store. She’d like to analyze her business data and earn more. It’s the perfect opportunity to use your SQL window functions skills. Can you find out how many customers she has in each country? Can you create reports to help her see sales trends?
Read more
30 Dec 2021
Tihomir Babic

How to Include Zero in a COUNT() Aggregate

Explaining how to include zero (0) counts in your SQL query result. Here’s the problem: you want to count something that doesn’t exist, and you want to show your result as zero. How do you do that in SQL? Using the COUNT() aggregate function is a reasonable first step. It will count all the data it finds and return the number of occurrences. But what if there are no occurrences of certain data?
Read more
28 Dec 2021
Karolina Niewiarowska

Here’s How I Started Creating SQL Reports

Once upon a time, there was a girl who was just starting her adventure with learning SQL. As a marketer, one of her tasks was writing reports. Previously, she used Excel, a calculator, and written notes to prepare the reports her boss required. One day, it turned out that she could do her job much faster and easier. That was the day she read about SQL reports for the first time.
Read more
23 Dec 2021
Ignacio L. Bisso

How to Use the SQL PARTITION BY With OVER

At the heart of every window function call is an OVER clause that defines how the windows of the records are built. Within the OVER clause, there may be an optional PARTITION BY subclause that defines the criteria for identifying which records to include in each window. Read on and take an important step in growing your SQL skills! What Is the PARTITION BY Clause in SQL? The SQL PARTITION BY expression is a subclause of the OVER clause, which is used in almost all invocations of window functions like AVG(), MAX(), and RANK().
Read more
16 Dec 2021
Kamil Bladoszewski

Is SQL Case-Sensitive?

Is SQL case-sensitive? The question seems simple, and you may think it’s a yes-no question. However, the answer depends on multiple factors. Let’s take a look at the possible answers. First of all, this question can be understood in multiple ways. Which part of SQL are you asking about? Do you mean keywords (e.g., SELECT, WHERE, etc.), table and column names, or values in the columns? Which database management system (DBMS) do you have in mind?
Read more
16 Dec 2021
LearnSQL.com Team

Christmas SQL Scholarship 2021

We know 2021 was very difficult for many of you. Now that it is slowly coming to an end, we’ve decided to end it with something positive. Here is the Christmas SQL Scholarship 2021! Let's enter the new year together with new energy and a chance for change! It was another year in which Coronavirus did not give up. The crisis has also affected the economy and our wallets.
Read more