Forem

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 Normalization Summary

Database Normalization Summary

1
Comments
1 min read
🔍 Data Cleaning Techniques Using SQL
Cover image for 🔍 Data Cleaning Techniques Using SQL

🔍 Data Cleaning Techniques Using SQL

2
Comments
1 min read
Deploying a FastAPI + PostgreSQL App Using Google Cloud Run and Cloud SQL
Cover image for Deploying a FastAPI + PostgreSQL App Using Google Cloud Run and Cloud SQL

Deploying a FastAPI + PostgreSQL App Using Google Cloud Run and Cloud SQL

2
Comments
2 min read
🚀 Mastering Unit of Work in SQLAlchemy: Efficient Transactions in 2025

🚀 Mastering Unit of Work in SQLAlchemy: Efficient Transactions in 2025

Comments
1 min read
🚀 SQL Query Optimization in 2025: 7 Techniques for Faster Performance

🚀 SQL Query Optimization in 2025: 7 Techniques for Faster Performance

Comments
1 min read
How to Optimize SQLite Performance With Indexed Views and Write-Ahead Logging
Cover image for How to Optimize SQLite Performance With Indexed Views and Write-Ahead Logging

How to Optimize SQLite Performance With Indexed Views and Write-Ahead Logging

Comments
2 min read
Essential SQL Commands: A Quick Reference Guide
Cover image for Essential SQL Commands: A Quick Reference Guide

Essential SQL Commands: A Quick Reference Guide

5
Comments
8 min read
SQL Server for NoSQL

SQL Server for NoSQL

Comments
1 min read
Top 3 PostgreSQL Performance Issues: Diagnosis and Proven Solutions

Top 3 PostgreSQL Performance Issues: Diagnosis and Proven Solutions

1
Comments
5 min read
🗃️ Introduction to Database Design: Concepts Every Beginner Should Know

🗃️ Introduction to Database Design: Concepts Every Beginner Should Know

Comments
4 min read
Find the Closest Date Match for Each Record from Two Tables — From SQL to SPL #20
Cover image for Find the Closest Date Match for Each Record from Two Tables — From SQL to SPL #20

Find the Closest Date Match for Each Record from Two Tables — From SQL to SPL #20

6
Comments 1
2 min read
SQL Joins Made Easy: INNER, OUTER, LEFT, RIGHT Joins
Cover image for SQL Joins Made Easy: INNER, OUTER, LEFT, RIGHT Joins

SQL Joins Made Easy: INNER, OUTER, LEFT, RIGHT Joins

4
Comments 1
1 min read
Are SQL Joins Expensive?

Are SQL Joins Expensive?

5
Comments
2 min read
𝗛𝗼𝘄 𝘁𝗼 𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗶𝗰𝗮𝗹𝗹𝘆 𝗨𝗽𝗱𝗮𝘁𝗲 𝗦𝗽𝗲𝗻𝘁 𝗔𝗺𝗼𝘂𝗻𝘁 𝗶𝗻 𝗕𝘂𝗱𝗴𝗲𝘁 𝗨𝘀𝗶𝗻𝗴 𝗧𝗿𝗶𝗴𝗴𝗲𝗿𝘀 𝗶𝗻 𝗦𝗤𝗟 𝗦𝗲𝗿𝘃𝗲𝗿

𝗛𝗼𝘄 𝘁𝗼 𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗶𝗰𝗮𝗹𝗹𝘆 𝗨𝗽𝗱𝗮𝘁𝗲 𝗦𝗽𝗲𝗻𝘁 𝗔𝗺𝗼𝘂𝗻𝘁 𝗶𝗻 𝗕𝘂𝗱𝗴𝗲𝘁 𝗨𝘀𝗶𝗻𝗴 𝗧𝗿𝗶𝗴𝗴𝗲𝗿𝘀 𝗶𝗻 𝗦𝗤𝗟 𝗦𝗲𝗿𝘃𝗲𝗿

Comments
1 min read
I Made a Detective Game That Teaches You SQL
Cover image for I Made a Detective Game That Teaches You SQL

I Made a Detective Game That Teaches You SQL

1
Comments
2 min read
🗃️ Structured Query Language (SQL): The Backbone of Modern Databases 2025
Cover image for 🗃️ Structured Query Language (SQL): The Backbone of Modern Databases 2025

🗃️ Structured Query Language (SQL): The Backbone of Modern Databases 2025

Comments
2 min read
Mastering SQLite: Efficient Database Management Tips
Cover image for Mastering SQLite: Efficient Database Management Tips

Mastering SQLite: Efficient Database Management Tips

2
Comments
3 min read
🛠️ Copying and Moving Data Between Tables in ClickHouse (with Different Engines)
Cover image for 🛠️ Copying and Moving Data Between Tables in ClickHouse (with Different Engines)

🛠️ Copying and Moving Data Between Tables in ClickHouse (with Different Engines)

7
Comments
2 min read
Filtering Data in SQL: Using WHERE, AND, OR, and NOT
Cover image for Filtering Data in SQL: Using WHERE, AND, OR, and NOT

Filtering Data in SQL: Using WHERE, AND, OR, and NOT

Comments
1 min read
Mastering SQL for Data Engineering: Advanced Queries, Optimization, and Data Modeling Best Practices
Cover image for Mastering SQL for Data Engineering: Advanced Queries, Optimization, and Data Modeling Best Practices

Mastering SQL for Data Engineering: Advanced Queries, Optimization, and Data Modeling Best Practices

1
Comments 2
10 min read
Get Total Count of Tables per Database in MySQL

Get Total Count of Tables per Database in MySQL

Comments
1 min read
How I Migrated An SQL Database To DynamoDB
Cover image for How I Migrated An SQL Database To DynamoDB

How I Migrated An SQL Database To DynamoDB

1
Comments
5 min read
How to Use esProc to Speed Up JOIN to Avoid Wide Tables

How to Use esProc to Speed Up JOIN to Avoid Wide Tables

6
Comments
6 min read
Getting Started with SQL DISTINCT
Cover image for Getting Started with SQL DISTINCT

Getting Started with SQL DISTINCT

Comments
2 min read
Mastering PostgreSQL Table Partitioning for Scalable Databases
Cover image for Mastering PostgreSQL Table Partitioning for Scalable Databases

Mastering PostgreSQL Table Partitioning for Scalable Databases

Comments
3 min read
loading...