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 9

I Built a PostgreSQL User Analytics System — Here’s What I Learned About Real SQL

#postgres #beginners #database #sql

3 min read

Cooper D

Dec 7 '25

The Deterministic Problem with Probabilistic AI Analytics

#ai #sql #deterministic #nlp

7 min read

Jan 9

SQL Pattern Matching As A Beginner (LIKE, ILIKE, IN, BETWEEN)

#sql #postgres #beginners #database

3 min read

Dec 9 '25

Best SQL Courses with Certificates for 2026

#sql #sqlcertificates #sqlcertification #learnsql

7 min read

Jan 9

Learning SQL Subqueries as a Beginner: What Made Sense and What Didn’t

#sql #database #beginners #postgres

3 min read

Jan 8

Deploy: Cenário: Azure App Service + Github + SQL Server

#azure #devops #github #sql

5 min read

Dec 4 '25

SQL: Doing GROUP BY in CsvPath

#sql #dataengineering #csv #csvpath

5 min read

Yukti Sahu

Jan 8

SQL WHERE Clause: I Thought I Knew It… Until It Asked Me About LIKE 😭

#beginners #webdev #programming #sql

3 min read

Jan 7

Practicing SQL with Real Data: INSERT, WHERE, ORDER BY, and GROUP BY

#database #sql #postgres #beginners

3 min read

Amar Abaz

Jan 7

Craft and Control Resource Pools on MSSQL

#sqlserver #sql #databas #tutorial

3 min read

Li

Dec 16 '25

Subquery to GROUP JOIN — A Method for Merging Multiple Subqueries

#database #performance #sql #tutorial

5 min read

Jan 7

Learning SQL in Practice: LeetCode Challenges and Setting Up PostgreSQL

#sql #postgres #database #beginners

3 min read

Dec 3 '25

dev14

#backend #database #sql

1 min read

Dec 3 '25

step6

#automation #database #sql

1 min read

Dec 3 '25

step3

#database #sql #tutorial

2 min read

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