Livestream: Ducklake & The Future of Open Table Formats - June 17Register Now

Sign Up
BACK TO VIDEOS
YouTubeQuack & CodeSQL

Fixing SQL Spaghetti : Effective Refactoring Techniques

2024/06/13

Lindsay Murphy and Mehdi tackle a big challenge for data professionals: dealing with old SQL scripts. How can we make messy SQL code easier to read and maintain? We'll discuss pragmatics things you can do, and we'll tackle an example.

Related Videos

"Instant SQL Mode - Real Time Feedback to Make SQL Data Exploration Fly" video thumbnail

2025-04-23

Instant SQL Mode - Real Time Feedback to Make SQL Data Exploration Fly

Hamilton Ulmer shares insights from MotherDuck's Instant SQL Mode, exploring how real-time query result previews eliminate the traditional write-run-debug cycle through client-side parsing and DuckDB-WASM caching.

SQL

Talk

MotherDuck Features

"Why web developers should care about analytical databases" video thumbnail

08:48

2024-12-11

Why web developers should care about analytical databases

You often start your web application with an OLTP database like Postgres, but should you crunch your analytics there? In this video, ‪Mehdi explains what OLAP databases are, when to use them, and more.

YouTube

Wasm

SQL

"A duck in the hand is worth two in the cloud" video thumbnail

33:49

2024-11-08

A duck in the hand is worth two in the cloud

What if I told you that you could complete a JSON parse and extract task on your laptop before a distributed compute cluster even finishes booting up?

YouTube

BI & Visualization

AI, ML and LLMs

SQL

Python

Talk

View all