SQL

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...

Back To Basics | Simplifying Complex Queries and Enhancing ReadabilityIn programming, it’s a typical practice to group instructions or statements in smaller and more manageable code blocks. This practice will likely be referred as...

ScenarioSay, We now have a table named “ARTICLES” that captures day by day view counts for various articles from 1st June 2023 to tenth June 2023. Each entry within the table represents a date,...

Let’s start with the query which was suggested by a Sports Analyst. Now and again, their analytics team must create a points table based on the full matches played between different teams.And that’s why...