#sql Development Tutorials & Tips | Roast Dev

100daysofcode 100daysofdevops 100pay 10mistakes 10yearworkanniversary 11 11labs 11tly 11ty 127001

Number Non-Null Values in Order within the Group — From SQL to SPL #17

Problem description & analysis: After sorting a table in the Oracle database according to the first and second columns, the third column has non-null values. Task: Now we need to add a ca...

10.04.2025 0 Read More

Hashing in Presto/Athena

The following hashing function require any parameter string to be casted into varbinary first. The you can apply any hashing function and transform it into hex to be a string and lower it. SHA...

10.04.2025 0 Read More

The Ultimate SQL Tutorial for Beginners and Intermediate Learners

IntroductionIn today's data-driven world, understanding how to interact with databases is a valuable skill across many industries—whether you're in software development, data analysis, business inte...

11.04.2025 0 Read More

How to Enable Relationship Autoloading in Versions Before v12.8

A few days ago, Litvinchuk added the method withRelationshipAutoloading in #53655. As explained in the PR description, it checks the relationships you're calling and applies Auto Eager Loading to them...

11.04.2025 0 Read More

⚙️ SQL Patterns for Optimizing IoT Queries in TimescaleDB

IoT applications generate massive amounts of time-series data—millions of rows from thousands of sensors, often with unpredictable reporting intervals. As your dataset grows, queries that once took ...

11.04.2025 0 Read More

oracle 23ai - Control PDB Open Order

Question: If a CDB contains multiple PDBs, how can we control the order in which these PDBs open?Answer: Before Oracle 23ai, there was no direct solution for managing the order of PDB openings. Execut...

11.04.2025 0 Read More

GROUP BY in SQL: How to Aggregate and Analyze Data Efficiently

SQL Group By Introduction When working with databases, it's not enough to simply store and retrieve data—you also need to make sense of it. That’s where aggregation com...

12.04.2025 0 Read More

🔍 Understanding Clustered vs Non-Clustered Indexes in SQL Server

📌 What Are Indexes? Indexes help SQL Server quickly find rows in a table, just like an index in a book. There are two main types: Clustered Index: Sorts and stores the data rows physicall...

12.04.2025 0 Read More

Normalization: How to Structure Your Database for Efficiency

What is Normalization? Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity. By dividing data into smaller, related tables, normalization ensur...

12.04.2025 0 Read More

Master SQL with These Handy Tools, Tips, and Tricks

Learning SQL can feel overwhelming at first, but with the right resources, tools, and tricks, you can sharpen your skills and even have some fun along the way. Whether you're a beginner or an experien...

12.04.2025 0 Read More

Number Non-Null Values in Order within the Group — From SQL to SPL #17

Hashing in Presto/Athena

The Ultimate SQL Tutorial for Beginners and Intermediate Learners

How to Enable Relationship Autoloading in Versions Before v12.8

⚙️ SQL Patterns for Optimizing IoT Queries in TimescaleDB

oracle 23ai - Control PDB Open Order

GROUP BY in SQL: How to Aggregate and Analyze Data Efficiently

🔍 Understanding Clustered vs Non-Clustered Indexes in SQL Server

Normalization: How to Structure Your Database for Efficiency

Master SQL with These Handy Tools, Tips, and Tricks

#reading

#popular