Create free account
User profile menu open
Open user profile menu
Payment & Billing
Payment & Billing
Create free account
21 Apr 2022
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.
19 Apr 2022
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.
14 Apr 2022
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.
12 Apr 2022
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?
7 Apr 2022
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.
5 Apr 2022
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.
1 Apr 2022
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?
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.
29 Mar 2022
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.
24 Mar 2022
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.