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.

Jan 20

SQL Nulls Finally Made Sense: COALESCE, NULLIF, and Safer Calculations

#sql #postgres #database #beginners

3 min read

Amr Saafan for Nile Bits

Jan 21

PostgreSQL Dead Rows: The Ultimate Guide to MVCC, Database Bloat, Performance Degradation, and Long-Term Optimization

#postgres #postgressql #sql #database

7 min read

Jan 17

Columns & Data Types in Oracle: What Actually Stuck on Day 2 (As a Beginner)

#oracle #sql #beginners #database

3 min read

Jan 21

Subqueries vs JOINs: When to Use Each in SQL

#beginners #database #performance #sql

4 min read

Jan 20

SQL - PostgreSQL: Execution Order

#sql #postgres #dataengineering #database

5 min read

Jan 9

TIL: Blazing-fast correlated exists queries

#rails #performance #sql

1 min read

Jan 19

Table Design: Database Fundamentals to Know as a Beginner

#sql #database #beginners #learning

4 min read

Jan 20

Make Your Technical Tutorials Interactive with SQLize Embed

#sql #documentation #mariadb #postgressql

2 min read

Wolfgang Rathgeb

Dec 15 '25

How SQLite Replaced PostgreSQL as My First Choice

#sql #database #programming

4 min read

Jan 16

Learning Databases Beyond SQL: My First Day with Oracle Tables

#sql #oracle #beginners #database

3 min read

Akanle Tolulope

Dec 15 '25

From CSV to Insights: Analysing Walmart Sales with Python & PostgreSQL

#database #python #sql #beginners

2 min read

fosres

Jan 18

Week 5 Scripting Challenge: Secure Password Authentication

#challenge #security #python #sql

15 min read

Amar Abaz

Jan 18

Modular Approach to Database Performance and Maintainability

#sqlserver #filegroups #tutorial #sql

4 min read

Yukti Sahu

Dec 14 '25

5 Surprising Truths About Your SQL SELECT Query (And Why They Matter)

#tutorial #beginners #sql #database

4 min read

Jan 13

SQL Aggregations Finally Made Sense: GROUP BY, HAVING, MIN, MAX, AVG

#database #postgres #beginners #sql

3 min read

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