Articles Cookbook
25 Jun 2021
András Novoszáth

Data Analyst vs. Data Engineer: A Full Comparison

Do you want to become a data analyst? Or maybe you dream about being a data engineer? Can't make up your mind? I'll help you. Read about the two roles’ history, their market situation, and the skills you need to become one in this data engineer vs data analyst comparison. You already know that it's a good idea to enter the data world and work with databases. But how to do it?
Read more
24 Jun 2021
Jakub Romanowski

New Basic SQL Practice Course on LearnSQL.com

Hey, did you hear that there’s a brand-new Basic SQL Practice course on LearnSQL.com? This is a great opportunity to refresh your SQL, write some queries, and take your analytical skills to the next level. We’re proud to introduce Basic SQL Practice: A Store! Where did the idea for this new SQL practice course come from? From our users! They’ve let us know that they need more hands-on SQL exercises at a beginner level.
Read more
23 Jun 2021
Kateryna Koidan

Do You Need to Learn SQL To Become a Programmer?

SQL is primarily used by database administrators (DBAs), business analysts, and data analysts. But what about other programming roles? In this article, I’ll show how software engineers, web developers, and app developers use SQL and why you need to learn SQL to become a programmer. Like many other aspiring programmers, you are probably wondering “Do I need SQL?”. To answer this question, you should know that you’ll encounter data everywhere in software development.
Read more
22 Jun 2021
Himanshu Kathuria

Why Does Your Company Need Data Analysis?

Data is the new gold. That is what the biggest in the business say, knowing the value of the data, the analyses, and the conclusions they bring. If you are wondering why your company needs data analysis and what value it could bring to your business, this article is for you. Many companies have used financial data analysis to boost revenue, cut costs, and increase profits. This approach is still valuable, but today's technology lets you easily capture and use much more information to unlock great value for your business.
Read more
18 Jun 2021
Martyna Sławińska

An Overview of PostgreSQL Data Types

It’s vital to know what you actually store in your database. That’s why every column has its data type. There are numerous PostgreSQL data types across various categories. Read on to see which data type suits which use case! In this article, we’ll go through the most common data types used in PostgreSQL. PostgreSQL, also called Postgres, is a well-known open-source object-relational database management system (DBMS). It is SQL-compliant, extensible, and includes all standard relational database features, such as database constraints, transactions, views, triggers, stored procedures, and more.
Read more
17 Jun 2021
Kamila Ostrowska

SQL Terms Beginners Should Know - Part 4

Here it is – another batch of must-know SQL terms. In the first two parts, we covered tables, relational databases, queries, aliases, SQL JOINs, primary keys, and subqueries. Last time, we moved to more advanced terms like INSERT INTO, GROUP BY, and HAVING. Are you ready to dive deeper into SQL terminology? This is the fourth installment of our series on basic SQL terms for beginners (and everyone else). Don’t worry if you missed the previous articles; you can find Part 1 (essential SQL terms), Part 2, and Part 3 in our blog.
Read more
16 Jun 2021
Tihomir Babic

Business SQL: How to Calculate Revenue Growth in SQL

Can you use SQL in business? Of course you can! For example, you can calculate revenue growth in SQL – here’s how. As someone who works with data, you already know that SQL is the most used tool in data analysis. But how is SQL helpful in business use? Well, the answer is obvious: analyze business data using SQL! However, there are some specifics with business data that can be tricky if you’re not used to it.
Read more
15 Jun 2021
Jakub Romanowski

I Took the SQL Basics Course... Here's What Happened!

In this article, I will share my personal story with you. But don't worry – it's not about a scandal or a sad story of failure. I'll tell you how a successful news journalist fell in love with SQL. It all started when I took the SQL Basics course at LearnSQL.com. There are moments in life that change everything. Mine happened when I decided to give up my long-term career and start a completely new chapter in my professional life.
Read more
10 Jun 2021
Tihomir Babic

How to Draw Pictures with Recursive SQL Queries

Did you know that SQL can be used for fun? You can even ‘draw’ in SQL using recursive queries! Find out how in this article.  As an SQL user, you already know this language is great for data analysis and data manipulation in general. This is something people get very serious about. But you can also have fun with it by drawing ASCII-art pictures using the SQL code. To do that, you have to know how recursive SQL queries work.
Read more
9 Jun 2021
Kateryna Koidan

4 Ways to Learn Which JOIN to Use in a SQL Query

You probably already know that you should use JOIN to combine data from several tables. But what kind of JOIN? In this article, I’ll introduce four simple ways to finally learn which JOIN to use in different scenarios. Before we jump into smart strategies for learning SQL JOINs, I suggest taking a brief overview of the major JOIN types. We’ll go through several examples to recall the difference between (INNER) JOIN, LEFT (OUTER) JOIN, RIGHT (OUTER) JOIN, and FULL (OUTER) JOIN.
Read more