Tagged “sql”
7 entries.
Writing
6 JOIN Types Explained
Left, right, inner, full, left anti and right anti joins, each shown in Power Query and in SQL.
#sql #power-query #data-analysis
SCD Types Explained: Which Slowly Changing Dimension Fits Your Table
A practical breakdown of SCD Type 0 through Type 6, how each one works, what it costs, and which situations call for it.
#data-engineering #sql
Setting up a local SQL playground with DBeaver
How to set up two local databases, a SQLite file and a real running PostgreSQL server, so you can practice any SQL command without touching anything that actually matters.
#sql #database
Window functions, explained without the jargon
Running totals, rankings and "compare each row to its group" — all without a self join.
#sql #tutorial
dbt for people who already know SQL
If you can write a SELECT, you are most of the way there. The rest is file layout and two macros.
#dbt #sql #data-engineering