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.

Data Tech Bridge

Feb 19

The Ultimate Guide to Databricks Data Engineer Associate Exam: Everything You Need to Know

#dataengineering #learning #sql #tutorial

40 min read

Feb 18

COALESCE in SQL: the “Don’t Let NULL Win” Function You’ll Use Everywhere

#sql #database #programming #dataengineering

2 min read

Mar 1

Real world considerations: MS-SQL vs PostgreSQL vs MySQL

#sql #mysql #postgres

12 min read

Matty Stratton for Tiger Data (Creators of TimescaleDB)

Mar 18

How Do PostgreSQL Indices Work, Anyways?

#postgres #database #performance #sql

6 min read

Apr 3

left join an effective satellite without duplicating rows (use a cte)

#datavault #sql #effectivesatellite #leftjoin

3 min read

Mar 21

Building a SQL Tokenizer and Formatter From Scratch — Supporting 6 Dialects

#sql #webdev #typescript #javascript

5 min read

Mar 13

Connecting power bi to SQL databases locally and through cloud service.

#sql #database #productivity #beginners

5 min read

Mar 23

SQL Query Optimization Guide

#database #sql #postgres #performance

5 min read

Feb 17

Zero-Downtime Schema Changes in SQL Server: The Reality Behind “Just Run the Migration”

#database #performance #sql #sre

6 min read

Mar 2

Adding NOT NULL Constraints to Existing PostgreSQL Columns Safely

#postgres #database #sql #backend

5 min read

Santhoshi Mary A

Mar 22

Number Guessing Game

#database #python #sql #tutorial

2 min read

Abdelrahman Adnan

Feb 16

# Module 4 Summary - Analytics Engineering with dbt

#analytics #dataengineering #sql #tutorial

2 min read

Abdelrahman Adnan

Feb 16

Part 3: Testing, Documentation & Deployment 🚀

#analytics #dataengineering #sql #tutorial

5 min read

Philip McClarence

Mar 2

PostgreSQL vs MongoDB in 2026: When to Choose SQL Over NoSQL

#database #mongodb #postgres #sql

12 min read

Feb 16

Solving MSSQL's 2100 Parameter Limit: From IN Clause to Cursor-Based Pagination

#backend #database #sql #typescript

4 min read

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