Articles Cookbook
22 Mar 2022
Tihomir Babic

The SQL Substring Function in 5 Examples

Working with text data in SQL? We explain how to get values from any point in a string. When you think of working with data in SQL, your first thought is probably a database full of numbers and your SQL code doing very fancy calculations. But text is data, too! It’s very common to find text data in databases. Not only do you have to extract it, but often you also have to manipulate it.
Read more
17 Mar 2022
Kateryna Koidan

Are You Ready to Become a Data Analyst?

Data analysts enjoy strong career prospects. Do you have the skills required for this role? Let’s find out! If you enjoy working with data, searching for interesting patterns and valuable insights, you may wonder “Should I become a data analyst?” In this article, I’ll explain what data analysts do and what skills a successful data analyst needs. What Does a Data Analyst Do? Data-driven organizations rely on specialists who know how to get value out of data.
Read more
15 Mar 2022
András Novoszáth

SQL and Cloud Databases Are the Perfect Match!

Do you want to do analytics in the cloud? Are you considering learning SQL and wondering whether you can use it with cloud-based databases? Do you want to know how cloud databases and SQL work together? We answer your questions in this article. Read on! You may be an analyst who has heard about cloud databases and SQL and want to learn more. Maybe you are already familiar with them and want to know if the two technologies fit together.
Read more
10 Mar 2022
Marcin Koryszewski

Five of the Top Websites You Should Know When Learning SQL in 2022

If you are learning SQL in 2022 and are looking for some resources to help your learning, you've come to the right place. Here are 5 of the top websites you should know when learning SQL. Today, I'm going to share a list of websites that help you with learning SQL. You will find useful resources, interact with a fantastic community, and expand your database knowledge. Or you may need some help while working on SQL queries.
Read more
8 Mar 2022
Himanshu Kathuria

What Is the OUTER JOIN in SQL?

Even if you are new to SQL, you must have come across the term OUTER JOIN. In this article, I will explain what OUTER JOIN in SQL does. I’ll use some practical examples to demonstrate how it is used in day-to-day SQL applications. If you want to use SQL for practical purposes, learning the different JOINs is extremely important. In fact, you will be using a JOIN in just about every second query you write.
Read more
3 Mar 2022
Karolina Niewiarowska

Is Your Learning SQL Plan Stuck in Neutral?

Are you stuck on some tricky point of learning SQL and don't know how to move on? This article will help you move on in your SQL journey. Have you been learning SQL, only to get discouraged by some difficult concept? Everybody gets stuck when they try to learn something new. Most of us have probably given up trying to learn that thing, only to come back to it later.
Read more
1 Mar 2022
Jakub Romanowski

Free SQL Course of the Month – Creating Basic SQL Reports in PostgreSQL

If you are looking for a course that takes your PostgreSQL skills to a completely different level, you've come to the right place. You can learn for free in March! We chose SQL Reporting in PostgreSQL for our Free SQL Course of the Month. It's just awesome – I'll tell you why. Do you want to be even better at SQL? Do you know the basics and want your SQL reports to be even more sophisticated?
Read more
1 Mar 2022
LearnSQL.com Team

New Monthly SQL Practice for March 2022!

If you are a more advanced SQL user who is comfortable using CASE WHEN, GROUP BY, aggregate functions, and common table expressions (CTEs), you can check your knowledge with the March SQL Practice. On LearnSQL.com, you‘ll find a new challenge to solve every month. Maybe this is the first time you’ve come across our Monthly SQL Practices. LearnSQL.com offers one SQL Practice each month: at the basic level on even-numbered months and at the advanced level on odd-numbered months.
Read more
24 Feb 2022
Jakub Romanowski

New MySQL Courses Are Here!

A lot of you have been waiting for new MySQL courses on LearnSQL.com – and finally, they’re here! Now you can learn everything MySQL in a simple, understandable, and fun way. We've worked a lot with these online SQL courses and created hundreds of interactive exercises to help you learn this popular SQL dialect. If you want to communicate with the world’s most popular open-source database, our MySQL courses will help you achieve that goal!
Read more
23 Feb 2022
LearnSQL.com Team

LearnSQL.com’s Monthly SQL Practice in 2022

Are you looking for ways to practice SQL? Tired of boring exercises based on unreal scenarios? We have something for you! Every month, we publish a new set of SQL practice exercises. You'll find all of them in the monthly SQL Practice. Here at LearnSQL.com, we believe the best way to learn SQL is through practice. All of our SQL courses (and there are over 30 of them!) are hands-on.
Read more