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.
Prompt Engineering a Barista: How SQLatte's Personality Transforms SQL into Conversations

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

1
Comments 1
4 min read
SQL 을 조금 더 알아보자

SQL 을 조금 더 알아보자

Comments
1 min read
Beyond Nested Queries: A Practical Guide to SQL Subquery Flattening

Beyond Nested Queries: A Practical Guide to SQL Subquery Flattening

Comments
5 min read
SQL vs NoSQL: The Ultimate Interview Guide to Choosing the Right Database (Simple Checklist Included)

SQL vs NoSQL: The Ultimate Interview Guide to Choosing the Right Database (Simple Checklist Included)

2
Comments
4 min read
Mandatory Profile in Oracle Database

Mandatory Profile in Oracle Database

Comments
3 min read
[Simple SNS Project] Step 4. Search Implementation & Logging Strategy

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

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

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

25
Comments 1
3 min read
The Deterministic Problem with Probabilistic AI Analytics

The Deterministic Problem with Probabilistic AI Analytics

Comments
7 min read
SQL Pattern Matching As A Beginner (LIKE, ILIKE, IN, BETWEEN)

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

20
Comments
3 min read
Best SQL Courses with Certificates for 2026

Best SQL Courses with Certificates for 2026

1
Comments
7 min read
Learning SQL Subqueries as a Beginner: What Made Sense and What Didn’t

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

25
Comments
3 min read
Deploy: Cenário: Azure App Service + Github + SQL Server

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

Comments
5 min read
SQL: Doing GROUP BY in CsvPath

SQL: Doing GROUP BY in CsvPath

Comments
5 min read
SQL WHERE Clause: I Thought I Knew It… Until It Asked Me About LIKE 😭

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

4
Comments
3 min read
Practicing SQL with Real Data: INSERT, WHERE, ORDER BY, and GROUP BY

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

25
Comments
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.