Articles Cookbook
1 Apr 2020
Jakub Romanowski

Types of Database Jobs

Do you dream of high earnings and interesting work? Are you fed up with your boss and his or her annoying vacation stories in exotic countries? Is it time to change your job? Why not learn SQL? Here are some examples of the types of database jobs that may lead you to a better life. What types of database jobs use SQL? Here are some examples, but first, a small caveat.
Read more
31 Mar 2020
Rebecca McKeown

The 50 Best Resources for Learning SQL (Updated for 2024)

Do you want to know where to learn SQL? We’ve got you covered with the ultimate list of 50 SQL learning resources, including the best SQL courses, tutorials, books, and much, much more! Learning SQL can be hard enough without wading through thousands of websites and articles. So, we thought we’d do you a solid and put the top SQL resources here in this handy slice of the internet.
Read more
27 Mar 2020
Agnieszka Kozubek-Krycuń

Why Window Functions Are Not Allowed in WHERE Clauses

Window functions are extremely powerful, but there are a lot of nuances and little details you need to learn about using window functions in order to use them correctly and efficiently. A fairly common question SQL users have is why window functions are not allowed in WHERE. TL;DR: You can use window functions in SELECT and ORDER BY. You cannot use window functions in WHERE, GROUP BY, or HAVING.
Read more
25 Mar 2020
Kamil Bladoszewski

How to Rank Rows in SQL: A Complete Guide

Don’t struggle with SQL ranking functions anymore! This article will guide you through the most common ranking use cases. Rankings are used around us every day. Sports tournaments, the best movies and TV series on Netflix, stores with the cheapest products—these are only a few examples of rankings you might’ve seen recently. Using SQL RANK functions might be hard sometimes. The variety of different constructions is enormous. You can easily get lost in everything there is to learn about ranking.
Read more
24 Mar 2020
Emil Drkušić

How to Practice SQL JOINs

There is no better way to learn how to practice SQL joins than through hands-on experience. However, there will probably be obstacles along the way. I’ll cover some of these obstacles and give ideas for how to overcome them. While this article won’t turn you into SQL JOINs expert, it will show you how to become one. So, let’s start! Diving into the world of databases? Then you've likely come across SQL joins.
Read more
20 Mar 2020
LearnSQL.com Team

Stay at Home and Learn SQL for Free with LearnSQL.com

Working remotely is a dream come true for some. You ditch commuting and have more time for the people you love and the things you enjoy. For others, it's a challenge to maintain their focus when there are new distractions. It's also an opportunity to invest the few gained hours in learning something new. Staying at home can be a time when you might find yourself busier than you've ever been, but not getting many things done, and worse, not learning what you planned to.
Read more
19 Mar 2020
Kate Stolarek

Video Tutorial or Interactive SQL Course – Which Is Better?

Are you ready to get started with SQL but unsure which learning method is the most effective? In this post, we’ll talk about the pros and cons of learning SQL from an instructional video vs. an interactive online course. Are you a chronic Internet-using student who’s planning to learn SQL? Maybe you did some research but still don’t know which kind of training is worth your (limited) time. We all have families, hobbies, and other after-work commitments, and finding the right resource for learning SQL will save you some time.
Read more
18 Mar 2020
Tetyana Skorykh

How Will Learning SQL Improve My Daily Work?

Whether you're focused on advancing your career, mastering in-demand skills, or exploring something new and captivating, learning SQL is key to your progress. This vital skill makes professional life more manageable and also sets you up for success in a data-centric world. Are you thinking of learning SQL but aren’t sure if it's a good idea? If you’re not in a data- or IT-related job, learning SQL may seem completely useless.
Read more
17 Mar 2020
Pierre Timms

How to Start Writing SQL Reports

So, you’ve started, or want to start, learning SQL. You understand that a database is a repository for raw data and that data in business forms the backbone of the decision-making process. But how do you gain meaningful insights from raw data? How can you take a vast amount of information from a database and use SQL to give it a real-world utilization? Learn how to write SQL reports!
Read more
11 Mar 2020
Rebecca McKeown

Learning SQL? 14 Ways to Practice SQL Online

If you’re currently learning SQL, you may have found yourself knee-deep in reading material and wondering how on earth you can bridge the gap between book knowledge and real-life SQL application. In this article, we bring you 14 of the most effective ways to practice SQL online – taking you from a bookworm to a database butterfly in no time at all! “All theory and no practice will make you a frustrated SQL user!
Read more