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.
Introducing the All-New SLS SQL Copilot

Introducing the All-New SLS SQL Copilot

Comments
15 min read
Building a Realistic Banking Dummy Data Generator with Bad-Data Simulation

Building a Realistic Banking Dummy Data Generator with Bad-Data Simulation

1
Comments
1 min read
I Almost Let an LLM Delete My Database. Here's What I Built to Prevent It.
Cover image for I Almost Let an LLM Delete My Database. Here's What I Built to Prevent It.

I Almost Let an LLM Delete My Database. Here's What I Built to Prevent It.

6
Comments 2
2 min read
🚀 Cómo Crear una Vista en SQL Server 2022: Simplifica tu Acceso a Datos

🚀 Cómo Crear una Vista en SQL Server 2022: Simplifica tu Acceso a Datos

Comments
2 min read
select2

select2

Comments
1 min read
Week 4_b of 40 – Adding Persistence with SQLite

Week 4_b of 40 – Adding Persistence with SQLite

Comments
1 min read
How I Optimized an Extremely Slow Oracle SQL Query (Real Case Study)
Cover image for How I Optimized an Extremely Slow Oracle SQL Query (Real Case Study)

How I Optimized an Extremely Slow Oracle SQL Query (Real Case Study)

Comments
2 min read
Google Cloud SQL: The Ultimate Guide to Managed Relational Databases
Cover image for Google Cloud SQL: The Ultimate Guide to Managed Relational Databases

Google Cloud SQL: The Ultimate Guide to Managed Relational Databases

6
Comments
4 min read
Mastering SQL: Revisiting the Basics
Cover image for Mastering SQL: Revisiting the Basics

Mastering SQL: Revisiting the Basics

Comments
3 min read
How I Create PDF Reports from SQL Server in C# Using IronPDF (Beginner Guide)

How I Create PDF Reports from SQL Server in C# Using IronPDF (Beginner Guide)

2
Comments
5 min read
Quick Recap: SQL Databases

Quick Recap: SQL Databases

Comments
2 min read
When ANALYZE Isn't Enough: Debugging Bad Row Estimation in PostgreSQL

When ANALYZE Isn't Enough: Debugging Bad Row Estimation in PostgreSQL

5
Comments 4
8 min read
Understanding Common Table Expressions (CTEs) in SQL — And Why They Matter in Data Analysis

Understanding Common Table Expressions (CTEs) in SQL — And Why They Matter in Data Analysis

Comments
3 min read
Best Practices for Connecting LLMs to SQL Databases
Cover image for Best Practices for Connecting LLMs to SQL Databases

Best Practices for Connecting LLMs to SQL Databases

2
Comments
5 min read
No, MongoDB Does Not Mean Skipping Design
Cover image for No, MongoDB Does Not Mean Skipping Design

No, MongoDB Does Not Mean Skipping Design

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