Articles Cookbook
20 Jun 2024
Tihomir Babic

SQL for Financial Reporting

SQL should be part of every modern financial reporting process. It can deal with gigabytes of data and perform financial calculations in a split second. It’s time to transition from Abacus (also known as Excel!) and start using SQL in financial reporting.    Data has taken a central part in business decision making. This applies even more to financial data. The main goal of businesses is to make a profit, so it’s no wonder that financial data plays a crucial role in the strategic decision-making process of any modern business.
Read more
18 Jun 2024
Kamila Ostrowska

Mastering MySQL for Data Analysis

Mastering MySQL can significantly benefit anyone looking to advance in data science or database management. If you develop your data analysis skills in MySQL, you’re on the right path to positively influence your career. In this article, you’ll learn how to practice MySQL effectively and what kind of learning sources to choose. You’ll see for yourself that MySQL is not rocket science and that using it can be easy and intuitive.
Read more
13 Jun 2024
Gustavo du Mortier

SQL CTEs: A Complete Overview of Common Table Expressions

This article provides a detailed guide to everything you need to know about common table expressions (CTEs), from the basic definition to the most complex recursive queries. If the database you use supports CTEs, here’s everything you need to get the most out of it. Common table expressions – also called CTEs, WITH clauses, or recursive queries (although this last name is actually a specific application) – are a relatively new feature of SQL.
Read more
11 Jun 2024
Jill Thornhill

SQL LAG() Function

The LAG() function – one of SQL’s window functions – is an important tool for planning and trend analysis. In this article, I’ll demonstrate how to include SQL LAG() in your queries using a few real-world examples. SQL window functions, also known as analytical functions or OVER functions, add a new dimension to data analysis. They allow you to include aggregates or data from other rows alongside the current row.
Read more
6 Jun 2024
Jakub Romanowski

Transitioning to a Database Career: A Guide for Beginners

Whether you're looking to become a database administrator or a data analyst or to explore other roles, I've got you covered! In this article, you’ll learn about the insights and strategies you need to launch your database career successfully. Considering a career in databases but not sure where to start? This guide is designed to help beginners navigate the world of database careers with ease. Understand the essential skills needed, learn to get hands-on experience, and explore the benefits of networking with professionals.
Read more
4 Jun 2024
Maria Durkin

The SQL BETWEEN Operator

SQL comparison operators are essential tools for filtering data in database queries. Among these operators, the BETWEEN operator stands out as an important tool for specifying ranges inside datasets. SQL comparison operators, such as BETWEEN, are useful for filtering data in database queries. The BETWEEN operator allows you to select rows within a given range, making it ideal for tasks like segmenting an audience by age ranges, identifying thresholds for items between certain quantities, or categorizing performance based on exam scores.
Read more
2 Jun 2024
Jakub Romanowski

Free Course of the Month: 2023 Monthly SQL Practice Sets – Advanced

Enhance your SQL skills this June 2024 with our exclusive offer on the 2023 Monthly SQL Practice Sets - Advanced course, available for free for a limited time! As summer rolls in, it's the perfect time to learn new skills or brush up on the ones you've got. This June, why not seize the chance to deepen your SQL expertise with some challenging exercises drawn straight from the business world?
Read more
31 May 2024
LearnSQL.com Team

New Monthly SQL Practice for June 2024!

In our June 2024 SQL Practice, you will meet Christine, the manager of a gym downtown, who seeks help in gaining essential insights from the gym database. She wants to understand various aspects: the popularity of each trainer, the average price for a training session, members with active plans, and more. Can you use your SQL skills to lend her a hand? It should not be too challenging if you have completed our SQL Basics course or have a solid grasp of fundamental SQL concepts.
Read more
30 May 2024
Jakub Romanowski

Best Books for Learning PostgreSQL

Explore the world of PostgreSQL with our handpicked selection of the best books available. Whether you’re new to database management or looking to sharpen your skills, these resources are perfect for mastering the comprehensive features of PostgreSQL. I've been diving deep into PostgreSQL lately, and I'm excited to share the five best PostgreSQL books that have really helped me along the way. Whether you're just starting out or you're looking to deepen your expertise, there's a book here for everyone.
Read more
29 May 2024
Agnieszka Kozubek-Krycuń

Top 100+ SQL Interview Questions and Practice Exercises

Are you gearing up for a SQL interview? This article is packed with over 100 SQL interview questions and practical exercises, organized by topic, to help you prepare thoroughly and approach your interview with confidence. SQL is essential for many jobs, like data analysis, data science, software engineering, data engineering, testing, and many others. Preparing well for a SQL interview is crucial, no matter what role you're aiming for.
Read more