DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Text-to-SQL from Scratch — Tutorial For Dummies (Using PocketFlow!)
zachary62 profile

Text-to-SQL from Scratch — Tutorial For Dummies (Using PocketFlow!)

#ai #beginners #python #sql
5
Comments
14 min read
Postgresql soft-delete strategies: balancing data retention
oddcoder profile

Postgresql soft-delete strategies: balancing data retention

#postgres #database #sql
Comments
3 min read
Convert LONG to LOB on import(26ai)
vahidusefzadeh profile

Convert LONG to LOB on import(26ai)

#oracle #sql #database #linux
1
Comments
2 min read
Statistics by time window: SPL VS SQL #16
esproc_spl profile

Statistics by time window: SPL VS SQL #16

#programming #devops #sql #esproc
6
Comments
3 min read
Deduplicate between an Uncertain Number of Columns — From SQL to SPL #21
judith677 profile

Deduplicate between an Uncertain Number of Columns — From SQL to SPL #21

#sql #database #programming #esprocsl
7
Comments 1
2 min read
Indexing in PostgreSQL: Pros, Cons, and Best Practices
mspilari profile

Indexing in PostgreSQL: Pros, Cons, and Best Practices

#postgres #database #backend #sql
2
Comments
3 min read
Database Normalization Summary
leonardsangoroh profile

Database Normalization Summary

#todayilearned #database #sql #databasedesign
1
Comments
1 min read
🔍 Data Cleaning Techniques Using SQL
mohammed_jobairhossain_c profile

🔍 Data Cleaning Techniques Using SQL

#datacleaning #sql #datapreparation #sqlqueries
2
Comments
1 min read
Essential SQL Commands: A Quick Reference Guide
dionarodrigues profile

Essential SQL Commands: A Quick Reference Guide

#webdev #mysql #database #sql
5
Comments
8 min read
🗃️ Introduction to Database Design: Concepts Every Beginner Should Know
vishnutejas profile

🗃️ Introduction to Database Design: Concepts Every Beginner Should Know

#database #sql #nosql
Comments
4 min read
SQL Joins Made Easy: INNER, OUTER, LEFT, RIGHT Joins
be11amer profile

SQL Joins Made Easy: INNER, OUTER, LEFT, RIGHT Joins

#learning #database #sql #developer
4
Comments 1
1 min read
Are SQL Joins Expensive?
nurulislamrimon profile

Are SQL Joins Expensive?

#sql #mysql #database #productivity
5
Comments
2 min read
I Made a Detective Game That Teaches You SQL
hristo2612 profile

I Made a Detective Game That Teaches You SQL

#sql #beginners #webdev #gamedev
1
Comments
2 min read
🗃️ Structured Query Language (SQL): The Backbone of Modern Databases 2025
srijan-xi profile

🗃️ Structured Query Language (SQL): The Backbone of Modern Databases 2025

#news #beginners #tutorial #sql
Comments
2 min read
Mastering SQLite: Efficient Database Management Tips
stealthstephen profile

Mastering SQLite: Efficient Database Management Tips

#sqlite #database #sql #softwaredevelopment
2
Comments
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.