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.
SQL DATABASE

SQL DATABASE

Comments
1 min read
SQL Tricks: Generate Calendar Table

SQL Tricks: Generate Calendar Table

Comments
5 min read
Cracking the Code: Your First Steps with SQL! 💻

Cracking the Code: Your First Steps with SQL! 💻

Comments
4 min read
The "Expressive" protocol

The "Expressive" protocol

1
Comments
3 min read
How to Duplicate Rows in MySQL

How to Duplicate Rows in MySQL

Comments
2 min read
SQL CASE Statements: The Order Matters!

SQL CASE Statements: The Order Matters!

Comments
2 min read
Some Example SQL

Some Example SQL

Comments
6 min read
Database Design Errors to Avoid & How To Fix Them

Database Design Errors to Avoid & How To Fix Them

6
Comments
5 min read
Filtering Out Rows Using LEFT JOIN: A Clean Alternative to NOT IN

Filtering Out Rows Using LEFT JOIN: A Clean Alternative to NOT IN

Comments
3 min read
Data Science vs Business Analytics

Data Science vs Business Analytics

Comments
1 min read
SQL Commands

SQL Commands

Comments
2 min read
SQL CASE Statement Explained with Real-World Examples

SQL CASE Statement Explained with Real-World Examples

Comments
1 min read
Diving into RDBMS & Data Integrity

Diving into RDBMS & Data Integrity

1
Comments
10 min read
🌳💨 Tree queries slowing you down?

🌳💨 Tree queries slowing you down?

Comments
1 min read
The Ultimate SQL Tutorial: Learn to Query Like a Pro

The Ultimate SQL Tutorial: Learn to Query Like a Pro

Comments
4 min read
Querying a Nested Array with `elemMatch` in Amazon DocumentDB

Querying a Nested Array with `elemMatch` in Amazon DocumentDB

Comments
3 min read
SQL Indexing: Your Database's Secret Weapon for Speed 🚀

SQL Indexing: Your Database's Secret Weapon for Speed 🚀

Comments
4 min read
Django ORM: consultas complexas pt.2

Django ORM: consultas complexas pt.2

Comments
4 min read
Top Free ER Diagram Tools for PostgreSQL in 2025

Top Free ER Diagram Tools for PostgreSQL in 2025

6
Comments
7 min read
SQL REPLACE Function: Quick Guide with Real Examples

SQL REPLACE Function: Quick Guide with Real Examples

Comments
2 min read
Hackerrank - SQL - Occupations

Hackerrank - SQL - Occupations

Comments
2 min read
Using CASE to Sort ENUM Values in MySQL

Using CASE to Sort ENUM Values in MySQL

1
Comments
2 min read
Do you know what a distributed database is?

Do you know what a distributed database is?

Comments
2 min read
From Research to Production: How I Built a Customer Churn Prediction API That Actually Works

From Research to Production: How I Built a Customer Churn Prediction API That Actually Works

Comments
5 min read
SQL Expressions in Rust

SQL Expressions in Rust

1
Comments
3 min read
loading...