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.

Mr Punk da Silva

Jul 23 '25

Hackerrank - SQL - Weather Observation Station

#sql #learning

1 min read

Cristian Sifuentes

Jul 22 '25

Become a SQL Scientist: Explore Every Layer of Table Metadata in SQL Server

#sql #sqlserver #database #backend

3 min read

Cristian Sifuentes

Jul 22 '25

How to Discover Every Foreign Key That References a Table in SQL Server — Like a Data Scientist

#database #sql #sqlserver #computerscience

3 min read

Apache SeaTunnel

Jun 18 '25

How to Build Real-Time Data Pipelines with SQL Server CDC and Apache SeaTunnel

#programming #cdc #seatunnel #sql

2 min read

Mr Punk da Silva

Jul 21 '25

Hackerrank - SQL - Select By ID

#hackerrank #sql #beginners #learning

1 min read

Mr Punk da Silva

Jul 21 '25

Hackerrank - SQL - The PADS

#sql #beginners #database #hackerrank

2 min read

Mr Punk da Silva

Jul 21 '25

Hackerrank - SQL - Revising the Select Query II

#sql #learning #beginners #hackerrank

1 min read

Jul 21 '25

Building a Sales Analytics Dashboard on Azure PostgreSQL + Azure Data Studio

#postgressql #sql #azure #database

3 min read

Jul 21 '25

Mastering Automation: 5 Real-World n8n Workflow Examples (With Step-by-Step Guides)

#sql #programming

4 min read

Vinicius Fagundes

Jul 20 '25

🧱 OLTP vs OLAP: When Transaction Meets Analytics

#datafoundation #dataengineering #ai #sql

2 min read

Roxana Maria Haidiner

Jul 18 '25

SQL Server 2025 - What’s New and How to Visualize the Schema

#sqlserver #database #sql #dataengineering

7 min read

Jul 18 '25

SQL CASE Statements: The Order Matters!

#sql #database #dataengineering #python

2 min read

Python Tutorial

Jun 14 '25

Learn SQL Fast: A Step-by-Step Tutorial for Beginners

#sql #sqltutorial

3 min read

Roxana Maria Haidiner

Jul 17 '25

Database Design Errors to Avoid & How To Fix Them

#database #sql #mysql #dataengineering

5 min read

Aug 19 '25

Remember to set the frequency for replication to Litestream!

#ruby #sqlite #sql #backup

1 min read

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