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.
Day 4: Inserting Data and Basic CRUD Operations

Day 4: Inserting Data and Basic CRUD Operations

Comments 1
3 min read
📘 Database Normalization Example (1NF 3NF) with SQL in Oracle Live SQL

📘 Database Normalization Example (1NF 3NF) with SQL in Oracle Live SQL

2
Comments
2 min read
Busca de um valor em todas as tabelas e colunas no PostgreSQL 🐘

Busca de um valor em todas as tabelas e colunas no PostgreSQL 🐘

Comments
2 min read
I turned CSS in a SQL Database

I turned CSS in a SQL Database

Comments 3
3 min read
TRANSACTIONS , DEADLOCKS AND LOG BASED RECOVERY

TRANSACTIONS , DEADLOCKS AND LOG BASED RECOVERY

2
Comments
2 min read
🚀 How I Learned That Thinking “Small” Can Save Hours of SQL Headaches

🚀 How I Learned That Thinking “Small” Can Save Hours of SQL Headaches

1
Comments
2 min read
MySQL Shutdown Unexpectedly: Causes and Fixes for Developers

MySQL Shutdown Unexpectedly: Causes and Fixes for Developers

Comments
2 min read
SQL Query Optimization for Beginners

SQL Query Optimization for Beginners

1
Comments 1
2 min read
Mangle: Google's Bold Take on Database Programming

Mangle: Google's Bold Take on Database Programming

5
Comments 1
2 min read
Ditch REST: How React + SQL + WebSockets Can Power Real-Time Apps Without the Overhead

Ditch REST: How React + SQL + WebSockets Can Power Real-Time Apps Without the Overhead

Comments
3 min read
Database Indexing: The Hidden Key to Application Speed

Database Indexing: The Hidden Key to Application Speed

1
Comments
2 min read
Relational vs Non-Relational Databases: Choosing the Right One for Your Dream Project 🚀

Relational vs Non-Relational Databases: Choosing the Right One for Your Dream Project 🚀

4
Comments
3 min read
Revolutionizing SQL Development with Oracle APEX AI Assistant

Revolutionizing SQL Development with Oracle APEX AI Assistant

6
Comments
2 min read
🗄️DB Performance 101: A Practical Deep Dive into Backend Database Optimization⚡

🗄️DB Performance 101: A Practical Deep Dive into Backend Database Optimization⚡

18
Comments 10
7 min read
SQL Database Concepts:

SQL Database Concepts:

Comments
1 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.