Articles Cookbook
14 Sep 2021
Andrew Bone

How to Use Aliases with SQL JOINs

SQL aliases are custom names that you can give to the columns and tables you include in your queries. Aliases are very useful, as they can greatly improve the readability and maintainability of your query. We’ll be taking a closer look at using SQL aliases with JOIN and why you might need to do so. The best way to master aliases in SQL is practice. I recommend our interactive SQL Practice Set course.
Read more
13 Sep 2021
LearnSQL.com Team

We Have Changed For You!

It's even better than before! LearnSQL.com doesn't just have a new awesome look. We've also been working very hard on the "behind the scenes" stuff, and have changed many functions on our platform to ensure that you have the best possible learning experience. The first glance at the new LearnSQL.com platform shows immediately that a lot has changed. It was very good before, but now it's awesome! We are very proud of our new look and hope that it will make learning SQL even more fun and effective.
Read more
10 Sep 2021
Tihomir Babic

Frequently Asked Questions About SQL

Ten SQL questions that you should be able to answer if you’re applying for an SQL job. SQL is a vast topic and a source of endless questions from its users. However, some questions are asked more frequently – usually about concepts that most SQL users will need to know. It’s not surprising that interviewers tend to ask these same questions to SQL job candidates. Either way, knowing these questions is a first step to learning SQL.
Read more
9 Sep 2021
Jakub Romanowski

Top 5 SQL Audiobooks

No time to learn SQL? What if I said you could learn while sitting in traffic or washing dishes? It’s possible thanks to SQL Audiobooks. Check out which ones you should listen to. I have been recommending various SQL books for a long time. If selected well, they can be a great complement to the knowledge gained in interactive online courses. If you haven't read my article yet, check it out.
Read more
8 Sep 2021
Karolina Niewiarowska

How to Show Your SQL Experience

Do you want to work in the IT industry? This is now one of the best ideas for a good career. What should convince you to do so? Demand for specialists, high earnings, and the fact that it is a future-proof profession. Interestingly, it's not gonna be that hard – especially for you, smartie! You just need some skills and good preparation for an interview to be successful. I'll tell you how to land a great job!
Read more
3 Sep 2021
András Novoszáth

Why You Should Use SQL in Marketing Analytics

Have you been wondering how you could use SQL in your marketing data analysis work? Would you like to create SQL reports to guide your marketing decisions? In this article, you will learn how to use SQL for marketing through plenty of use cases. Are you a marketing professional wanting to better understand the results of your marketing efforts? Do you want better means to prove your point and demonstrate the value you create?
Read more
2 Sep 2021
Karolina Niewiarowska

How Hard Is It to Learn SQL Without IT Experience?

Learning SQL doesn't have to be difficult! Taking an interactive SQL course is a great way to start your career in the high-paying world of IT. When you started your adventure with computers, you surely didn't realize how far you could go. You were probably only a few years old, and your first experience with a computer was probably gaming. Today, computers provide more than just quick access to entertainment; they’re a great tool for earning money.
Read more
1 Sep 2021
Jakub Romanowski

Course of the Month: Revenue Analysis in SQL Server

It is impossible to run a business without a good analysis of revenue trends. But how do you do it effectively? You can rely on good old Excel, but a much better idea is to use SQL and databases. Learn how to create SQL reports and track the growth of your business with MS SQL Server. Here is the course, Revenue Trend Analysis in SQL Server. It’s FREE throughout September!
Read more
31 Aug 2021
Dorota Wdzięczna

SQL MIN and MAX Functions Explained in 6 Examples

What are the SQL MIN() and MAX() functions? When should you use them as aggregate functions, and when should you use them with window functions? We explain using practical examples. SQL includes several aggregate functions. These aggregate functions compute calculations on numerical data. This article focuses on only two of these functions: MIN() and MAX(). I will explain what each function does and discuss several use cases. If you want to practice SQL aggregate functions, I recommend our interactive SQL Practice Set course.
Read more
26 Aug 2021
Tihomir Babic

3 Real-Life Examples for SQL Common Table Expressions

We answer three SQL business questions using CTEs. There are business problems that are often solved in a very roundabout way. While they might get you the correct result, there’s usually a more elegant way to write a solution. Enter the CTEs! They are extremely helpful when it comes to getting a more direct and elegant solution. I’ll show you three business situations where CTEs can be very helpful. You’ll get an idea of when CTEs can be useful.
Read more