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.
SQL Made Easy: A Tutorial for Beginners

SQL Made Easy: A Tutorial for Beginners

1
Comments
4 min read
5 SQL Queries Everyone Should Know

5 SQL Queries Everyone Should Know

6
Comments 1
2 min read
Getting Started with SQL: The Language of Data

Getting Started with SQL: The Language of Data

1
Comments
3 min read
SQL For Data Analytics in a Nutshell

SQL For Data Analytics in a Nutshell

4
Comments
5 min read
Number Non-Null Values in Order within the Group — From SQL to SPL #17

Number Non-Null Values in Order within the Group — From SQL to SPL #17

6
Comments 1
2 min read
Hashing in Presto/Athena

Hashing in Presto/Athena

1
Comments
1 min read
Oracle AI Database 26ai (23.7) — Materialized Expression Columns

Oracle AI Database 26ai (23.7) — Materialized Expression Columns

1
Comments
1 min read
How to Use SQL in Go

How to Use SQL in Go

Comments
6 min read
Features I Wish MySQL Had but Postgres 🐘 Already Has 😻

Features I Wish MySQL Had but Postgres 🐘 Already Has 😻

5
Comments 2
5 min read
How to check the same status of data in each row within a group with esProc

How to check the same status of data in each row within a group with esProc

6
Comments
2 min read
Top 10 AI Reporting Tools in 2025

Top 10 AI Reporting Tools in 2025

10
Comments
8 min read
Compression Algorithms You Probably Inherited: gzip, Snappy, LZ4, zstd

Compression Algorithms You Probably Inherited: gzip, Snappy, LZ4, zstd

8
Comments
4 min read
Optimizing SQL queries for your AI Agents.

Optimizing SQL queries for your AI Agents.

6
Comments
4 min read
How to Self-Host PostgreSQL (with Monitoring)

How to Self-Host PostgreSQL (with Monitoring)

1
Comments
2 min read
Ecto for Elixir: A Beginner's Guide to Database Interactions

Ecto for Elixir: A Beginner's Guide to Database Interactions

1
Comments
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.