Articles Cookbook
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
10 Oct 2022
Tihomir Babic

SQL Courses for Software Testers

In this article, you will learn why software testers need SQL and which courses are ideal for them to learn it. Do software testers need SQL? Oh yes, they do! They don’t necessarily use it all the time or take advantage of all its possible features. But a tool for accessing data in a database is essential for a software tester. And SQL is exactly that: a programming language designed specifically for handling data in relational databases.
Read more
4 Oct 2022
Himanshu Kathuria

How Much Do Business Analysts Earn?

What does a business analyst do, and why are they essential to their companies’ success? What skills do you need to become a business analyst? How much can you expect to earn? We’ll answer all those questions in this article. With our dependence on digital systems increasing by the day, IT and IT related jobs like business analysts are seeing a continuous boom in opportunities. Did you know that IDC estimates around 60% of the global GDP will be mostly impacted by the introduction of digital tools by the end 2022?
Read more
29 Sep 2022
Ignacio L. Bisso

How the WITH Clause Works in SQL

Do you want to master complex SQL queries? Learn how to use the powerful WITH clause! In SQL, there are simple queries and complex queries. A simple query can take data from a table, apply a filter, and return the data as it is in the source table. A complex query may require complex transformations to the source data or may need to read and join data from multiple tables or views.
Read more
27 Sep 2022
Himanshu Kathuria

SQL ORDER BY Clause with 7 Examples

Get to know the SQL ORDER BY clause! Our practical and easy examples will help you understand its syntax, common uses, and best practices. SQL or Structured Query Language lets you “talk” to a database. It enables you to create, retrieve and manipulate the data in a relational database. This language has become so ubiquitous that hardly any data-related field has been untouched by it. If you’re interested in the SQL ORDER BY clause, I’m assuming you have either already started learning SQL or are planning to start it soon.
Read more
22 Sep 2022
Kateryna Koidan

Roadmap to Becoming a Data Analyst

What is a data analyst? What are their daily duties, and what skills do they need? In this article, I discuss the role of data analysts and share a step-by-step guide on how to become one. As organizations start to realize the value of their data on their customers, target audience, competitors, suppliers, and other market players, the role of data analysts becomes more important. To become a successful data analyst who can bring real value to the organization, you need to possess a specific set of skills.
Read more
15 Sep 2022
Martyna Sławińska

How to Import a CSV File to a MySQL Database

CSV files store and transfer data between databases. Read on to find out how easy it is to work with CSV files in a MySQL database. CSV files are one of the oldest data exchange formats and are still heavily used by IT professionals from various domains. It is common for online data resources and different database software to offer their data uploads and downloads in CSV format. In this article, we’ll briefly review what a CSV file is and how to work with it.
Read more