SQL Joins with Superstore
In this post I’ll look at some SQL joins using Tableau’s Superstore database as inspiration. This is not […]
SQL
SQL Subqueries
Subqueries (also known as inner queries or nested queries) are a tool for performing operations in multiple steps. […]
SQL GROUP BY HAVING
Summarizing tables with GROUP BY is very common and a must-have skill for the data analyst. This post […]
SQL Temp Tables
Let’s discuss temporary tables in Microsoft’s T-SQL. Temporary tables have a hash (#) at the start of their […]
SQL COALESCE() Function
COALESCE() returns the first non-null value in the list. If you have a list of arguments that you […]
SQL Best Practices
When you write SQL queries it is important to follow company policies and be consistent because others will […]
SQL Introduction
SQL stands for Structured Query Language. SQL is a standard language for storing, manipulating, and retrieving data in […]
SQL Joins Introduction
For this post we assume you have some basic knowledge of SQL. A JOIN clause is used to […]
SQL Data Introduction
This post is based on the stairway series at SQL Server Central called Stairway to Data, by Joe […]