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.
Postgres on a Budget: 3 Free Solutions You Should Know

Postgres on a Budget: 3 Free Solutions You Should Know

2
Comments
2 min read
Demystifying SQL Indexes: A Beginner-to-Advanced Guide with Real-Life Examples

Demystifying SQL Indexes: A Beginner-to-Advanced Guide with Real-Life Examples

2
Comments
3 min read
SQL ORDER BY: Quick Sorting Examples and Tips

SQL ORDER BY: Quick Sorting Examples and Tips

Comments 1
2 min read
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

Postgres SQL FILTER: A Smarter CASE and CTE Alternative

21
Comments 4
5 min read
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

🧠 "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

Design Better Databases - Best Practices

17
Comments 1
8 min read
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

Mastering SQL Join Queries: HR Worker Data Analysis

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

Mastering SQL Basic : (Part : 1)

Comments
8 min read
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

Understanding SQL CTEs: A Simple Approach

12
Comments 1
2 min read
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

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

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

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