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.
Add Records that Meet the Criteria before Each Group after Grouping — From SQL to SPL #39
judith677 profile

Add Records that Meet the Criteria before Each Group after Grouping — From SQL to SPL #39

#programming #database #esprocspl #sql
6
Comments 3
2 min read
Revolutionize Your Workflow: Boosting SQL Productivity with Copilot in SSMS 21
umeshtharukaofficial profile

Revolutionize Your Workflow: Boosting SQL Productivity with Copilot in SSMS 21

#webdev #sql #githubcopilot #beginners
Comments
4 min read
La Trampa de la Sobre-Normalización
yoezequiel profile

La Trampa de la Sobre-Normalización

#database #spanish #sql #programming
4
Comments 2
9 min read
🍰Top 10 Best Cake Shop Full-Stack Projects for Beginners in C#, ASP.NET, and .NET Core
sapanapal6 profile

🍰Top 10 Best Cake Shop Full-Stack Projects for Beginners in C#, ASP.NET, and .NET Core

#aspdotnet #csharp #sql #beginners
13
Comments
2 min read
How to Document SQL Server Schemas Visually in 2025
roxana_haidiner profile

How to Document SQL Server Schemas Visually in 2025

#sqlserver #sql #database #dataengineering
12
Comments 1
4 min read
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
Database optimization best practices
divyansh_gupta profile

Database optimization best practices

#postgressql #sql #database #productivity
Comments
3 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
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
👋 Sign in for the ability to sort posts by relevant, latest, or top.