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.
How Generative AI Is Turning Natural Language Into SQL—And Changing Data Work

How Generative AI Is Turning Natural Language Into SQL—And Changing Data Work

Comments
4 min read
Learning SQL: The Language Behind Your Data

Learning SQL: The Language Behind Your Data

Comments
3 min read
DATABASE NORMALIZATION IN SQL - 1NF,2NF AND 3NF EXPLAINED (STUDENT - COURSE CASE STUDY

DATABASE NORMALIZATION IN SQL - 1NF,2NF AND 3NF EXPLAINED (STUDENT - COURSE CASE STUDY

Comments
3 min read
DB2 Pract (Packages, subqueries)

DB2 Pract (Packages, subqueries)

Comments
7 min read
Apache Ignite 3.1.0 is now available

Apache Ignite 3.1.0 is now available

Comments
2 min read
cursor

cursor

Comments
3 min read
TypedSql: Turning the C# Type System into a High-Performance SQL Query Engine

TypedSql: Turning the C# Type System into a High-Performance SQL Query Engine

4
Comments 1
17 min read
Fixing SQL Injection Vulnerabilities to Strengthen Security

Fixing SQL Injection Vulnerabilities to Strengthen Security

Comments 2
10 min read
Demystifying Normalization in RDBMS: From 1NF to 3NF

Demystifying Normalization in RDBMS: From 1NF to 3NF

Comments
5 min read
Understanding the Difference Between Subquery, CTE, and Stored Procedure

Understanding the Difference Between Subquery, CTE, and Stored Procedure

Comments
3 min read
🚀 Understanding Indexing in Oracle (B-Tree, B+ Tree, Hash Cluster) Indexes are one of the most important concepts in databases.

🚀 Understanding Indexing in Oracle (B-Tree, B+ Tree, Hash Cluster) Indexes are one of the most important concepts in databases.

Comments
3 min read
💾 ACID Properties

💾 ACID Properties

Comments
2 min read
📝 Understanding Transactions, Deadlocks & Log-Based Recovery in SQL 💾

📝 Understanding Transactions, Deadlocks & Log-Based Recovery in SQL 💾

1
Comments
2 min read
Similarities Between a Stored Procedure in SQL and a Function in Python

Similarities Between a Stored Procedure in SQL and a Function in Python

Comments
3 min read
TIL: Temp table vs CTE

TIL: Temp table vs CTE

1
Comments
1 min read
Understanding PL/SQL Collections: Associative Arrays, Nested Tables, and VARRAYs

Understanding PL/SQL Collections: Associative Arrays, Nested Tables, and VARRAYs

1
Comments
3 min read
isql

isql

Comments
1 min read
Building a Hybrid Site Generator with Go + SQLite

Building a Hybrid Site Generator with Go + SQLite

1
Comments
1 min read
AI-Driven SQL Dataset Optimization 202509: REEF&text2SQL4PM

AI-Driven SQL Dataset Optimization 202509: REEF&text2SQL4PM

1
Comments
4 min read
Free SQL courses for beginners in 2026

Free SQL courses for beginners in 2026

Comments
4 min read
Build a Customer Support AI Agent with smolagents + InterSystems IRIS (SQL, RAG & Interoperability)

Build a Customer Support AI Agent with smolagents + InterSystems IRIS (SQL, RAG & Interoperability)

Comments
5 min read
MySQL学习

MySQL学习

Comments
2 min read
Entendendo Flyway

Entendendo Flyway

Comments
2 min read
Understanding MySQL Backup Consistency: A Practical Example

Understanding MySQL Backup Consistency: A Practical Example

Comments
2 min read
Understanding Primary Keys in Relational Databases: A Key to Data Integrity and Fast Lookups

Understanding Primary Keys in Relational Databases: A Key to Data Integrity and Fast Lookups

2
Comments
3 min read
loading...