SQL Temp Tables
Let’s discuss temporary tables in Microsoft’s T-SQL. Temporary tables have a hash (#) at the start of their […]
sql
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 […]
Excel Unique Function
The Excel UNIQUE function gives you all of the distinct values of a given range. All you need […]
SQL Update one Table from Another
Are you working with an SQL database where you need to copy data from one table to another? […]