Articles Cookbook
1 Mar 2024
Jakub Romanowski

Course of the Month: Window Functions in PostgreSQL

Are you looking for the best way to master SQL window functions? Throughout March 2024, you can access the interactive course Window Functions in PostgreSQL for free. Boost your skills at no cost. Hurry, time is running out! Need a free PostgreSQL course on window functions? You've come to the right place! If you are reading this article, you probably know PostgreSQL is one of the most popular databases in the world.
Read more
29 Feb 2024
Alexandre Bruffa

20 SQL Practice Problems for Beginner and Intermediate Users

Want to become an SQL expert? Try solving those 20 SQL practice problems! Whether you're just starting your SQL journey or preparing for exams, you need to sharpen your SQL skills if you want to become an expert. And you know what people say: practice makes perfect! Like most skills, SQL is best learned through experience; practicing SQL allows you to apply your knowledge to real-world scenarios. Through repeated practice, you'll gain the confidence to dive into complex SQL tasks and excel in both academic and professional fields.
Read more
27 Feb 2024
LearnSQL.com Team

New Monthly SQL Practice for March 2024!

Ready for our new SQL challenge? This time, we have prepared slightly more difficult SQL tasks. Here’s the March SQL Practice course! This time, you will help Lilia who runs a genetic testing clinic. She needs insight into the performance of her clinic for February 2024 and has hired you as an SQL specialist to help her out. Can you identify the most popular tests? Can you create a report on patient preferences by age?
Read more
27 Feb 2024
Ignacio L. Bisso

6 Examples of NTILE() Function in SQL

The SQL NTILE() function can greatly simplify your data analysis and reporting. Follow these six examples to learn what it is and when to use it. Window functions are very useful, providing great expressive power to SQL. In this article, we discuss the NTILE() function, which allows us to divide a set of records into subsets of approximately equal size. This function is widely used in financial or economic calculations.
Read more
22 Feb 2024
Radu Gheorghiu

RIGHT JOIN in SQL: A Beginner's Tutorial

Learn RIGHT JOIN, a crucial command for any SQL specialist. Our article breaks down this essential technique, helping beginners effortlessly navigate and apply RIGHT JOIN in their database queries. In SQL, RIGHT JOIN (also known as RIGHT OUTER JOIN) is crucial for handling data effectively. This article is a beginner-friendly guide to the SQL RIGHT JOIN, an essential technique for merging different data tables. We'll walk you through the specifics of RIGHT JOIN, explaining how it stands apart from other join types in managing data.
Read more
21 Feb 2024
LearnSQL.com Team

4th Anniversary of LearnSQL.com

Time runs so fast. This week, we celebrate the 4th anniversary of LearnSQL.com. We have come a long way together and we promise to get even better in the upcoming year! Thank you for being with us. 1459 days have passed since February 23, 2020, when we launched the LearnSQL.com platform. That's 35,016 hours, or 2,100,960 minutes, if you prefer. It's been a long time, but it feels like yesterday that we started out together.
Read more
20 Feb 2024
Gustavo du Mortier

MySQL Date Functions: Complete Analyst’s Guide

Master MySQL date functions and acquire a powerful tool to work with date and time information in your data analyses. Working with date and time data is an essential part of data analysis. Here are just three examples: Analyzing historical time series data is crucial for discovering trends and making reliable forecasts based on chronological information. Stock market analysis examines time series data extensively, especially when automated trading algorithms are employed.
Read more
15 Feb 2024
Maria Durkin

SQL HAVING Clause: A Tutorial for Beginners

So, you're new to SQL and have just stumbled upon the HAVING clause. But what does it do? Why is it essential? In this article, we'll delve into the basics of the HAVING clause in SQL. And we’ll walk through practical exercises to enhance your understanding of its functionality. Let's start by defining Structured Query Language (SQL). SQL is a powerful and standardized programming language designed specifically for managing and manipulating relational databases; simply put, it is how we communicate with the databases that hold all of our important data.
Read more
14 Feb 2024
LearnSQL.com Team

PostgreSQL Cheat Sheet

Here's your ultimate PostgreSQL cheat sheet! Whether you're a newbie or an experienced pro in need of a quick reference, this cheat sheet has got you covered. This PostgreSQL Cheat Sheet summarizes the key PostgreSQL commands and features you'll use often. It covers everything from how to connect to a PostgreSQL server and manage database contents, to the basic syntax for table creation and modification. It also breaks down the syntax for SELECT, INSERT, UPDATE, DELETE commands, and shows how to use different PostgreSQL functions, including text functions, numeric functions, NULL functions, and date and time functions.
Read more
13 Feb 2024
Jill Thornhill

Integrating SQL with Python for Data Analysis

Integrating SQL with Python isn’t difficult. The two tools work together to combine the information-processing power of relational databases with the flexibility of a programming language. In this article, I will discuss the benefits of data analysis using SQL and Python, with real-world coding examples. Why do most of the best data analysis tools on the market – such as Tableau and Power BI – include both SQL and Python in their toolboxes?
Read more