Articles Cookbook
21 Apr 2022
Himanshu Kathuria

The SQL Syntax Is Simple: True or False?

Are you contemplating learning SQL but are concerned about how difficult it may be, especially if you have no prior coding experience? If so, you are not alone. In this article, I show you how simple SQL is and that it is worth your time learning it. You just need to know how to approach it properly. Many people carry the notion that learning SQL is much like learning other programming languages.
Read more
19 Apr 2022
Dmitri Vaitkun

What Are the Different SQL JOIN Types?

You just can’t understate the importance of the JOIN when learning SQL. Not only is it one of the most fundamental operations in relational databases, but it is also very versatile with many different types. Although SQL JOIN may be intimidating at first, it becomes a very handy instrument in your arsenal once you understand it. Let’s explore all the SQL JOIN types! We can safely say the JOIN operation is one of the most powerful features of SQL.
Read more
14 Apr 2022
Tihomir Babic

The SQL OVER() Clause - When and Why to Use It

The OVER() clause, or how to reach a whole new level of data analysis. Why all the commotion around the SQL OVER() clause? I’ll tell you why: the OVER() clause introduces window functions. And what are window functions in SQL, you might ask? They are functions that operate on a window, i.e. a set of rows related to the current row. In that way, they are similar to the GROUP BY clause and to aggregate functions.
Read more
12 Apr 2022
Jakub Romanowski

SQL Track of the Season: SQL from A to Z in MySQL

Do you feel the spring already? Everything is in full bloom at this time of the year. Why shouldn’t it be the same with your career? You just need to water it with a new skill. Here is the brilliant SQL from A to Z in MySQL track, our Track of the Season. In this article, I answer common questions about this awesome set of online MySQL courses. Why should you care about relational databases at all?
Read more
7 Apr 2022
Jakub Romanowski

Join the LearnSQL.com Affiliate Program!

Are you a creator, blogger, or YouTuber? Do you have an audience, do you appreciate our interactive SQL courses, and would you like to help promote them? By the way, you can earn some money! Here is our SQL Affiliate Program. We create our SQL courses with a passion and a love for databases. Looking at the reactions and the reviews of our users, we do quite well. If this is your first visit to LearnSQL.
Read more
5 Apr 2022
Jakub Romanowski

Free Course of the Month – GROUP BY Extensions in PostgreSQL

Do you work with data? Want to be able to create better and more sophisticated SQL reports? Then check out our interactive GROUP BY Extensions in PostgreSQL course. In April 2022, you can complete this online PostgreSQL course for FREE! How can you get this free SQL course in April? Create a free com account or log in if you already have one. Start the course. You will have free access to its content until the end of the month.
Read more
1 Apr 2022
LearnSQL.com Team

New Monthly SQL Practice for April 2022!

Are you a SQL beginner that needs some interactive exercises to practice writing queries? Take up the challenge and choose our April SQL Practice course! In our April 2022 SQL Practice, you’ll meet Olivia, the owner of a hairdressing salon. She needs you to help her gather statistics on the services offered by her salon, the salon customers, their appointments, etc. Can you use your SQL skills to help her find the data?
Read more
31 Mar 2022
Ignacio L. Bisso

How to Use the ROUND() Function in SQL

Need to round numeric results in SQL? The ROUND() function is here to do the job. Modern relational databases offer many built-in functions that extend the capabilities of SQL. In this article, we will use practical examples to explain how the ROUND() function works. (Spoiler alert: If you guessed that it rounds a number to a certain decimal place, you’re right! Read on to find out more.) SQL Standard Functions Each SQL database (PostgreSQL, MySQL, Oracle, SQL Server among others) has a set of built-in functions.
Read more
29 Mar 2022
Pierre Timms

Are You a Student? Choose LearnSQL.com

If the answer to this question is yes, then let’s talk about how learning SQL as part of your educational journey benefits you down the road. We’ll focus on the importance of SQL for students – whether you are preparing for an exam, are thinking about a career in IT, or need new skills for a research project. Later, we will explain why LearnSQL.com is the way to go, whatever your learning goals are.
Read more
24 Mar 2022
Tihomir Babic

How to Write Multiple CTEs in SQL

Leverage the full potential of the CTE by combining two or more of them in a single SQL query. Common table expressions, or CTEs, can be a powerful SQL tool. When you write two (or even more) CTEs together, this power multiplies. In this article, I’ll show you three ways of writing multiple CTEs: Using two independent CTEs in one SQL query. Using two CTEs where the second CTE refers to the first.
Read more