Articles Cookbook
7 Sep 2023
Ignacio L. Bisso

COUNT OVER PARTITION BY: An Explanation with 3 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
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 common integration of hospital inventory management software has underscored the importance of efficient data management in healthcare.
Read more
29 Aug 2023
Maria Durkin

How AI & SQL Can Accelerate Your Data Analysis 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
25 Aug 2023
LearnSQL.com Team

SQL for Data Analysis Cheat Sheet

Welcome to our SQL for Data Analysis Cheat Sheet — a must-have resource for anyone looking to harness the power of SQL in the realm of data analysis. Whether you're a data enthusiast, a business analyst, or a seasoned data professional, this cheat sheet is designed to empower you to extract valuable insights from your datasets. Inside, you'll find a carefully curated collection of SQL commands and tips that will elevate your data analysis game.
Read more
24 Aug 2023
Kamila Ostrowska

New Feature: Notebook to Boost Your SQL Learning

You want to learn SQL effectively but you keep forgetting queries? Now you can use  LearnSQL.com’s new notebook feature in all our courses! This new tool will help you memorize and recall content. I remember when I first started to learn SQL. I was moving quite smoothly through most of the lessons, taking a lot of notes in my paper notebook. (I have a lot of old school paper notebooks).
Read more
22 Aug 2023
Nicole Darnley

How to Prepare for an Advanced SQL Interview

Tips and tricks to help you ace even the most advanced SQL interview questions. SQL has become the lingua franca of data – the standard method for interacting with databases, extracting insights, and conducting analytical tasks. As a data analyst, the ability to understand and manipulate SQL code is not just a 'nice to have'; it's an absolute necessity. For many data analyst roles, a basic understanding of SQL isn't enough.
Read more
17 Aug 2023
Tihomir Babic

20 Basic SQL Query Examples for Beginners

These 20 basic queries are a must in a starter pack for every SQL beginner. These examples will get you going on your journey to mastering SQL. You’ve set your mind on learning SQL, googled ‘basic sql query examples’ or something similar, and here you are staring at this article. Now what? All learning starts with the basics, so let’s start with the most basic question: What Is SQL?
Read more
15 Aug 2023
Jill Thornhill

Data-Driven Career Choices: Database Student

Choosing a career is one of the most important decisions you'll ever make. A data-driven career is one of the best ways to secure your future; today's trend is to store and make use of more and more data in every field. In this article, I'll look at some of the choices available. We're living in an era where the quality and quantity of data is expanding exponentially. In almost any career you choose, you'll need to leverage data to make effective decisions.
Read more