Articles Cookbook
1 Apr 2024
Jakub Romanowski

Course of the Month: Revenue Trend Analysis in PostgreSQL

Need to understand what your data is saying about your business? In April 2024, our Free SQL Course of the Month is Revenue Trend Analysis in PostgreSQL. Don't miss this opportunity to elevate your analytical capabilities with a leading database system! Understanding revenue trends is crucial for business success, but effective data analysis can be challenging. Dive into the world of SQL reports and enhance your business growth strategies with PostgreSQL.
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
12 Mar 2024
Jeffrey Edison

Data Analyst's Guide to SQL Indexing: Fix Slow Queries

Does your SQL query response time leave something to be desired? Or maybe you don't know if your queries could be faster. In this article, we’ll explain how SQL indexing can help. Diving into SQL is like unlocking a superpower. It's all about mastering the art of querying your database effectively so you can retrieve the information you need quickly and easily. But what happens when you ask a question that's complex enough to slow response time from seconds to minutes – or even longer?
Read more
7 Mar 2024
Nicole Darnley

Efficient Data Analysis: Leveraging SQL with R

This article delves into the nuances of using SQL with R in data analysis. It offers insights and practical examples that demonstrate the effectiveness of this combination. By integrating SQL with R, analysts can leverage the strengths of both languages. This helps them perform comprehensive data analyses, going from initial data retrieval to complex statistical modeling and visualization. To kickstart our exploration of the dynamic duo of SQL and R in data analysis, it's essential to grasp how these two powerful tools can revolutionize the way we handle, manipulate, and interpret vast datasets.
Read more
5 Mar 2024
Maria Durkin

What Is CROSS JOIN in SQL?

What is a CROSS JOIN in SQL, and when should you use it? We answer those questions – and give you some examples of CROSS JOIN you can practice for yourself – in this article. CROSS JOINs, a type of SQL JOIN, create all possible row combinations from two tables. If you're new to JOINs and want to learn more, check out our comprehensive SQL JOINs course, which includes over 90 hands-on exercises on various JOIN types.
Read more