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.
Database 101: Data Consistency for Beginners

Database 101: Data Consistency for Beginners

467
Comments 44
7 min read
Mastering SQL: Comprehensive Guide To Structured Query Language

Mastering SQL: Comprehensive Guide To Structured Query Language

173
Comments 7
5 min read
Advanced SQL: Mastering Query Optimization and Complex Joins

Advanced SQL: Mastering Query Optimization and Complex Joins

264
Comments 19
7 min read
The Top 10 GitHub Repositories Making Waves 🌊📊

The Top 10 GitHub Repositories Making Waves 🌊📊

87
Comments 8
4 min read
Conway's game of life...in pure SQL [Postgres]! 💪🏼🤯

Conway's game of life...in pure SQL [Postgres]! 💪🏼🤯

87
Comments 20
9 min read
Secret To Optimizing SQL Queries - Understand The SQL Execution Order 🚀

Secret To Optimizing SQL Queries - Understand The SQL Execution Order 🚀

98
Comments 2
5 min read
CRUD and SQL - the basics!

CRUD and SQL - the basics!

64
Comments 9
5 min read
Awesome SQL Code Review Tools for Developers

Awesome SQL Code Review Tools for Developers

104
Comments 6
4 min read
Simplify Complex SQL Queries with Common Table Expressions (CTEs)

Simplify Complex SQL Queries with Common Table Expressions (CTEs)

91
Comments 16
2 min read
Why you should never use an UUID as the primary key in SQL Databases

Why you should never use an UUID as the primary key in SQL Databases

104
Comments 66
2 min read
Database Naming Standards

Database Naming Standards

331
Comments 21
6 min read
SQL tips for beginners; what I learned after 10+ years of occasionally writing queries and schemas as a web dev

SQL tips for beginners; what I learned after 10+ years of occasionally writing queries and schemas as a web dev

211
Comments 32
2 min read
Creating a SQL generator app with ChatGPT, PostgreSQL, and ToolJet

Creating a SQL generator app with ChatGPT, PostgreSQL, and ToolJet

90
Comments 17
7 min read
True Alphanumeric / natural sorting in MySQL - why is the answer always recursion?

True Alphanumeric / natural sorting in MySQL - why is the answer always recursion?

35
Comments 7
4 min read
SQL JOIN explained

SQL JOIN explained

75
Comments 4
13 min read
Guide To Choose A Database For Your Next Design

Guide To Choose A Database For Your Next Design

137
Comments 5
5 min read
Database GUIs in JavaScript

Database GUIs in JavaScript

189
Comments 13
5 min read
Database Tools 🛢️🔧 in 2024: A Year in Review 🗓️

Database Tools 🛢️🔧 in 2024: A Year in Review 🗓️

106
Comments 4
3 min read
Introduction to SQL for Absolute Beginners!

Introduction to SQL for Absolute Beginners!

61
Comments 11
4 min read
5 Essential SQL Skills Learned from a Decade of Experience

5 Essential SQL Skills Learned from a Decade of Experience

55
Comments 45
4 min read
Translating Database Queries

Translating Database Queries

110
Comments 3
3 min read
Should I use SQLite, PostgreSQL, or MySQL?

Should I use SQLite, PostgreSQL, or MySQL?

172
Comments 26
5 min read
Your Old Laptop Is Your New Database Server

Your Old Laptop Is Your New Database Server

166
Comments 12
8 min read
Improving Performance of PostgreSQL queries

Improving Performance of PostgreSQL queries

147
Comments 15
4 min read
SQL Complete guide for Interview

SQL Complete guide for Interview

56
Comments 7
13 min read
loading...