4 Powerful SQL Tricks Every Data Engineer Should Know

Description:
In this video I show you 4 powerful SQL tricks every data engineer should know CTEs, CASE WHEN, COALESCE, and ROW_NUMBER.
I demonstrate everything using real data directly in DBeaver with DuckDB.
If you don't have the environment set up yet, watch my previous video where I show how to install DBeaver and DuckDB in just a few minutes.
???? Subscribe for more data content.

CREATE TABLE customers AS
SELECT
i AS customer_id,
'Customer_' || i AS name,
['Kigali','Nairobi','Lagos','Accra'][CAST(floor(random()*4)+1 AS INT)] AS city,
DATE '2024-01-01' + (random()*365)::INT AS signup_date
FROM range(200) t(i);


CREATE TABLE orders AS
SELECT
i AS order_id,
floor(random()*200)::INT AS customer_id,
round(random()*500,2) AS amount,
DATE '2024-01-01' + (random()*365)::INT AS order_date
FROM range(2000) t(i);


CREATE TABLE payments AS
SELECT
i AS payment_id,
floor(random()*2000)::INT AS order_id,
round(random()*500,2) AS amount_paid,
DATE '2024-01-01' + (random()*365)::INT AS payment_date
FROM range(1500) t(i);