Articles Cookbook
18 Jan 2024
Martyna Sławińska

18 SQL Questions for Beginners: Theory and Practice

Whether you're starting or refreshing your SQL skills, join us as we work through these 18 SQL practice questions for beginners. SQL, or Structured Query Language, is a programming language used to define, retrieve, and manipulate data in relational databases. It provides an intuitive syntax of SQL statements and keywords that create, modify, and query relational databases. This article focuses on reviewing and practicing the basics of SQL. We’ll start by reviewing the SELECT statement and its required and optional components for fetching data from a single table.
Read more
16 Jan 2024
Maria Durkin

SQL CASE WHEN Explained: 10 Easy Examples for Beginners

The CASE WHEN statement lets us make decisions on our data, categorizing and manipulating records based on specified conditions. Find out how to use CASE WHEN in this article. Imagine you're deciding what to wear for the day. You take out your umbrella if it's raining; if not, you leave it at home. This decision-making procedure is essentially the same as a SQL CASE WHEN statement. In the realm of SQL, the CASE WHEN statement functions much like an if-then-else expression, allowing us to create custom classifications within a query.
Read more
10 Jan 2024
Jill Thornhill

Data Export: From SQL Query to Spreadsheet

How do you export data from an SQL database to Excel or another spreadsheet? In this article, I’ll look at various methods and share a few tips for when things go wrong. SQL is the most widely used method of extracting data from a database. However, it’s not the only gadget in an analyst’s toolbox. Once the information is extracted, you’ll often want to import it into a spreadsheet – maybe to do further analysis or just to make it look pretty so you can present it to management.
Read more
10 Jan 2024
LearnSQL.com Team

2024 Monthly SQL Practice: New Challenges

Ready to boost your SQL skills in 2024? LearnSQL.com’s Monthly SQL Practice offers new courses and real-world exercises for all levels. Ready to elevate your SQL skills in 2024? LearnSQL.com’s Monthly SQL Practice returns this year with fresh, real-world exercises designed to keep your SQL sharp. Whether you're just starting out or already well-versed in SQL, our practice challenges offer a structured way to develop your expertise each month. With two new course releases—2023 Monthly SQL Practice Sets - Basic and 2023 Monthly SQL Practice Sets - Advanced—you'll have plenty of opportunities to refine your SQL knowledge this year.
Read more
9 Jan 2024
Alexandre Bruffa

Using SQL in Data Warehousing

SQL is a key player in organizing and analyzing data in data warehouses. In this article, I'll introduce you to the basics of SQL in data warehousing. We’ll learn how this powerful language helps manage large datasets, making your work easier and more productive. Whether you're a student diving into the world of technology or an experienced specialist navigating the domain of data, understanding the concept of data warehousing is fundamental.
Read more
4 Jan 2024
Jakub Romanowski

Analyzing Social Media Data with SQL

Diving into the world of SQL social media analysis? This guide will help you start using SQL to analyze and interpret data from social media platforms. Get ready to transform your approach to digital data and unlock new possibilities in social media analytics! Welcome to the exciting world of SQL and social media analysis! If you're new to this field, you're about to discover how powerful a tool SQL can be in understanding the vast sea of data generated on social media platforms every day.
Read more
2 Jan 2024
Maria Durkin

SQL and Power BI: Transforming Data into Insights

The need for powerful tools that enable efficient data analysis and visualization has never been greater. Enter SQL and Power BI, a potent duo that enables businesses to maximize the value of their data assets. First, let’s explain what SQL and Power BI are; then we’ll discuss how and why they make such a great pair. SQL, or Structured Query Language, allows you to communicate with databases, making it the foundation of data management.
Read more
1 Jan 2024
Jakub Romanowski

Course of the Month: SQL Practice - Running

Kick off the new year and enhance your SQL skills with January’s free Course of the Month, Basic SQL Practice: Run Track Through Queries! As the new year unfolds, it's a time for reflection and the setting of new goals. A popular resolution among professionals and students alike is to acquire new skills or deepen existing ones. Whether it's learning a new language, mastering a software tool, or enhancing your job qualifications, the start of a new year provides a fresh opportunity for personal and professional growth.
Read more
26 Dec 2023
Tihomir Babic

SQL Query Practice: 20 Exercises for Beginners

These 20 exercises are just what beginners need for SQL query practice. Try to solve each of them, and then look at the solutions. If something needs to be clarified, there are explanations for each solution. In this article, there’ll be less talking than usual. Instead, you’re going to write the answers to SQL practice exercises. (Don’t worry; we’ve included the solutions if you get stuck.) The whole point is to give you, as a beginner, plenty of opportunities for SQL query practice.
Read more
22 Dec 2023
LearnSQL.com Team

New Monthly SQL Practice for January 2024!

In our January 2024 SQL Practice, you’ll meet Julie. She is the owner of an online store where she sells handmade crochet items. She has hired you to help her with data analysis to grow her business. What are the best-selling products? Which products bring the most revenue? Can you create reports to help her with sales trends? You will find all the answers in the data. You just need to figure out how to get them out of the database using SQL.
Read more