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.
normalization

normalization

Comments
2 min read
From JSONB to Bitmasks: Faster Flags & Cleaner RLS in Postgres with Go/TS

From JSONB to Bitmasks: Faster Flags & Cleaner RLS in Postgres with Go/TS

Comments
6 min read
Indexing, Hashing, and Query

Indexing, Hashing, and Query

Comments
1 min read
Transactions, Deadlocks & Log Based Recovery

Transactions, Deadlocks & Log Based Recovery

Comments
1 min read
MySQL Path: 4 Hands-On Challenges for Data Entry, User Management, Multi-Table Queries & Sales Analysis

MySQL Path: 4 Hands-On Challenges for Data Entry, User Management, Multi-Table Queries & Sales Analysis

Comments
2 min read
MySQL ALTER TABLE: A Developer’s Guide to Schema Changes

MySQL ALTER TABLE: A Developer’s Guide to Schema Changes

Comments
2 min read
Find the difference

Find the difference

3
Comments
1 min read
The Backbone of Database Reliability: Exploring ACID in Action with SQL Transactions A Step-by-Step Guide

The Backbone of Database Reliability: Exploring ACID in Action with SQL Transactions A Step-by-Step Guide

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
The First Production Performance Problem I Faced (and How I Solved It)

The First Production Performance Problem I Faced (and How I Solved It)

Comments
2 min read
Comparative guide for SQL Subqueries vs CTEs vs Temp Tables vs Views vs Materialized Views in AWS Aurora

Comparative guide for SQL Subqueries vs CTEs vs Temp Tables vs Views vs Materialized Views in AWS Aurora

1
Comments
5 min read
PostgreSQL Advanced Queries & Data Types: A Practical Guide to Robust Data Management

PostgreSQL Advanced Queries & Data Types: A Practical Guide to Robust Data Management

Comments
3 min read
Day 5: Advanced SELECT Queries and JOINs

Day 5: Advanced SELECT Queries and JOINs

Comments
3 min read
5 Steps to Optimize MySQL Deep Pagination

5 Steps to Optimize MySQL Deep Pagination

Comments
4 min read
Building Trust in a Digital World: Why Transparency is Your Greatest Asset

Building Trust in a Digital World: Why Transparency is Your Greatest Asset

Comments
4 min read
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
loading...