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.
🚀 Learning Update

🚀 Learning Update

1
Comments
1 min read
College Student & Course Management System

College Student & Course Management System

Comments
3 min read
Updates to the Same Value: MongoDB Optimization

Updates to the Same Value: MongoDB Optimization

2
Comments 1
7 min read
Data Modeling: From Basics to Advanced Techniques for Business Impact

Data Modeling: From Basics to Advanced Techniques for Business Impact

2
Comments
13 min read
From Indexes to GPUs: The Evolution of Database Optimization

From Indexes to GPUs: The Evolution of Database Optimization

Comments 1
3 min read
🎓 College Student & Course Management System with SQL (Step by Step)

🎓 College Student & Course Management System with SQL (Step by Step)

Comments
3 min read
How to Back Up and Restore MySQL Using mysqldump

How to Back Up and Restore MySQL Using mysqldump

Comments
2 min read
SQL Queries : College Student & Course Management System

SQL Queries : College Student & Course Management System

1
Comments
4 min read
The Equality Delete Problem in Apache Iceberg

The Equality Delete Problem in Apache Iceberg

Comments
9 min read
Why Your SQL Queries Are Slower Than a Sloth: Deep Dive Into Indexes You’re Probably Misusing

Why Your SQL Queries Are Slower Than a Sloth: Deep Dive Into Indexes You’re Probably Misusing

Comments
4 min read
SQL,PostgreSQL, Database RDBMS, Sql NoSql farqi

SQL,PostgreSQL, Database RDBMS, Sql NoSql farqi

Comments
4 min read
🦆 DuckDB: The SQLite of Analytics You Didn’t Know You Needed

🦆 DuckDB: The SQLite of Analytics You Didn’t Know You Needed

Comments
3 min read
College Student & Course Management System

College Student & Course Management System

Comments
3 min read
Day 4 Data Analytics Progress 📈

Day 4 Data Analytics Progress 📈

Comments
1 min read
filesql: SQL Driver for CSV, TSV, LTSV, Parquet, and Excel Files in Go

filesql: SQL Driver for CSV, TSV, LTSV, Parquet, and Excel Files in Go

1
Comments
3 min read
Part 1: MySQL 8.0 Optimizer Enhancements - SQL Query Optimization Deep Dive

Part 1: MySQL 8.0 Optimizer Enhancements - SQL Query Optimization Deep Dive

Comments
12 min read
History of NoSQL: The Data Management Revolution

History of NoSQL: The Data Management Revolution

9
Comments
4 min read
Day-88 Memory Management in Java

Day-88 Memory Management in Java

1
Comments
1 min read
🚀 Database Optimization: Proven Techniques to Speed Up Your Queries

🚀 Database Optimization: Proven Techniques to Speed Up Your Queries

Comments
3 min read
SQL with Real Life Example Explained - 2025

SQL with Real Life Example Explained - 2025

Comments
1 min read
Are SQL vs NoSQL Databases different? : Key Differences Every Developer Should Know

Are SQL vs NoSQL Databases different? : Key Differences Every Developer Should Know

Comments
1 min read
COLLEGE STUDENT & COURSE MANAGEMENT SYSTEM

COLLEGE STUDENT & COURSE MANAGEMENT SYSTEM

1
Comments
2 min read
Day 2: Data Analytics Progress📈

Day 2: Data Analytics Progress📈

Comments
1 min read
Why I Built an "Awesome List" for Data Analysis (And How It Can Help You)

Why I Built an "Awesome List" for Data Analysis (And How It Can Help You)

5
Comments
2 min read
👉 “Top 5 SQL Query Patterns Every Developer Should Know for Interviews”

👉 “Top 5 SQL Query Patterns Every Developer Should Know for Interviews”

Comments
1 min read
loading...