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.
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
Understanding Transaction Isolation Levels in PostgreSQL
chihebabiza profile

Understanding Transaction Isolation Levels in PostgreSQL

#sql #database #postgres #tutorial
1
Comments 1
2 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
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
Oracle Database Fragmentation - How to reorg Tables / Indexes
abhilash8 profile

Oracle Database Fragmentation - How to reorg Tables / Indexes

#database #sql #fragmentation #oracle
18
Comments 2
3 min read
How to Manage Your SQL Server Database Effectively
auyeungdavid_2847435260 profile

How to Manage Your SQL Server Database Effectively

#database #sqlserver #sql #sqlserverdatabaseproject
6
Comments 1
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.