Articles Cookbook
21 Mar 2023
Kamila Ostrowska

Best MySQL Courses for Beginners

SQL is among the most important languages when it comes to dealing with huge amounts of data. If your job includes analyzing or collecting data and you feel that an Excel file is not enough, you need to learn or develop your SQL skills. And if you learn SQL, you also need to know one of its most popular dialects - MySQL. If you've made the decision to learn SQL, you've come to the right place.
Read more
16 Mar 2023
Tihomir Babic

The SQL COUNT() Function: A Detailed Guide

This guide will give you a detailed explanation (with examples) of all the typical uses of the COUNT() function. Exercises included! The COUNT() function in SQL is one of the most commonly used aggregate functions. Aggregate functions in SQL are used to calculate statistics for a group of rows: counting the number of rows in each group, computing the sum of values in a group, finding the minimum or maximum value in a group, and so on.
Read more
14 Mar 2023
Jakub Romanowski

Learning SQL in Your Native Language is Finally Possible

Do you or someone you know speak English as a second language? Would you like to learn SQL online in your preferred language? Good news! Our awesome SQL courses are now available in French, Spanish, German, Italian, and Portuguese! SQL, or Structured Query Language, is a programming language used for managing and manipulating data in databases. It's an essential skill for anyone working with data, whether you're a data analyst, a software developer, or just someone who wants to understand how databases work.
Read more
9 Mar 2023
Maria Durkin

The Best Apps to Learn SQL

Let us guide you to the best apps for learning SQL on the go. They are designed to seamlessly integrate into your busy lifestyle – ensuring you develop your database skills anytime, anywhere. Are you eager to dive into SQL but unsure where to start? This article is your ultimate guide to the top apps for learning SQL. We include suggestions tailored for users of all levels, from beginners to advanced learners.
Read more
7 Mar 2023
Jill Thornhill

The Best YouTube Channels for Learning SQL

Discovering the best YouTube channel from which to learn SQL is essential for beginners and enthusiasts alike, as SQL learning doesn't have to be challenging. If you're wondering whether watching online videos is the most effective way to master SQL, it's crucial to explore and identify high-quality YouTube channels dedicated to teaching SQL. This approach ensures you gain a comprehensive understanding of SQL through engaging and informative content. So you’re thinking of learning SQL?
Read more
28 Feb 2023
Ignacio L. Bisso

25 Advanced SQL Query Examples

One of the best ways to learn advanced SQL is by studying example queries. In this article, we'll show 25 examples of advanced SQL queries from medium to high complexity. You can use them to refresh your knowledge of advanced SQL or to review before a SQL interview. Table Employee Many of the examples in this article will be based on the following employee table. Only a few examples will be based on other tables; in these cases, the tables will be explained along with the example.
Read more
23 Feb 2023
Tihomir Babic

Top 27 Advanced SQL Interview Questions with Answers

Where can an SQL professional find a comprehensive guide to advanced SQL interview questions? The shortest answer is: here! We selected the 27 most important SQL questions and answered them for you.  Preparing for an SQL interview is not easy, especially if your job requires the knowledge of advanced SQL. This article contains the 27 most commonly asked advanced SQL interview questions and provides detailed answers and resources for further reading.
Read more
21 Feb 2023
Tihomir Babic

6 Useful Examples of CTEs in SQL Server

How can you use CTEs in SQL Server in your everyday professional life as a data pro? We’ll answer this question by giving you six examples. CTE is short for Common Table Expression. This is a relatively new feature in SQL Server that was made available with SQL Server 2005. A CTE is a temporary named result. This result is available only for the query that runs it. It isn’t stored, so it doesn't take up disk space.
Read more
16 Feb 2023
Alexandre Bruffa

How to Concatenate Two Columns in SQL – A Detailed Guide

In SQL, concatenation is the operation of joining together strings, or pieces of text information. Learn how to concatenate two columns in SQL with this detailed guide. SQL concatenation is the process of combining two or more character strings, columns, or expressions into a single string. For example, the concatenation of 'Kate', ' ', and 'Smith' gives us 'Kate Smith'. Enhance your SQL skills with our interactive SQL Practice Set! This comprehensive course contains nearly 90 hands-on exercises, divided into five topic-based sections, including a section dedicated to SQL concatenation.
Read more
14 Feb 2023
Nicole Darnley

Data Cleaning in SQL

Data cleaning is an important part of any data analysis. Here we’ll discuss techniques you can use to do data cleaning in SQL. I find it nearly impossible to focus on work when my desk is a mess. If it’s cluttered with paper, coffee mugs, or random toys my daughter has somehow snuck into my office, there is no chance I will be able to get anything done until my desk is back in order.
Read more