Articles Cookbook
10 Mar 2022
Marcin Koryszewski

These Are the Websites You Should Know When Learning SQL

If you're diving into SQL and searching for top-notch resources to enhance your learning, you've arrived at the right article. Discover the ultimate SQL learning websites that we’ve carefully chosen to support your educational journey. Today, I'm going to share a list of websites that will help you with learning SQL. You will find useful resources, get introduced to some fantastic communities, and expand your database knowledge. Visit these sites regularly – ideally, every day.
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
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

Monthly SQL Practice in 2022 & 2021 Compilation Courses

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
22 Feb 2022
Dominika Florczykowska

An Overview of MySQL Data Types

What data types are available in a MySQL database? In this article, you’ll learn about numeric data types, text data types, and much more! You may have seen our article about data types in SQL. Here, we focus on the MySQL data types. We will discuss the most commonly used ones: numeric, text, and date and time. If you are interested in the topic, be sure to check out our Data Types in SQL course.
Read more
15 Feb 2022
Kateryna Koidan

How to Keep Unmatched Rows From Two Tables in a SQL JOIN

Are you looking to join two tables in SQL without removing unmatched rows? Do you want to keep unmatched rows from one or both tables? In this article, I’ll explain how to keep all the records you want by using outer JOINs, such as LEFT JOIN, RIGHT JOIN, and FULL JOIN. Examples included! The SQL JOIN is a powerful tool that helps you combine data from multiple tables of your database.
Read more
10 Feb 2022
Tihomir Babic

How to Query a Parent-Child Tree in SQL

What are parent-child tree structures in SQL? In this article, we answer that question, talk about query hierarchy, and demonstrate the five most common SQL queries you’ll need for these data structures. Yes, you can use SQL on a parent-child tree structure. I’ll show you how in this article. Along the way, I’ll walk you through five query examples, starting with the easiest and ending with the most complex.
Read more
8 Feb 2022
Himanshu Kathuria

What Is the Future of the Data Engineer?

If you are wondering about the future of data engineering as a career and whether it is worth becoming a data engineer, then this article is for you. Here, I cover how lucrative the prospects are for data engineering and how you can get started and thrive in the domain. “Data” is probably one of the most used terms in our everyday business language today. A data engineer plays a pivotal role in developing the infrastructure required for data-related actions.
Read more
3 Feb 2022
Karolina Niewiarowska

Is Learning PostgreSQL in 2022 Worthwhile?

You want to take a SQL course, but selecting the right one can be too challenging. Perhaps you don't know which dialect you should start with? PostgreSQL is one of the best options. Check out if it is worth it to learn PostgreSQL in 2022. When you search the web, there are many job advertisements for database specialists. Perhaps that is why you have chosen the direction toward development. Or maybe you are just fed up with Excel in your day-to-day duties (which is not surprising) and want to make work easier.
Read more
27 Jan 2022
Kateryna Koidan

How Do You Get Rid of Duplicates in an SQL JOIN?

Do you have unwanted duplicates from your SQL JOIN query? In this article, I’ll discuss the possible reasons for getting duplicates after joining tables in SQL and show how to fix a query depending on the reason behind the duplicates. Data analysts with little experience in SQL JOINs often encounter unwanted duplicates in the result set. It’s challenging for beginners to identify the reason behind these duplicates in JOINs.
Read more