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 Server COUNT DISTINCT
You can count the number of unique values in a column with COUNT DISTINCT. The Microsoft Press book […]
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 […]
BigQuery Introduction
BigQuery is a fully managed enterprise data warehouse that helps you manage and analyze your data with built-in […]
Big Data Introduction
What is big data? We can now collect and analyze data in ways that were impossible even a […]
SQL Update From Another Table
We want to add a new column to our Orders table and put the product name into that […]
SQL Add Column
What is the SQL statement that adds a column to an existing table? The SQL statement is the […]
SQL Update Statement
The UPDATE statement is used to modify the existing records in a table. The syntax is as follows. […]
Itzik Ben Gan’s Database
As a more complex and realistic example, let’s look at the database that Itzik Ben-Gan used in his […]