#sql Development Tutorials & Tips | Roast Dev

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

How to Optimize SQL Queries for Speed and Efficiency

Efficient SQL performance is essential for fast data retrieval and reducing system load. The following tips provide practical strategies, from proper indexing to analyzing execution plans to optimize ...

31.03.2025 0 Read More

Como bancos de dados realmente salvam os dados

A fonte de armazenamento primária de um banco de dados é um disco não-volátil. Não-volátil significa que, mesmo após desligado, ele retém tudo que foi salvo. Na memória volátil os dados são...

31.03.2025 0 Read More

How to simplify nested SQL in applications with esProc

In data analysis or reporting applications, various complex SQL statements are sometimes encountered: nested in multiple layers, self-join, dynamically transposing, …Here are some exmaples:From SQL ...

01.04.2025 0 Read More

Practical SQL Injection Exploitation Cheat Sheet - @verylazytech

Introduction SQL Injection (SQLi) remains one of the most dangerous vulnerabilities in web applications, allowing attackers to manipulate databases, extract sensitive data, and even gain remote access...

01.04.2025 0 Read More

DAY-7 PRIMARY KEY,FOREIGN KEY,INDEX,TRANSACTION

1. PRIMARY KEYA primary key is a column (or a set of columns) that uniquely identifies each row in a table. It enforces uniqueness and not-null constraints.Example:CREATE TABLE users ( id SERIAL P...

01.04.2025 0 Read More

How Indexes Really Work

Alright, we know indexes make databases faster. But why? It's not just magic; it's about efficiently navigating the way data is physically stored and reducing the amount of work the database has to do...

01.04.2025 0 Read More

Calculate all the year/months included in the year/month interval — From SQL to SPL #15

Problem description & analysis: The second and third fields of a certain database table are the starting year/month, and the ending year/month, respectively, in the format of “year M mo...

01.04.2025 0 Read More

Postgres 🐘 vs. SQL Server: a Complete Comparison ⚖️ in 2025

This post is maintained by Bytebase, an open-source database DevSecOps tool that can manage both Postgres and SQL Server. We update the post every year. Update History Comment 2025/03/26 Initi...

01.04.2025 0 Read More

I Will Teach You SQL in 3 Minutes

SQL, or Structured Query Language, is a powerful tool for managing and manipulating data in relational databases. Whether you're running an online store, analyzing social media trends, or generating r...

01.04.2025 0 Read More

DAY-8 PSQL, Difference Function vs. Procedure

Difference Between Function and Procedure in PSQLExample of a Function in PSQLA function that returns the sum of two numbers:CREATE FUNCTION add_numbers(a INT, b INT) RETURNS INT AS $$ BEGIN RETU...

02.04.2025 0 Read More

How to Optimize SQL Queries for Speed and Efficiency

Como bancos de dados realmente salvam os dados

How to simplify nested SQL in applications with esProc

Practical SQL Injection Exploitation Cheat Sheet - @verylazytech

DAY-7 PRIMARY KEY,FOREIGN KEY,INDEX,TRANSACTION

How Indexes Really Work

Calculate all the year/months included in the year/month interval — From SQL to SPL #15

Postgres 🐘 vs. SQL Server: a Complete Comparison ⚖️ in 2025

I Will Teach You SQL in 3 Minutes

DAY-8 PSQL, Difference Function vs. Procedure

#reading

#popular