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.
Entity Framework Core | Object Relation Mapping | C# | A Beginner's Guide : Mastering

Entity Framework Core | Object Relation Mapping | C# | A Beginner's Guide : Mastering

5
Comments
3 min read
Day 7 of SQL Series || Keys

Day 7 of SQL Series || Keys

5
Comments
5 min read
# 揭秘Proof of SQL:让数据验证变得高效又安全

# 揭秘Proof of SQL:让数据验证变得高效又安全

Comments
1 min read
How I Completed My First SQL Project (And What I Learned)

How I Completed My First SQL Project (And What I Learned)

Comments
3 min read
Everyone Uses Postgres… But Why?

Everyone Uses Postgres… But Why?

1
Comments
9 min read
ACID Properties in Databases - Part 2: Your Shield Against Transactional Chaos

ACID Properties in Databases - Part 2: Your Shield Against Transactional Chaos

8
Comments
5 min read
Day 6 of SQL Series || Alter Table, Order By, NULL Values

Day 6 of SQL Series || Alter Table, Order By, NULL Values

7
Comments
3 min read
Front-End to Full-Stack Journey Part 1: Planning My Attack

Front-End to Full-Stack Journey Part 1: Planning My Attack

Comments
4 min read
How to Monitor SQL Performance in Spring Boot

How to Monitor SQL Performance in Spring Boot

3
Comments
7 min read
Mental Health WebApp

Mental Health WebApp

10
Comments 1
1 min read
🔧 Embed SQL Editor ✍️ in Your Internal Web Portal 💻

🔧 Embed SQL Editor ✍️ in Your Internal Web Portal 💻

11
Comments
5 min read
How to remove duplicates in Postgres SQL

How to remove duplicates in Postgres SQL

Comments
4 min read
Database Normalization

Database Normalization

2
Comments
4 min read
Top 8 Free Database Design Tools for 2025

Top 8 Free Database Design Tools for 2025

10
Comments 3
6 min read
Mastering SQLMap Tamper Scripts: The Ultimate Guide to Evading WAFs Like a Pro [Must Read Article]

Mastering SQLMap Tamper Scripts: The Ultimate Guide to Evading WAFs Like a Pro [Must Read Article]

5
Comments
3 min read
SQL Admin Scripts: A Practical Toolkit for Managing Servers and Databases

SQL Admin Scripts: A Practical Toolkit for Managing Servers and Databases

7
Comments
9 min read
Transforming Nested JSON into Usable Data with SQL CROSS APPLY

Transforming Nested JSON into Usable Data with SQL CROSS APPLY

Comments
3 min read
Data Engineer as a Real-Time Algo Trader – Turning Pipelines into Profit (or at Least Trying)!

Data Engineer as a Real-Time Algo Trader – Turning Pipelines into Profit (or at Least Trying)!

2
Comments
13 min read
How Sequences used in Oracle SQL without AUTO_INCREMENT Keyword

How Sequences used in Oracle SQL without AUTO_INCREMENT Keyword

Comments 1
1 min read
Day 5 of SQL Series || Operators , Wildcards and Aggregate Functions

Day 5 of SQL Series || Operators , Wildcards and Aggregate Functions

6
Comments
4 min read
Understanding Transaction Isolation Levels in PostgreSQL

Understanding Transaction Isolation Levels in PostgreSQL

1
Comments 1
2 min read
PostgreSQL CSV Import and Export Guide

PostgreSQL CSV Import and Export Guide

1
Comments
1 min read
Selecting the Right Database for the Job

Selecting the Right Database for the Job

8
Comments 1
6 min read
Aurora DSQL: Create a Serverless Cluster and Connect with PostgreSQL Client

Aurora DSQL: Create a Serverless Cluster and Connect with PostgreSQL Client

9
Comments
5 min read
Mastering SQL: A Comprehensive Roadmap for Beginners (Part I)

Mastering SQL: A Comprehensive Roadmap for Beginners (Part I)

9
Comments 2
3 min read
loading...