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.
You Can't Trust COUNT and SUM: Scalable Data Validation with Merkle Trees

You Can't Trust COUNT and SUM: Scalable Data Validation with Merkle Trees

2
Comments 1
8 min read
Hands-On MySQL Labs: CRUD, Constraints & Student Data Management

Hands-On MySQL Labs: CRUD, Constraints & Student Data Management

Comments
2 min read
Clean and Compare Strings in SQL with TRIM

Clean and Compare Strings in SQL with TRIM

Comments
2 min read
How SQL Queries Really Work: From Parsing to Execution

How SQL Queries Really Work: From Parsing to Execution

3
Comments
4 min read
Leveraging Stack Traces for SQL Performance Analysis in Spring Boot Applications

Leveraging Stack Traces for SQL Performance Analysis in Spring Boot Applications

Comments
5 min read
SQL Joins Explained - INNER, LEFT, RIGHT, FULL

SQL Joins Explained - INNER, LEFT, RIGHT, FULL

7
Comments
3 min read
Essential Adjacent References

Essential Adjacent References

9
Comments 1
6 min read
SQL IQ – Advanced SQL Interview Queries Search and Prep System

SQL IQ – Advanced SQL Interview Queries Search and Prep System

1
Comments
4 min read
SQL Q. series 1 - Last Person to Fit in the Bus 🚌🚌

SQL Q. series 1 - Last Person to Fit in the Bus 🚌🚌

1
Comments
2 min read
Relacionamentos Bidirecionais vs Unidirecionais no Spring JPA

Relacionamentos Bidirecionais vs Unidirecionais no Spring JPA

1
Comments
3 min read
How to Design a PostgreSQL Schema Visually (Step-by-Step)

How to Design a PostgreSQL Schema Visually (Step-by-Step)

7
Comments 2
4 min read
Stop Your SQL JOINs from Crawling: A Quick Index Fix

Stop Your SQL JOINs from Crawling: A Quick Index Fix

Comments
2 min read
Beginner's Guide to SQL for Data Analysis

Beginner's Guide to SQL for Data Analysis

Comments
2 min read
Redis vs. Memcached: How to Choose Your NoSQL Champion

Redis vs. Memcached: How to Choose Your NoSQL Champion

3
Comments
4 min read
Building a Food Price & Inflation Analysis Pipeline in Kenya (2006–2024)

Building a Food Price & Inflation Analysis Pipeline in Kenya (2006–2024)

Comments
3 min read
Building a Modern Data Warehouse in SQL Server with Medallion Architecture

Building a Modern Data Warehouse in SQL Server with Medallion Architecture

Comments
11 min read
SQLite Practical Guide: Building Tables & Linux Setup

SQLite Practical Guide: Building Tables & Linux Setup

Comments
2 min read
Building Trust in AI: Enterprise Knowledge Base Validation with MindsDB

Building Trust in AI: Enterprise Knowledge Base Validation with MindsDB

Comments
10 min read
How To Build An API With Node, Without Additional Framework (SQL Included)

How To Build An API With Node, Without Additional Framework (SQL Included)

Comments
15 min read
Introduction to MongoDB and NoSQL — Day 1

Introduction to MongoDB and NoSQL — Day 1

6
Comments 4
2 min read
SQL INTERSECT Explained: Find Shared Rows Easily

SQL INTERSECT Explained: Find Shared Rows Easily

1
Comments
2 min read
Getting Started with PL/SQL Blocks and Calling Them from Spring Boot JPA

Getting Started with PL/SQL Blocks and Calling Them from Spring Boot JPA

Comments
3 min read
SurrealDB test case for SaaS

SurrealDB test case for SaaS

Comments
1 min read
How to Host a Mini-SQL Server (SQLite/MySQL) on Termux

How to Host a Mini-SQL Server (SQLite/MySQL) on Termux

1
Comments
3 min read
Vectors in AI: A Bridge Between Code and Business

Vectors in AI: A Bridge Between Code and Business

Comments
4 min read
loading...