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.
Design Your Database with dbdiagram.io (Beginner to Pro)
arafatweb profile

Design Your Database with dbdiagram.io (Beginner to Pro)

#database #mysql #sql #postgres
12
Comments
3 min read
SQL vs NoSQL? Why Not Both?
dct_technology profile

SQL vs NoSQL? Why Not Both?

#vectordatabase #sql #nosql #webdev
Comments 1
2 min read
PostgreSQL Branching: Xata vs. Neon vs. Supabase - Part 1
alexfrancoeur profile

PostgreSQL Branching: Xata vs. Neon vs. Supabase - Part 1

#postgres #database #sql
16
Comments
12 min read
What’s the Difference Between IS NULL and = NULL in a MySQL WHERE Clause?
ibrahimalanshor profile

What’s the Difference Between IS NULL and = NULL in a MySQL WHERE Clause?

#mysql #sql #database #data
2
Comments 2
1 min read
Database optimization best practices
divyansh_gupta profile

Database optimization best practices

#postgressql #sql #database #productivity
Comments
3 min read
SQL COALESCE Explained: Simplify NULL Handling in Queries
pythontutorial profile

SQL COALESCE Explained: Simplify NULL Handling in Queries

#sql #sqlcoalesce #coalescesql #programming
Comments
3 min read
ALTER TABLE ADD COLUMN in SQL: Syntax, Tips & Tools
dbvismarketing profile

ALTER TABLE ADD COLUMN in SQL: Syntax, Tips & Tools

#sql
Comments
2 min read
จัดการข้อมูล Mac Address ให้อยู่หมัดด้วย PostgreSQL
watchara-sukka profile

จัดการข้อมูล Mac Address ให้อยู่หมัดด้วย PostgreSQL

#postgres #network #sql
Comments
1 min read
A COMPREHENSIVE LOOK INTO SQL : - What a Beginner can learn
tiff_thua profile

A COMPREHENSIVE LOOK INTO SQL : - What a Beginner can learn

#sql #database #data #analytics
2
Comments
5 min read
How to Design a Relational Database Schema in 2025
roxana_haidiner profile

How to Design a Relational Database Schema in 2025

#database #sql #dataengineering #datastructures
17
Comments 1
8 min read
StrataScratch's Advanced 25 Hard SQL Questions
wildneutron profile

StrataScratch's Advanced 25 Hard SQL Questions

#sql #stratascratch #datascience #dataengineering
1
Comments
2 min read
Building a Smart Database Management Tool with AI Insights
akandee_ profile

Building a Smart Database Management Tool with AI Insights

#ai #programming #productivity #sql
Comments
4 min read
Automating SQL Reports Without Power BI or SSRS: A Lightweight Alternative
sqlman profile

Automating SQL Reports Without Power BI or SSRS: A Lightweight Alternative

#sql #automation #excel #powerbi
4
Comments 3
4 min read
OUTPUT Clause — Log, Sync, and Debug Like a Pro
hasansafwan profile

OUTPUT Clause — Log, Sync, and Debug Like a Pro

#softwareengineering #backenddevelopment #sql #sqlserver
Comments
6 min read
Segmented Accumulation by Condition — From SQL to SPL #30
judith677 profile

Segmented Accumulation by Condition — From SQL to SPL #30

#programming #database #sql #esprocspl
6
Comments 1
1 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.