Skip to content

DEV Community

select * from SQL

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

👋 Sign in for the ability to sort posts by relevant, latest, or top.

Sep 22 '25

MySQL ALTER TABLE: A Developer’s Guide to Schema Changes

#sql #mysql

2 min read

Oct 14 '25

Find the difference

#sql #sqlserver

1 min read

Thushitha

Oct 4 '25

The Backbone of Database Reliability: Exploring ACID in Action with SQL Transactions A Step-by-Step Guide

#computerscience #database #tutorial #sql

3 min read

Thushitha

Oct 4 '25

Database Normalization in SQL — 1NF, 2NF, and 3NF Explained (Student–Course Case Study)

#sql #programming #tutorial #database

3 min read

Oct 1 '25

The First Production Performance Problem I Faced (and How I Solved It)

#performance #dotnet #beginners #sql

2 min read

Sep 24 '25

Comparative guide for SQL Subqueries vs CTEs vs Temp Tables vs Views vs Materialized Views in AWS Aurora

#sql #aws #aurora #database

5 min read

Hardik Kanajariya

Oct 23 '25

Day 5: Advanced SELECT Queries and JOINs

#postgres #sql #tutorial #database

3 min read

REMOTLY

Sep 19 '25

Building Trust in a Digital World: Why Transparency is Your Greatest Asset

#webdev #ai #database #sql

4 min read

Hardik Kanajariya

Oct 22 '25

Day 4: Inserting Data and Basic CRUD Operations

#postgres #sql #tutorial #beginners

3 min read

Baviya Varshini V

Oct 1 '25

📘 Database Normalization Example (1NF 3NF) with SQL in Oracle Live SQL

#database #tutorial #computerscience #sql

2 min read

Oct 21 '25

Busca de um valor em todas as tabelas e colunas no PostgreSQL 🐘

#postgres #postgressql #sql #braziliandevs

2 min read

Oct 21 '25

I turned CSS in a SQL Database

#showdev #css #sql #webdev

3 min read

Santhosh_M

Oct 1 '25

TRANSACTIONS , DEADLOCKS AND LOG BASED RECOVERY

#database #sql #tutorial #architecture

2 min read

Franciele Stefani da Costa

Sep 30 '25

🚀 How I Learned That Thinking “Small” Can Save Hours of SQL Headaches

#sql #dataengineering #learning #career

2 min read

Sep 18 '25

MySQL Shutdown Unexpectedly: Causes and Fixes for Developers

#mysql #sql

2 min read

👋 Sign in for the ability to sort posts by relevant, latest, or top.