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.

Luca Liu

Dec 9 '25

Data Security in SQL: Encryption, Roles, and Permissions

#database #tutorial #sql #data

2 min read

Dec 9 '25

map

#database #dataengineering #sql

1 min read

osman uygar köse

Jan 12

Prompt Engineering a Barista: How SQLatte's Personality Transforms SQL into Conversations

#promptengineering #ai #sql #python

4 min read

Dec 8 '25

SQL 을 조금 더 알아보자

#database #sql #tutorial

1 min read

Rebooter.S

Jan 12

Beyond Nested Queries: A Practical Guide to SQL Subquery Flattening

#sql #mysql #ai #programming

5 min read

Vahid Yousefzadeh

Dec 8 '25

Mandatory Profile in Oracle Database

#oracle #linux #database #sql

3 min read

Amar Abaz

Jan 11

MSSQL Encryptions, Certificates, A-Symmetric Keys and more (Vol 1)

#sqlserver #database #encryption #sql

5 min read

JongHwa

Jan 10

[Simple SNS Project] Step 4. Search Implementation & Logging Strategy

#sql #database #springboot #java

1 min read

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

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