Articles Cookbook
14 Jun 2022
Himanshu Kathuria

These SQL Queries Will Help You With Data Analysis

Need to streamline your everyday data analysis tasks? This article explains how basic SQL queries can help. If you are planning a corporate career or any field that involves working with data, you must have come across SQL, or Structured Query Language. SQL was first developed in the 1970s and it continues to be the industry standard for database interactions. Many of you may already have decided to learn this language, given how powerful it is.
Read more
9 Jun 2022
András Novoszáth

5 Tips for You From a Senior SQL Data Analyst

Are you looking for tips for becoming a better data analyst? Do you want to know about the mistakes and issues you may face? I have collected five tips for your everyday work based on my experience as a data analyst. You may have already read about what data analysts do, how much they earn, and how to become one. However, there is more to it than just becoming a data analyst.
Read more
7 Jun 2022
Tihomir Babic

How to Combine Two Aggregate Functions in SQL

Having trouble using two aggregate functions in one query? This article will show you how to do it the right way – actually, the two right ways. In data analysis and reporting, we often need to count the number of records or sum them up and then calculate the average of this count or sum. Translated to SQL logic, this is the aggregation of aggregated data, or multi-level aggregation. For aggregation purposes, there are the SQL aggregate functions.
Read more
1 Jun 2022
Jakub Romanowski

Course of the Month: PostGIS

What is PostGIS, and why should you learn it? (Hint: Our SQL PostGIS course is free throughout June 2022!) Did you know databases can store geographic data? This is how interactive maps are made, most often based on PostGIS. In this article, I will tell you what PostGIS is and why it’s worth learning. Moreover, I am going to offer you an awesome online PostGIS SQL course which you can do for free during June 2022!
Read more
31 May 2022
Dorota Wdzięczna

How to Install a MySQL Database on a Windows PC

Do you want to install a MySQL database on your Windows computer? And maybe find out how to start using a MySQL database? In this article, we’ll cover the installation process. MySQL is one of the most popular relational database servers. This is one reason to start using a MySQL database. Among the various editions of MySQL delivered by Oracle, the Community edition is available for free. You can download it from the MySQL website.
Read more
26 May 2022
Marcin Koryszewski

Over 40 and Want to Upskill? Learn SQL!

You have several years of experience. Your work has even been written up in a few case studies. Yet, you still have a hard time finding the right path to improve your career. If that's true for you, the answer is to learn SQL. In this article, I'll tell you why. Why learn SQL when you’re already an experienced professional? It’s always good to learn something new. You may want to pick up a new hobby, try out a different industry, or get a new skill to help your career.
Read more
24 May 2022
Ignacio L. Bisso

How to Use the COALESCE() Function in SQL

SQL users are often faced with NULL values in their queries and need to process them properly. The COALESCE() function helps handle NULL values. Read this article to learn how to use COALESCE() in your queries. SQL tables store data in records, and records are composed of fields. There can be situations where we don’t know the value for a specific field. For example, when we don’t know the marital status of a person, SQL allows us to assign a NULL for this field.
Read more
19 May 2022
András Novoszáth

The Recent Rise of DBT and the Analytics Engineer

If you’re interested in data engineering or data analytics, you should know about DBT. And you should also learn about the role of an analytics engineer. We cover both in this article. The rise of Cloud data providers has led to new challenges and possibilities. If you are thinking about entering the data analytics space, it is important to be aware of them; it can help you decide what roles to aim for and what skills to learn.
Read more
17 May 2022
Tihomir Babic

Top 9 SQL GROUP BY Interview Questions

Preparing for an SQL job interview? This guide will walk you through nine basic, intermediate, and advanced GROUP BY questions that you may have to answer. There are common GROUP BY questions that pop up in a lot of SQL job interviews; in this article, we’ll explain how to answer them. If you are a data analyst or another data professional preparing for an interview, this article aims to help you out.
Read more
12 May 2022
Tihomir Babic

What Are Window Functions in SQL?

In this article, we discuss what window functions are and how they help you do your job as a data analyst or specialist. No, window functions have nothing to do with the operating system. The window here refers to a set of rows over which the function aggregates data. To learn how window functions work, what functions there are, and how to apply them to real-world problems, it’s best to take the Window Functions course.
Read more