SQL Subqueries
Subqueries (also known as inner queries or nested queries) are a tool for performing operations in multiple steps. […]
Database
SQL GROUP BY HAVING
Summarizing tables with GROUP BY is very common and a must-have skill for the data analyst. This post […]
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 […]
T-SQL Tables and Row Count
You are exploring a database in SQL Server using SSMS. You need a script that simply reports the […]
Chinook Database
The Chinook Database is a sample database available for several database products, including SQL Server, PostgreSQL, MySQL, Oracle, […]
SQL Select Into
The SELECT INTO statement copies data from one table into a new table. Here’s the syntax for copying […]
SQL Update From Another Table
We want to add a new column to our Orders table and put the product name into that […]