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.
MySQL Database: Hands-On Labs for Multi-Table Operations & Sales Data Analysis
Cover image for MySQL Database: Hands-On Labs for Multi-Table Operations & Sales Data Analysis

MySQL Database: Hands-On Labs for Multi-Table Operations & Sales Data Analysis

Comments
2 min read
"The API Is Slow, Fix It!" – What I Learned About `EXPLAIN` and Indexing

"The API Is Slow, Fix It!" – What I Learned About `EXPLAIN` and Indexing

Comments
2 min read
How to Configure MariaDB 🦦 SSL Connection 🔌

How to Configure MariaDB 🦦 SSL Connection 🔌

12
Comments 1
4 min read
Postgres SQL FILTER: A Smarter CASE and CTE Alternative
Cover image for Postgres SQL FILTER: A Smarter CASE and CTE Alternative

Postgres SQL FILTER: A Smarter CASE and CTE Alternative

21
Comments 4
5 min read
How to Use JSONB in PostgreSQL
Cover image for How to Use JSONB in PostgreSQL

How to Use JSONB in PostgreSQL

7
Comments 4
4 min read
How to Get the Raw SQL Query from Laravel Query Builder

How to Get the Raw SQL Query from Laravel Query Builder

1
Comments
1 min read
🧠 "It Wasn’t the Code That Broke—It Was the Database" How to Design Scalable Databases That Grow with Your App
Cover image for 🧠 "It Wasn’t the Code That Broke—It Was the Database" How to Design Scalable Databases That Grow with Your App

🧠 "It Wasn’t the Code That Broke—It Was the Database" How to Design Scalable Databases That Grow with Your App

2
Comments
3 min read
Amazon Aurora DSQL is GA

Amazon Aurora DSQL is GA

Comments
1 min read
Design Better Databases - Best Practices
Cover image for Design Better Databases - Best Practices

Design Better Databases - Best Practices

17
Comments 1
8 min read
Fixing Getter/Setter Issues in TypeORM Entity(The Clean Way with transformer)
Cover image for Fixing Getter/Setter Issues in TypeORM Entity(The Clean Way with transformer)

Fixing Getter/Setter Issues in TypeORM Entity(The Clean Way with transformer)

Comments
1 min read
Mastering SQL Join Queries: HR Worker Data Analysis
Cover image for Mastering SQL Join Queries: HR Worker Data Analysis

Mastering SQL Join Queries: HR Worker Data Analysis

Comments
10 min read
Mastering SQL Basic : (Part : 1)
Cover image for Mastering SQL Basic : (Part : 1)

Mastering SQL Basic : (Part : 1)

Comments
8 min read
How to Optimize PostgreSQL for High Traffic and Concurrent Users
Cover image for How to Optimize PostgreSQL for High Traffic and Concurrent Users

How to Optimize PostgreSQL for High Traffic and Concurrent Users

Comments
4 min read
Converting JSON Data to Tabular in Snowflake — From SQL to SPL #32

Converting JSON Data to Tabular in Snowflake — From SQL to SPL #32

6
Comments 1
2 min read
Understanding SQL CTEs: A Simple Approach
Cover image for Understanding SQL CTEs: A Simple Approach

Understanding SQL CTEs: A Simple Approach

12
Comments 1
2 min read
Change Data Capture in SQL Server
Cover image for Change Data Capture in SQL Server

Change Data Capture in SQL Server

Comments
7 min read
Difference between UNION and UNION ALL in SQL

Difference between UNION and UNION ALL in SQL

Comments
1 min read
SQL JOINS

SQL JOINS

Comments 1
3 min read
Database Normalization: A Complete Guide to 1NF, 2NF, 3NF, and BCNF
Cover image for Database Normalization: A Complete Guide to 1NF, 2NF, 3NF, and BCNF

Database Normalization: A Complete Guide to 1NF, 2NF, 3NF, and BCNF

1
Comments 2
3 min read
Add Records that Meet the Criteria before Each Group after Grouping — From SQL to SPL #39
Cover image for Add Records that Meet the Criteria before Each Group after Grouping — From SQL to SPL #39

Add Records that Meet the Criteria before Each Group after Grouping — From SQL to SPL #39

6
Comments 3
2 min read
Revolutionize Your Workflow: Boosting SQL Productivity with Copilot in SSMS 21
Cover image for Revolutionize Your Workflow: Boosting SQL Productivity with Copilot in SSMS 21

Revolutionize Your Workflow: Boosting SQL Productivity with Copilot in SSMS 21

Comments
4 min read
La Trampa de la Sobre-Normalización

La Trampa de la Sobre-Normalización

4
Comments 2
9 min read
🍰Top 10 Best Cake Shop Full-Stack Projects for Beginners in C#, ASP.NET, and .NET Core
Cover image for 🍰Top 10 Best Cake Shop Full-Stack Projects for Beginners in C#, ASP.NET, and .NET Core

🍰Top 10 Best Cake Shop Full-Stack Projects for Beginners in C#, ASP.NET, and .NET Core

13
Comments
2 min read
How to Document SQL Server Schemas Visually in 2025
Cover image for How to Document SQL Server Schemas Visually in 2025

How to Document SQL Server Schemas Visually in 2025

12
Comments 1
4 min read
Design Your Database with dbdiagram.io (Beginner to Pro)
Cover image for Design Your Database with dbdiagram.io (Beginner to Pro)

Design Your Database with dbdiagram.io (Beginner to Pro)

10
Comments
3 min read
loading...