Articles Cookbook
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
8 Feb 2024
Tihomir Babic

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.
Read more
5 Feb 2024
Martyna Sławińska

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!
Read more
1 Feb 2024
Jakub Romanowski

Course of the Month: Common Functions in PostgreSQL

Do you want to be able to use popular PostgreSQL functions and process different types of data more easily? You've come to the right place! Here is the Common Functions in PostgreSQL course. Throughout the month of February, this SQL course is absolutely FREE! You are probably wondering why LearnSQL.com is offering a free SQL course. Well, we've been doing this for a long time. We choose one of our courses every month and give users free access to it.
Read more
1 Feb 2024
Jakub Romanowski

The Best Online SQL Editors

When it comes to online SQL editors, you have lots of options. Find out what features you should look for and what editors we prefer in this article. In this article, I'm going to share my insights on online SQL editors. These handy web-based tools have made my SQL query execution and database management tasks much simpler and more accessible – especially when compared to traditional desktop software. I'll discuss their key features and offer guidance on choosing the right one for different needs, whether you're a beginner or an experienced user.
Read more
31 Jan 2024
Maria Durkin

This Advanced SQL Course Will Boost Your Career!

Can you already create pretty good SQL reports? Do you want to take it a step further? In this article, I'll explain how an advanced SQL course can propel you (and your career) to the next level. Since you are looking for information about SQL, you probably already know how important data is nowadays. Very few companies can stay on the market without using the power of data or basing their strategic decisions on it.
Read more
30 Jan 2024
LearnSQL.com Team

New Monthly SQL Practice for February 2024!

In our February 2024 SQL Practice, you will meet Andrew. He is the manager of a ski resort in Tirol and needs help to get important insights from the database of his resort. He wants to find out how customers rate different slopes at his resort, which reviews are the best and the worst for the slopes, which slopes are the least popular, etc. Will you use your SQL skills to help him?
Read more
30 Jan 2024
Tihomir Babic

SQL Server Date Functions: A Data Analysis Guide

Date functions are the bread and butter of data analysis and reporting with SQL Server. In this guide, I will show you practical examples of the use of SQL Server date functions and how to apply them to your reports. A question for all data analysts: Do you want to be taken seriously? I’m sure you do. In that case, knowing SQL Server date functions is mandatory. Date and time data types are ubiquitous in databases, as they are essential for reporting.
Read more
25 Jan 2024
Jakub Romanowski

Your Complete Guide to SQL JOINs (with Resources)

This detailed guide covers all important SQL JOIN topics, from basic concepts to advanced techniques. Bookmark this guide for future reference – it’s packed with useful resources and guides to help you work with JOINs effectively. SQL JOINs are essential in SQL and data analysis, as they let you combine data from different tables into a unified view. In this article, I've gathered everything you need to know about SQL JOINs.
Read more
23 Jan 2024
Maria Durkin

Business Analyst vs Data Analyst: Roles & Career Paths

Are you interested in working as a data analyst or business analyst? What’s the difference between these two roles? We explain the data analyst vs. business analyst debate in this article – and give you a pathway for success in either job. The demand for individuals skilled in decoding complex data has reached new heights in the ever-changing business landscape. Among the many roles available, business analysts and data analysts each have their own responsibilities, skill sets, and career paths.
Read more