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.
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
Advanced SQL Part 1: Window Functions Explained with Precision

Advanced SQL Part 1: Window Functions Explained with Precision

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

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

Comments
4 min read
SQL Learning...

SQL Learning...

1
Comments 2
1 min read
Building a Data Career: The Skills That Truly Matter

Building a Data Career: The Skills That Truly Matter

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

SQL REPLACE Function: Quick Guide with Real Examples

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
Cursor in Database Management System (DBMS): Types, Properties, and Examples

Cursor in Database Management System (DBMS): Types, Properties, and Examples

4
Comments
6 min read
Why Large Language Models Love Graph Databases

Why Large Language Models Love Graph Databases

1
Comments 1
3 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
Hello Dev.to

Hello Dev.to

Comments
3 min read
Snowflake AI_TRANSCRIBE - Transform Audio to Insights with SQL in Seconds

Snowflake AI_TRANSCRIBE - Transform Audio to Insights with SQL in Seconds

2
Comments
9 min read
SQL ORDER BY: Quick Sorting Examples and Tips

SQL ORDER BY: Quick Sorting Examples and Tips

Comments
2 min read
CHECKSUM Function in Oracle 21c

CHECKSUM Function in Oracle 21c

Comments
2 min read
Sqlite3 module in python

Sqlite3 module in python

1
Comments
2 min read
What Is a Primary Key in SQL? Learn with Examples

What Is a Primary Key in SQL? Learn with Examples

7
Comments
3 min read
Free SQL Tool to Understand Your Database Visually

Free SQL Tool to Understand Your Database Visually

7
Comments
3 min read
Getting Started with Databases: SQL & MySQL

Getting Started with Databases: SQL & MySQL

1
Comments
9 min read
Supabase ⚡️ vs. Firebase 🔥: a Complete Comparison ⚔️ in 2025

Supabase ⚡️ vs. Firebase 🔥: a Complete Comparison ⚔️ in 2025

10
Comments
5 min read
How I Built a Hospital Patient Management System Using SQL

How I Built a Hospital Patient Management System Using SQL

1
Comments
2 min read
Outer Join Optimization: Proven Performance Gains

Outer Join Optimization: Proven Performance Gains

Comments
5 min read
Database Normalization and Denormalization

Database Normalization and Denormalization

Comments
5 min read
loading...