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.
PostgreSql Tasks - Interview Questions

PostgreSql Tasks - Interview Questions

2
Comments 1
5 min read
Neo4j vs. SQL: Unlocking the Power of Graph-Based Data Modeling 🚀

Neo4j vs. SQL: Unlocking the Power of Graph-Based Data Modeling 🚀

5
Comments
4 min read
The Best AI-Powered SQL Optimization Tools in 2025

The Best AI-Powered SQL Optimization Tools in 2025

1
Comments
4 min read
SQL PATTERNS : Pivot and Unpivot in SQL - Transforming Data Effectively

SQL PATTERNS : Pivot and Unpivot in SQL - Transforming Data Effectively

2
Comments 2
2 min read
Do Ordered Grouping and Aggregation within Groups — From SQL to SPL #1

Do Ordered Grouping and Aggregation within Groups — From SQL to SPL #1

6
Comments
2 min read
SQL fundamentals and databases

SQL fundamentals and databases

1
Comments
2 min read
Like IDE for SparkSQL: Support Pycharm! SparkSQLHelper v2025.1.1 released

Like IDE for SparkSQL: Support Pycharm! SparkSQLHelper v2025.1.1 released

Comments
1 min read
Prisma.js with MySQL

Prisma.js with MySQL

2
Comments
4 min read
Understanding Relationships in MySQL and Prisma

Understanding Relationships in MySQL and Prisma

1
Comments
4 min read
MySQL Commands Categorized

MySQL Commands Categorized

2
Comments
3 min read
SQL queries in golang text/template

SQL queries in golang text/template

Comments
2 min read
Introduction to SQL

Introduction to SQL

Comments
3 min read
Pagination in SQL: Because Who Wants to Load a Million Rows at Once?

Pagination in SQL: Because Who Wants to Load a Million Rows at Once?

Comments
5 min read
5 bước cơ bản để phân tích và tối ưu câu lệnh SQL

5 bước cơ bản để phân tích và tối ưu câu lệnh SQL

2
Comments
5 min read
Building a User Registration System in .NET Core & C#

Building a User Registration System in .NET Core & C#

4
Comments
2 min read
Multi Tenant Architecture in Software: What Is It and Its Databases Patterns

Multi Tenant Architecture in Software: What Is It and Its Databases Patterns

16
Comments 5
4 min read
Rails Self-Join Tables - Parent-Child Magic

Rails Self-Join Tables - Parent-Child Magic

Comments
3 min read
MariaDB to PostgreSQL: Lessons & Challenges

MariaDB to PostgreSQL: Lessons & Challenges

7
Comments
6 min read
SQL for Automating Data Pipelines with SQL & Python

SQL for Automating Data Pipelines with SQL & Python

Comments
3 min read
OLTP Explained: Speed, Integrity, and High Availability in Databases

OLTP Explained: Speed, Integrity, and High Availability in Databases

3
Comments 3
2 min read
Como Alterar o Nome do Seu SQL Server

Como Alterar o Nome do Seu SQL Server

Comments
1 min read
SQL Injection - In Just 5 Minutes!

SQL Injection - In Just 5 Minutes!

Comments
3 min read
PostgreSql Tasks - Case study:2

PostgreSql Tasks - Case study:2

4
Comments
2 min read
Find logged Microsoft SQL Server Messages

Find logged Microsoft SQL Server Messages

Comments
1 min read
How to Import/Export CSV file in pgAdmin

How to Import/Export CSV file in pgAdmin

1
Comments
3 min read
loading...