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.
🔧 Embed SQL Editor ✍️ in Your Internal Web Portal 💻
op3ratordec profile

🔧 Embed SQL Editor ✍️ in Your Internal Web Portal 💻

#sql #web #database #tutorial
11
Comments
5 min read
How to remove duplicates in Postgres SQL
tresorama profile

How to remove duplicates in Postgres SQL

#sql #webdev #javascript #beginners
Comments
4 min read
The Importance of Minimizing Database Queries in Backend Development
yasserelgammal profile

The Importance of Minimizing Database Queries in Backend Development

#webdev #laravel #php #sql
Comments
1 min read
Top 8 Free Database Design Tools for 2025
roxana_haidiner profile

Top 8 Free Database Design Tools for 2025

#beginners #database #sql #learning
11
Comments 3
6 min read
SQL Admin Scripts: A Practical Toolkit for Managing Servers and Databases
seanmdrew profile

SQL Admin Scripts: A Practical Toolkit for Managing Servers and Databases

#sql #sqlserver
7
Comments
9 min read
Mastering SQLMap Tamper Scripts: The Ultimate Guide to Evading WAFs Like a Pro [Must Read Article]
trixsec profile

Mastering SQLMap Tamper Scripts: The Ultimate Guide to Evading WAFs Like a Pro [Must Read Article]

#sql #learning #cybersecurity #tutorial
7
Comments
3 min read
Transforming Nested JSON into Usable Data with SQL CROSS APPLY
seanmdrew profile

Transforming Nested JSON into Usable Data with SQL CROSS APPLY

#sql #sqlserver
2
Comments
3 min read
Data Engineer as a Real-Time Algo Trader – Turning Pipelines into Profit (or at Least Trying)!
datasosneh profile

Data Engineer as a Real-Time Algo Trader – Turning Pipelines into Profit (or at Least Trying)!

#sql #python #dataengineering #eventdriven
2
Comments
13 min read
Simple SQL Statements Only Exist in Coursebooks and Training Courses
esproc_spl profile

Simple SQL Statements Only Exist in Coursebooks and Training Courses

#sql #development #programming #devops
6
Comments
7 min read
Day 5 of SQL Series || Operators , Wildcards and Aggregate Functions
akshat0610 profile

Day 5 of SQL Series || Operators , Wildcards and Aggregate Functions

#tutorial #sql #beginners #mysql
6
Comments
4 min read
PostgreSQL CSV Import and Export Guide
chihebabiza profile

PostgreSQL CSV Import and Export Guide

#tutorial #sql #database #programming
1
Comments
1 min read
Understanding Transaction Isolation Levels in PostgreSQL
chihebabiza profile

Understanding Transaction Isolation Levels in PostgreSQL

#sql #database #postgres #tutorial
1
Comments 1
2 min read
Selecting the Right Database for the Job
rapp2043 profile

Selecting the Right Database for the Job

#rdbs #database #sql #nosql
8
Comments 1
6 min read
Aurora DSQL: Create a Serverless Cluster and Connect with PostgreSQL Client
franckpachot profile

Aurora DSQL: Create a Serverless Cluster and Connect with PostgreSQL Client

#aws #postgres #distributed #sql
11
Comments
5 min read
Mastering SQL: A Comprehensive Roadmap for Beginners (Part I)
aymanebenhima profile

Mastering SQL: A Comprehensive Roadmap for Beginners (Part I)

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