Articles Cookbook
14 Sep 2023
Martyna Sławińska

SQL Practice: 11 SQL Window Functions Practice Exercises with Detailed Solutions

In this article, we present 11 practice exercises involving SQL window functions, along with solutions and detailed explanations. SQL window functions are a powerful feature that lets us extract meaningful insights from our data easily, yet few SQL courses offer SQL window functions exercises. This makes practicing window functions quite difficult. In this article, we’ll give you 11 practice exercises that feature window functions. All exercises shown in this article come from our interactive courses Window Functions and Window Functions Practice Set.
Read more
12 Sep 2023
Maria Durkin

SQL for Project Managers: Enhancing Decision-Making

Did you know that SQL is a vital component in the project manager’s toolkit? In this article, we'll delve into how SQL for project managers enhances their workflow, promotes informed decision-making, and boosts operational efficiency. Data has become the foundation of decision-making across industries. In today's data-driven world, it's critical to arm yourself with the correct tools for dealing with the influx of data. One such tool that has stood the test of time is Structured Query Language, better known as SQL.
Read more
11 Sep 2023
Valentyn Kucherenko

An SQL Basics Primer for Non-IT Professionals

You don’t need to be an IT professional to understand SQL. Our quick primer of SQL basics is perfect for beginners without any computer science or programming background. If you’ve ever tried to learn a new software program, you know it takes more than just a few minutes. But it doesn’t mean you can’t learn it! The same is true if you want to learn SQL and databases. Even if you don’t have an IT background, you can do it.
Read more
7 Sep 2023
Ignacio L. Bisso

COUNT OVER PARTITION BY: An Explanation with 3 Practical Examples

In SQL, combining the COUNT() function with the OVER() clause and PARTITION BY opens the door to a totally different way to count rows. In this article, you’ll learn how to do several COUNTs in a single query and calculate expressions based on the result of the COUNT function. In this article, we will cover how you can use the COUNT() function combined with the clauses OVER() and PARTITION BY.
Read more
5 Sep 2023
Tihomir Babic

SQL Joins: 12 Practice Questions with Detailed Answers

In this article, we dig into our SQL JOINS course and give you 12 join exercises to solve. But don’t worry – all the exercises have solutions and explanations. If you get stuck, help is there! This is, after all, made for practicing and learning.  SQL joins can be tricky. It’s not just the syntax, but also knowing what joins to use in what scenarios. Joins are used when combining data from two or more tables in SQL.
Read more
4 Sep 2023
LearnSQL.com Team

SQL Server Cheat Sheet

Welcome to the SQL Server Cheat Sheet! Whether you're just starting out with SQL Server or you're a seasoned developer looking for a quick reference, this guide is tailored for you. This cheat sheet is a comprehensive guide to SQL Server, offering a quick reference to its essential commands. It covers the basics of creating and displaying databases and tables, the commands to modify tables, and the fundamental syntax for T-SQL commands such as SELECT, INSERT, UPDATE, and DELETE.
Read more
1 Sep 2023
LearnSQL.com Team

Free Course of the Month – SQL Practice Set in PostgreSQL

Do you know the basics of PostgreSQL but still need some practice? Look no further! Here is a great interactive course, SQL Practice Set in PostgreSQL. Throughout the month of September, you have access to it for FREE! We at LearnSQL.com believe that to learn a new skill, you need basic theoretical knowledge and, above all, a lot of practice. It's the same with writing PostgreSQL queries – you need a lot of PostgreSQL practice.
Read more
31 Aug 2023
Jakub Romanowski

How SQL Helps the Healthcare Sector

Why does the healthcare industry need SQL? Find out how you can use SQL for healthcare in this article. The digital age has ushered in a new era where data is at the heart of every industry. From finance to retail, data drives decision-making and strategy, shaping the way businesses operate and grow. The healthcare sector, with its vast and complex data sets, is no exception to this trend. The rise of digital health records, patient databases, and health informatics has underscored the importance of efficient data management in healthcare.
Read more
29 Aug 2023
Maria Durkin

AI for Data Analysis: How the Fusion of AI and SQL Can Accelerate Your Workflow

Did you know that using AI for data analysis can be a total game changer for SQL developers and data analysts? In this article, we’ll learn about how AI can help you level up your data analysis skills and why it’s a must-have tool in every data professional’s toolkit. Artificial Intelligence (AI) has emerged as a game-changer in the workforce, transforming industries and redefining how professionals deal with data. Specifically, the use of AI for data analysis is becoming increasingly critical in making informed decisions.
Read more
29 Aug 2023
LearnSQL.com Team

New Monthly SQL Practice for September 2023!

Ready for our new SQL challenge? This time, we have prepared slightly more difficult SQL tasks. Here’s the September SQL Practice course! This time, you will help Evelyn, the owner of a local art gallery. She would like to gather data to grow her business and has hired you as an SQL specialist to help her out. Which art pieces have not been exhibited? What is the transportation cost for each art piece?
Read more