SQL

Unlocking the ability of SQL for data-driven decision-making48 min read·10 hours agoHere’s an interesting fact: do you already know when the SQL language was created? When it first appeared? I do! It was in...

Learn the best way to automate a each day data transfer process on Windows, from PostgreSQL database to a distant serverThe strategy of transfering files from one location to a different is clearly an...

Expert techniques to raise your evaluationThis story delves into advanced SQL techniques that can be useful for data science practitioners. On this piece, I'll provide an in depth exploration of expert-grade SQL queries I...

Unlocking the facility of huge language modelsIn this text, I'll examine how large language models (LLMs) can convert natural language into SQL, making query writing more accessible to non-technical users. The discussion will include...

A brand new tool makes it easier for database users to perform...

Feeling inspired to jot down your first TDS post? We’re at all times open to contributions from recent authors.Our collective attention has focused so intensely on LLMs previously 12 months or so, that it’s...

Transitioning from Pandas to Polars the straightforward way — by taking a pit stop at SQL.The key’s out! Polars is the most popular thing on the block, and everybody wants a slice 😎I recently...

Clustering: A straightforward technique to group similar rows and forestall unnecessary data processingIn my previous article, I explained the way to optimise SQL queries using partitioning:Now, I’m writing the sequel! (Dad joke, anyone?)This text...