Articles Cookbook
9 Apr 2024
Radu Gheorghiu

SQL IN Operator

Why do you need to know SQL IN? Find out what you can do with this small but powerful operator. The IN operator is a fundamental tool in SQL, enabling data analysts and developers to filter and retrieve specific subsets of data from databases. While its basic usage may seem straightforward, mastering the nuances and advanced applications of the SQL IN operator can greatly enhance your SQL skills and lead to more powerful and optimized queries.
Read more
8 Apr 2024
LearnSQL.com Team

Does Data Analytics Require Coding

Thinking about a future in data analytics? You might be pondering the need for coding skills. Is it necessary to be good at programming? As the worlds of data analytics, technology, and data science merge, the importance of coding becomes clearer. It’s crucial to understand which programming languages are key and how much expertise you need, making the journey into this vibrant field less daunting. In this article, we're going to focus on the importance of coding, particularly SQL, for data analytics.
Read more
4 Apr 2024
Martyna Sławińska

SQL Numeric Functions

Review all the SQL numeric functions, including their definitions and examples. SQL’s numeric functions perform operations on numbers. They take one or more numbers as arguments and return a number as output. Note that numbers may be of different data types, including integers, doubles, and floats. You can learn more about numeric and decimal data types here. SQL numeric functions can be divided into scalar and aggregate functions. Scalar functions compute a result for each input row individually.
Read more
2 Apr 2024
Maria Durkin

Building a Data Analyst Portfolio: All You Need to Know

In a competitive job market, it is not enough to simply have the necessary skills; you must also demonstrate them. This is where a well-crafted data analyst portfolio comes into play. In data analytics, a portfolio is more than just a collection of projects; it serves as proof of an analyst's abilities and is critical to standing out. It demonstrates concrete capabilities in data cleaning, analysis, and visualization as well as the ability to effectively communicate insights.
Read more
31 Mar 2024
LearnSQL.com Team

New Monthly SQL Practice for April 2024!

In our April 2024 SQL Practice, you’ll meet Damien who manages a local art museum. He needs you to extract and present him with information to promote the museum. Will you use your SQL skills to help him? It should not be too hard if you have finished our SQL Basics course or otherwise understand core SQL concepts. Our interactive SQL course is a great way to test your skills and put what you have learned so far into practice.
Read more
28 Mar 2024
Nicole Darnley

In-Person vs Online SQL Training for Data Analytics

If you want to become a data analyst, you’ll have to choose between in-person and online SQL training. Learn the pros and cons of each path in this article. Want to become a data analyst? First, you have to decide which learning method to choose – traditional, in-person classes or online courses. Technology has given us more options, leading to questions about the best fit for different learning styles and goals.
Read more
26 Mar 2024
Gustavo du Mortier

How to Become a Big Data Engineer

What is a Big Data engineer, and how is their skill set different from a data engineer? In this article, we explore the tools and platforms you’ll need to master as a Big Data engineer. To move from being a regular data engineer to a Big Data engineer, you need to acquire several new skills and learn to use several new tools. The good news is that Big Data still lets you use your good old SQL skills to manipulate and get information from data repositories.
Read more
21 Mar 2024
Tihomir Babic

15 Tricky SQL Interview Questions for Experienced Users

SQL interview questions for experienced users usually contain some trick(y) questions. Interviewers use them to test your gumption, which is typically a result of extensive experience and a high level of SQL knowledge.  I will show you 15 tricky SQL interview questions (mostly coding) in this article. Mind you, these are not necessarily complex questions. Actually, that’s their main characteristic: they seem very easy and straightforward, but that’s the interviewer trying to deceive you.
Read more
19 Mar 2024
Jill Thornhill

SQL Aggregate Functions Cheat Sheet

A quick reference guide to using SQL aggregate functions. This SQL Aggregate Functions Cheat Sheet is designed to be your companion whenever you’re using SQL for data analysis. Aggregating data is essential for any meaningful data analysis. SQL provides a set of functions that allow you to include totals, averages, and counts in your reports and to extract the minimum and maximum value of any column of data.
Read more
14 Mar 2024
Kamila Ostrowska

How to Install MySQL on Ubuntu

Looking to install MySQL on Ubuntu? Delve into the world of efficient data management with this comprehensive guide. From updating your package list to securing your installation and ensuring smooth configurations, these step-by-step instructions will help you seamlessly set up MySQL on your Ubuntu system. If you’re reading this article, you’re seriously interested in working with data. What you need is a suitable tool to make it happen. If you’re considering installing MySQL on an Ubuntu Linux system, you may wonder if this combination is a good choice.
Read more