Skip to content
Navigation menu
Search
Powered by
Search
Algolia
Log in
Create account
DEV Community
Close
select * from SQL
Follow
Hide
Posts on tips and tricks, using and learning about SQL for database development and analysis.
Posts
Left menu
đź‘‹
Sign in
for the ability to sort posts by
relevant
,
latest
, or
top
.
Right menu
Best Oracle Database Design Tools in 2025
Roxana Maria Haidiner
Roxana Maria Haidiner
Roxana Maria Haidiner
Follow
Jun 17
Best Oracle Database Design Tools in 2025
#
oracle
#
sql
#
database
#
webdev
8
 reactions
Comments
2
 comments
7 min read
Beginner’s Guide to SQL Server Stored Procedures
Michael Gokey
Michael Gokey
Michael Gokey
Follow
Jun 17
Beginner’s Guide to SQL Server Stored Procedures
#
storedprocedures
#
database
#
sql
#
dba
Comments
Add Comment
5 min read
🔍 Mastering Blind SQL Injection with Out-of-Band (OAST) Techniques
AK
AK
AK
Follow
Jun 16
🔍 Mastering Blind SQL Injection with Out-of-Band (OAST) Techniques
#
webdev
#
cybersecurity
#
sql
#
code
Comments
Add Comment
1 min read
Add Records that Meet the Criteria before Each Group after Grouping — From SQL to SPL #39
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
Jun 16
Add Records that Meet the Criteria before Each Group after Grouping — From SQL to SPL #39
#
programming
#
database
#
esprocspl
#
sql
6
 reactions
Comments
2
 comments
2 min read
📚 Error-Based SQL Injection – A Deep Dive! 🎓🔍
AK
AK
AK
Follow
Jun 15
📚 Error-Based SQL Injection – A Deep Dive! 🎓🔍
#
programming
#
python
#
sql
#
webdev
Comments
Add Comment
4 min read
Oracle 23ai — Applying Grid Infrastructure Patches via GUI(Zero-Downtime)
Vahid Yousefzadeh
Vahid Yousefzadeh
Vahid Yousefzadeh
Follow
Jun 14
Oracle 23ai — Applying Grid Infrastructure Patches via GUI(Zero-Downtime)
#
oracle
#
database
#
devops
#
sql
Comments
Add Comment
4 min read
Understanding Query Cost in SQL
Samit Kapoor
Samit Kapoor
Samit Kapoor
Follow
Jun 14
Understanding Query Cost in SQL
#
sql
#
database
1
 reaction
Comments
Add Comment
7 min read
Learn SQL Fast: A Step-by-Step Tutorial for Beginners
Python Tutorial
Python Tutorial
Python Tutorial
Follow
Jun 14
Learn SQL Fast: A Step-by-Step Tutorial for Beginners
#
sql
#
sqltutorial
Comments
Add Comment
3 min read
Some Tips on SQL Usage in Spring
Andrew Kang-G
Andrew Kang-G
Andrew Kang-G
Follow
Jun 17
Some Tips on SQL Usage in Spring
#
spring
#
sql
#
java
#
webdev
1
 reaction
Comments
1
 comment
4 min read
$lookup: more than just a SQL join
Franck Pachot
Franck Pachot
Franck Pachot
Follow
Jun 17
$lookup: more than just a SQL join
#
mongodb
#
document
#
database
#
sql
2
 reactions
Comments
1
 comment
5 min read
MySQL — Removendo Full Only Group By no MacOS X
Jean Dias
Jean Dias
Jean Dias
Follow
Jun 17
MySQL — Removendo Full Only Group By no MacOS X
#
mysql
#
groupby
#
sql
#
osx
Comments
1
 comment
1 min read
EF Query vs SQL View in Entity Framework – Which One Would You Choose?
Vitalii Yavorskyi
Vitalii Yavorskyi
Vitalii Yavorskyi
Follow
Jun 16
EF Query vs SQL View in Entity Framework – Which One Would You Choose?
#
csharp
#
efcore
#
sql
#
dotnet
Comments
1
 comment
3 min read
HANDLING THE SAFE UPDATE MODE IN MYSQL
Elishiba Muigo
Elishiba Muigo
Elishiba Muigo
Follow
Jun 12
HANDLING THE SAFE UPDATE MODE IN MYSQL
#
mysql
#
sql
#
sqlserver
#
database
Comments
Add Comment
1 min read
From Natural Language to SQL: A Deep Dive with Ollama and Granite
Alain Airom
Alain Airom
Alain Airom
Follow
Jun 12
From Natural Language to SQL: A Deep Dive with Ollama and Granite
#
llm
#
granite
#
ollama
#
sql
Comments
Add Comment
8 min read
PostgreSQL Practical Labs: Error Handling, Advanced Data Types & Kali Linux Setup
Labby
Labby
Labby
Follow
for
LabEx
Jun 11
PostgreSQL Practical Labs: Error Handling, Advanced Data Types & Kali Linux Setup
#
postgres
#
database
#
labs
#
sql
Comments
Add Comment
3 min read
Count Distinct within Intervals in Order — From SQL to SPL #38
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks
Follow
Jun 12
Count Distinct within Intervals in Order — From SQL to SPL #38
#
programming
#
sql
#
database
#
esprocspl
6
 reactions
Comments
2
 comments
2 min read
🛡️ Examining the Database in SQL Injection Attacks
AK
AK
AK
Follow
Jun 14
🛡️ Examining the Database in SQL Injection Attacks
#
sql
#
hacktoberfest
#
cybersecurity
#
webdev
Comments
1
 comment
4 min read
From Redundancy to Reusability: A Better Way to Manage Shared Records in Relational Databases
Galisetty Priyatham
Galisetty Priyatham
Galisetty Priyatham
Follow
Jun 15
From Redundancy to Reusability: A Better Way to Manage Shared Records in Relational Databases
#
datamodeling
#
sql
Comments
1
 comment
1 min read
🧪 Exploiting Blind SQL Injection by Triggering Time Delays
AK
AK
AK
Follow
Jun 17
🧪 Exploiting Blind SQL Injection by Triggering Time Delays
#
webdev
#
python
#
sql
#
cybersecurity
Comments
1
 comment
3 min read
MySQL Tutorial: A Complete Guide to Mastering Database Management
Python Tutorial
Python Tutorial
Python Tutorial
Follow
Jun 13
MySQL Tutorial: A Complete Guide to Mastering Database Management
#
mysql
#
sql
#
tutorial
#
mysqltutorial
1
 reaction
Comments
Add Comment
3 min read
Building a Robust SQLite Query Builder in TypeScript: Lessons from an Arabic Dictionary App
Abdulwasiu Abdulmuize
Abdulwasiu Abdulmuize
Abdulwasiu Abdulmuize
Follow
Jun 6
Building a Robust SQLite Query Builder in TypeScript: Lessons from an Arabic Dictionary App
#
webdev
#
reactnative
#
react
#
sql
Comments
Add Comment
4 min read
🛡️ Understanding and Exploiting Blind SQL Injection
AK
AK
AK
Follow
Jun 16
🛡️ Understanding and Exploiting Blind SQL Injection
#
webdev
#
programming
#
cybersecurity
#
sql
Comments
1
 comment
3 min read
💡 Java Streams vs SQL – When to Use Which and Why
Hector Williams
Hector Williams
Hector Williams
Follow
Jun 9
💡 Java Streams vs SQL – When to Use Which and Why
#
java
#
sql
#
backend
1
 reaction
Comments
Add Comment
2 min read
Safeguarding Your PostgreSQL Data: A Practical Guide to pg_dump and pg_restore
Jing
