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 26

SQL Restaurant Kitchen ---Indexes and Partitions

#database #performance #sql

9 min read

Jan 21

SQL Dates Finally Made Sense: NOW, AGE, EXTRACT, and Why Time Is Weird

#sql #database #postgres #beginners

3 min read

Jan 19

Querying & Filtering in Oracle Databases: What Actually Clicked for Me As a Beginner

#oracle #sql #database #beginners

4 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 22

How SQL JOINs Finally Clicked for Me (and How They Can for You Too)

#database #sql #postgres #beginners

4 min read

Jan 20

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

#sql #postgres #database #beginners

3 min read

Franciele Stefani da Costa

Feb 10

Code is the execution. Thinking is the strategy.

#sql #dataengineering #mysql #developer

1 min read

Jan 19

Table Design: Database Fundamentals to Know as a Beginner

#sql #database #beginners #learning

4 min read

Jan 23

Old Oracle Joins vs ANSI JOINs: Why I Chose One and Stuck With It

#oracle #sql #database #beginners

2 min read

Jan 13

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

#database #postgres #beginners #sql

3 min read

Jan 26

ROLLUP vs CUBE: How I Finally Understood SQL Subtotals

#sql #postgres #database #beginners

3 min read

Jan 16

Learning Databases Beyond SQL: My First Day with Oracle Tables

#sql #oracle #beginners #database

3 min read

Feb 1

SQL Stored Procedures: From Hard‑Coded Logic to Reusable SQL

#database #postgres #sql #beginners

3 min read

Jan 22

The Day I Chose VARCHAR(255) and Regretted It: A PostgreSQL String Story

#postgres #database #performance #sql

8 min read

Feb 1

The Doctor's On-Call Shift solved with SQL Assertions

#oracle #sql #assertion #consistency

6 min read

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