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
danielhe4rt profile

Database 101: Data Consistency for Beginners

#beginners #database #sql #architecture
478
Comments 44
7 min read
Mastering SQL: Comprehensive Guide To Structured Query Language
louaiboumediene profile

Mastering SQL: Comprehensive Guide To Structured Query Language

#webdev #programming #sql #database
176
Comments 7
5 min read
Advanced SQL: Mastering Query Optimization and Complex Joins
bilelsalemdev profile

Advanced SQL: Mastering Query Optimization and Complex Joins

#sql #performance #programming #database
265
Comments 19
7 min read
The Top 10 GitHub Repositories Making Waves 🌊📊
arjuncodess profile

The Top 10 GitHub Repositories Making Waves 🌊📊

#github #programming #sql #productivity
87
Comments 8
4 min read
Conway's game of life...in pure SQL [Postgres]! 💪🏼🤯
grahamthedev profile

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

#postgres #sql #webdev #programming
87
Comments 20
9 min read
Secret To Optimizing SQL Queries - Understand The SQL Execution Order 🚀
kanani_nirav profile

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

#sql #optimization #performance #beginners
98
Comments 2
5 min read
CRUD and SQL - the basics!
grahamthedev profile

CRUD and SQL - the basics!

#webdev #sql #beginners #programming
64
Comments 9
5 min read
Awesome SQL Code Review Tools for Developers
surajondev profile

Awesome SQL Code Review Tools for Developers

#sql #codequality #beginners #webdev
104
Comments 6
4 min read
Simplify Complex SQL Queries with Common Table Expressions (CTEs)
karishmashukla profile

Simplify Complex SQL Queries with Common Table Expressions (CTEs)

#database #postgres #sql #performance
91
Comments 16
2 min read
Why you should never use an UUID as the primary key in SQL Databases
frederik_vl profile

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

#sql
104
Comments 66
2 min read
Database Naming Standards
ovid profile

Database Naming Standards

#techtalks #database #sql
342
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
rap2hpoutre profile

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

#webdev #programming #sql #postgres
211
Comments 32
2 min read
Creating a SQL generator app with ChatGPT, PostgreSQL, and ToolJet
tejakummarikuntla profile

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

#sql #tooljet #javascript #chatgpt
90
Comments 17
7 min read
True Alphanumeric / natural sorting in MySQL - why is the answer always recursion?
grahamthedev profile

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

#mysql #sql #webdev #programming
35
Comments 7
4 min read
SQL JOIN explained
leandronsp profile

SQL JOIN explained

#sql #database #postgres
75
Comments 4
13 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.