SQL

Semi, Anti, and Natural Joins in DuckDB SQL

Exploring three more elegant SQL Joins.

Oct 4 •

Use SQL "NOT IN" With Caution

An unexpected error that can take hours to debug.

Aug 15 •

GROUPING SETS in SQL

A lesser-known way to run multiple aggregations.

Jul 28 •

Grouping Sets, Rollup and Cube in SQL

Three lesser-known grouping operations.

May 25 •

15 Pandas ↔ Polars ↔ SQL ↔ PySpark Translations

Become a Quadrilingual Data Scientist.

Feb 13 •

What are Semi, Anti, and Natural Joins in SQL?

Exploring three more elegant SQL Joins.

Feb 11 •

Deepnote: The AI-Powered Jupyter Notebook That Data Scientists Were Looking For

A 20x better Jupyter notebook experience.

Jan 8 •

A Silent Mistake That Many SQL Users Commit and Take Hours to Debug

...and 2 ways to avoid it.

Jan 5 •

GROUPING SETS — A HIGHLY Underrated Technique to Run Multiple Aggregations While Scanning the Table Only Once

A lesser-known and much efficient way to run multiple aggregations.

Dec 9, 2023 •

Vanna: The Supercharged Text-to-SQL Tool All Data Scientists Were Looking For

Write complex SQL in seconds.

Oct 19, 2023 •

Become a Trilingual Data Scientist with These 15 Pandas ↔ Polars ↔ SQL Translations

Pandas to Polars to SQL translations in a single frame.

Oct 13, 2023 •

Become A Bilingual Data Scientist With These Pandas to SQL Translations

Most common Pandas operations and their SQL translations in one frame.

Apr 25, 2023 •

#nojs-banner { position: fixed; bottom: 0; left: 0; padding: 16px 16px 16px 32px; width: 100%; box-sizing: border-box; background: red; color: white; font-family: -apple-system, "Segoe UI", Roboto, Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"; font-size: 13px; line-height: 13px; } #nojs-banner a { color: inherit; text-decoration: underline; } This site requires JavaScript to run correctly. Please turn on JavaScript or unblock scripts