Articles Cookbook
17 Nov 2022
Luke Hande

What Is an SQL Database?

SQL databases have been used for decades and have grown in popularity, becoming one of the most common data management tools. They provide the user with an efficient way to store the data and an intuitive way to access or modify it. In this article, we’ll start by explaining what a database is and showing some examples. We’ll move on to how databases can be used to efficiently work with large amounts of structured data.
Read more
15 Nov 2022
Himanshu Kathuria

Best SQL Courses for Beginners in 2024

Whether you’re dreaming of a career in data analytics or just want to learn a new skill, learning SQL is worthwhile. But don’t waste your time on poorly-designed courses or other learning resources! In this article, I’ve collected the best online SQL courses for beginners. Pick one and start being awesome! SQL (Structured Query Language) has emerged as one of the top skills that recruiters look for when it comes to data related jobs.
Read more
10 Nov 2022
Tihomir Babic

How to Use GROUP BY in SQL

In this article, we’ll give you a step-by-step guide on using GROUP BY in SQL. Uncover the nuances of the GROUP BY clause and learn different ways of using it. GROUP BY is one of the most-used clauses in SQL. It moves you from simply selecting data from the database to grouping rows with the same column values into one group. When used with SQL’s aggregate functions, you can use GROUP BY to compute metrics like counting the number of instances or finding the total, average, minimum, or maximum value.
Read more
8 Nov 2022
Tihomir Babic

How to Use the PARTITION BY Clause in SQL

We’ll be dealing with the window functions today. Specifically, we’ll focus on the PARTITION BY clause and explain what it does. PARTITION BY is one of the clauses used in window functions. In SQL, window functions are used for organizing data into groups and calculating statistics for them. It sounds awfully familiar, doesn’t it? Even though they sound similar, window functions and GROUP BY are not the same; window functions are more like GROUP BY on steroids.
Read more
3 Nov 2022
Jakub Romanowski

Track of the Season: SQL from A to Z in SQL Server

Maybe your company uses MS SQL Server and you’d like to join the data analysis team. Or maybe you want to add a new skill to your CV. Either way, our SQL Track of the Season: SQL from A to Z in MS SQL Server, will help. In this article, I’ll answer common questions about this awesome set of online MS SQL Server courses. If you’re reading this blog post, you probably already know that you should start learning SQL and working with databases.
Read more
27 Oct 2022
Ignacio L. Bisso

What Are the Basic SQL Queries?

You can access the data in a database using some basic SQL queries. In this article, we review the fundamentals SQL queries every beginner should know. Databases are everywhere, and they contain different kinds of data. Almost all of them support SQL, a language that lets you read and manipulate the data inside a database. In this article, I’ll show you the basic SQL queries that you can use to perform many common everyday data tasks.
Read more
25 Oct 2022
Tihomir Babic

An Overview of SQL Text Functions in PostgreSQL

If you’re a PostgreSQL user and into data analysis, you’ve heard of the text functions or maybe even used them. But what are PostgreSQL’s most popular text functions? In today’s article, we’ll show you what they are and how to use them. As anyone who works with them knows, databases don’t contain only numerical values. Among other data types, databases also store text or string data. To use PostgreSQL effectively, you’ll have to know at least some of Postgres’ text functions.
Read more
20 Oct 2022
Dominika Florczykowska

What Does a Double Colon Operator in PostgreSQL Do?

The double colon operator :: in PostgreSQL is a synonym for CAST, which converts a value into a different data type.  If you are curious about the details , read on! Have you ever seen a double colon (::) operator in someone’s PostgreSQL code? It would look something like this: SELECT '2022-09-02'::date; This code converts the text '2022-09-02' to a date datatype. As mentioned above, the double colon replaces the CAST operator.
Read more
18 Oct 2022
Kateryna Koidan

SQL Beginners: Questions to Ask Before Writing a Query

SQL is known for its easy-to-follow syntax that even beginners can understand pretty quickly. Still, to write your own SQL queries, you need to know the basics. Let’s explore what things need to be considered before writing a SQL query. If you are looking for a career in data analysis or just want to work effectively and independently with data in any analytical position, you’ll need to master SQL. Luckily, this programming language is beginner-friendly and can be learned just in a few months with the right learning sources.
Read more
13 Oct 2022
András Novoszáth

Why You Need Analytical Skills to Get Promoted at Work

Do you wonder if analytical skills might benefit you in your job? Are ‘analytical skills’ the same as data analytics? Is SQL a useful analytical skill? Read the article to answer these questions. Analytical skills allow you to better understand problems in your work; good analytical skills bring many benefits to your career. The term ‘analytical’ refers to a wide range of traits and capabilities, making it sometimes ironically vague and general.
Read more