Are you ready to unlock the power of SQL and become a master of database design? Look no further! In this comprehensive

Read More
Master the Art of Creating Tables in SQL: A Step-by-Step Guide to Database Design

Learn how to use the ROW_NUMBER() windows function to generate a unique ID. Problem: You have a table named Teams with information

Read More
Use ROW_NUMBER to Create a Unique ID

Problem We want to compare two moving averages in SQL. We’ll use window functions to do this, as it is easier write

Read More
Compare Two Moving Averages in SQL

Problem You want to remove duplicates in SQL. You know it is easy to find duplicates using GROUP BY, but how do

Read More
Find and Remove Duplicates in SQL

Problem You need to find duplicates and then identify the records by their primary keys. Background Here’s an example of how to

Read More
How to Find Duplicates using a Windows Function?

Problem How do you create a moving average using windows functions in SQL? Background There is no built-in function to create a

Read More
Calculate a Moving Average in SQL using A Windows Function

Problem How do you create a running total on a column using SQL? Background There is no built-in function to create a

Read More
Calculate a Running Total in SQL using a Windows Function

Introduction Window functions are an essential tool for data analysis, particularly in the SQL language. They allow you to perform complex calculations,

Read More
Working with ROW_NUMBER, RANK, and DENSE_RANK

In this article let’s look at window functions vs GROUP BY queries. We’ll do so by looking at how each statement works

Read More
Window Functions vs Group By Queries?

SQL Joins are important to master. As you progress from a beginner to advanced beginner, you’ll soon need to combine data from

Read More
SQL Joins – The Ultimate Guide

In this lesson you are going to explore how to do pattern matching with the SQL Where clause LIKE operator.  Using this

Read More
Do Partial Matches Using LIKE

SQLite3 Review SQLite3 is a compact free database you can use easily create and use a database.  Though SQLite3 is not a

Read More
What is SQLite3?

This is the first in a series of lessons devoted to teaching you SQL.  We are going to install SQLite and then

Read More
How to Install SQLite and the Sample Database