Create free account
User profile menu open
Open user profile menu
Payment & Billing
Payment & Billing
Create free account
27 Feb 2024
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?
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.
22 Feb 2024
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.
21 Feb 2024
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.
20 Feb 2024
Gustavo du Mortier
MySQL Date Functions: An Analyst’s Complete Guide, with Practical Cookbooks
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.
15 Feb 2024
Introduction to the 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.
14 Feb 2024
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.
13 Feb 2024
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?
8 Feb 2024
9 Practical Examples of SQL LEFT JOIN
LEFT JOIN is one of SQL's most common JOINs. Make sure you know all its ins and outs by going through all nine of our real-life LEFT JOIN examples. LEFT JOIN – alongside INNER JOIN – is one of the essential SQL tools you need to work with data from two or more tables. But how and when should you use it? These nine LEFT JOIN examples will point the way.
5 Feb 2024
MySQL Practice: Best Exercises for Beginners
These 15 MySQL exercises are especially designed for beginners. They cover essential topics like selecting data from one table, ordering and grouping data, and joining data from multiple tables This article showcases beginner-level MySQL practice exercises, including solutions and comprehensive explanations. If you need to practice … Selecting data from one table Ordering and grouping data Joining data from multiple tables … these 15 tasks are just for you!