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.
🚀 Seamless Data Magic: From Notion to Database with MCP Server & AI Agents

🚀 Seamless Data Magic: From Notion to Database with MCP Server & AI Agents

1
Comments 1
3 min read
SQL COALESCE in Postgres: A Simple Guide

SQL COALESCE in Postgres: A Simple Guide

13
Comments 7
3 min read
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
Step-by-Step Guide to Set Up a Cron Job to Run a Report

Step-by-Step Guide to Set Up a Cron Job to Run a Report

Comments
4 min read
Creating Reports to Find Missing Data During the Normalization Process in SQL

Creating Reports to Find Missing Data During the Normalization Process in SQL

Comments
3 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 23ai (23.7) — Materialized Expression Columns

Oracle 23ai (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
Getting Started with SQL: A Guide for Data Analysts

Getting Started with SQL: A Guide for Data Analysts

Comments 1
2 min read
Olake (Lakehouse)

Olake (Lakehouse)

Comments
2 min read
Apresentação do Repositório Dotnet Templates

Apresentação do Repositório Dotnet Templates

Comments
2 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
ORM vs ODM: What's the Difference and When to Use Them?

ORM vs ODM: What's the Difference and When to Use Them?

7
Comments
1 min read
Top 5 Alternative Data Career Paths (And How to Learn Each for Free)

Top 5 Alternative Data Career Paths (And How to Learn Each for Free)

Comments 2
4 min read
Backup (and restore) an Sql database inside a docker container.

Backup (and restore) an Sql database inside a docker container.

Comments
1 min read
10 SQL Anti-Patterns You Must Avoid in Production

10 SQL Anti-Patterns You Must Avoid in Production

2
Comments
2 min read
SQL Join Dark Arts: Anti Joins, Semi Joins, and Beyond

SQL Join Dark Arts: Anti Joins, Semi Joins, and Beyond

Comments
2 min read
Transforming Rows to Columns and Back: SQL PIVOT/UNPIVOT Techniques

Transforming Rows to Columns and Back: SQL PIVOT/UNPIVOT Techniques

1
Comments
2 min read
Working with JSON in PostgreSQL, MySQL & SQL Server

Working with JSON in PostgreSQL, MySQL & SQL Server

1
Comments
2 min read
Think in Sets: Writing High-Performance SQL the Declarative Way

Think in Sets: Writing High-Performance SQL the Declarative Way

Comments
2 min read
Querying the Past: Temporal Tables in SQL Server and PostgreSQL

Querying the Past: Temporal Tables in SQL Server and PostgreSQL

1
Comments
2 min read
loading...