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.
How Snowflake Copilot Inline Transformed My SQL Analysis Experience

How Snowflake Copilot Inline Transformed My SQL Analysis Experience

6
Comments 2
5 min read
🛡️ Understanding and Exploiting Blind SQL Injection

🛡️ Understanding and Exploiting Blind SQL Injection

Comments 1
3 min read
EF Query vs SQL View in Entity Framework – Which One Would You Choose?

EF Query vs SQL View in Entity Framework – Which One Would You Choose?

Comments 1
3 min read
Is This a Refreshing Way to Understand Association?

Is This a Refreshing Way to Understand Association?

6
Comments 1
7 min read
Understanding Database Indexes: A Library Analogy

Understanding Database Indexes: A Library Analogy

Comments
4 min read
Oracle AI Database 26ai — Applying Grid Infrastructure Patches via GUI(Zero-Downtime)

Oracle AI Database 26ai — Applying Grid Infrastructure Patches via GUI(Zero-Downtime)

Comments 1
4 min read
Your PostgreSQL Command Cheat Sheet (But Way More Useful!)

Your PostgreSQL Command Cheat Sheet (But Way More Useful!)

3
Comments
6 min read
The SQL Courtroom: DELETE vs TRUNCATE vs DROP (A Comic for Learners)

The SQL Courtroom: DELETE vs TRUNCATE vs DROP (A Comic for Learners)

Comments
1 min read
Perbedaan Antara SOQL dan SOSL di Salesforce

Perbedaan Antara SOQL dan SOSL di Salesforce

Comments
1 min read
PlanetScale vs. ⚔ Neon: the Continued Saga between MySQL 🐬 and PostgreSQL 🐘

PlanetScale vs. ⚔ Neon: the Continued Saga between MySQL 🐬 and PostgreSQL 🐘

6
Comments
9 min read
MySQL Timeout 🐬⏰ Explained

MySQL Timeout 🐬⏰ Explained

5
Comments
5 min read
SQL Injection: A Deep Dive into a Persistent Vulnerability

SQL Injection: A Deep Dive into a Persistent Vulnerability

Comments
4 min read
Demystifying Relational Algebra in DBMS: Operators Explained (with SQL Examples)

Demystifying Relational Algebra in DBMS: Operators Explained (with SQL Examples)

Comments
6 min read
Count Date Ranges per Year — From SQL to SPL #23

Count Date Ranges per Year — From SQL to SPL #23

8
Comments 1
2 min read
Using SQL for data analysis seems to be a false proposition

Using SQL for data analysis seems to be a false proposition

9
Comments 7
6 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.