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.
SQL migration : SPL Lightweight Multisource Mixed Computation Practice #7

SQL migration : SPL Lightweight Multisource Mixed Computation Practice #7

5
Comments
11 min read
Learn SQL in 2 Hours — Use SQL Like Excel: A Beginner’s Friendly Guide

Learn SQL in 2 Hours — Use SQL Like Excel: A Beginner’s Friendly Guide

6
Comments
4 min read
Write Clean SQL: Tools That Format Your Queries for You

Write Clean SQL: Tools That Format Your Queries for You

Comments
1 min read
Understanding the Difference Between MongoDB, SQL, NoSQL, and PostgreSQL – Without the Code

Understanding the Difference Between MongoDB, SQL, NoSQL, and PostgreSQL – Without the Code

Comments
2 min read
How to Duplicate a Table in MySQL

How to Duplicate a Table in MySQL

Comments 1
2 min read
Indexes in MySQL: How long do you wait before calling an index "unused"?

Indexes in MySQL: How long do you wait before calling an index "unused"?

5
Comments
1 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
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 IQ – Advanced SQL Interview Queries Search and Prep System

SQL IQ – Advanced SQL Interview Queries Search and Prep System

1
Comments
4 min read
Supercharging Your Database: A Look into Indexing

Supercharging Your Database: A Look into Indexing

1
Comments
3 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
SQL for Real-Time Data: Make Decisions Now!

SQL for Real-Time Data: Make Decisions Now!

2
Comments
3 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
Hackerrank - SQL - Weather Observation Station 6

Hackerrank - SQL - Weather Observation Station 6

Comments
2 min read
Hackerrank - SQL - Weather Observation Station 7

Hackerrank - SQL - Weather Observation Station 7

Comments
2 min read
Hackerrank - SQL - Weather Observation Station 5

Hackerrank - SQL - Weather Observation Station 5

Comments
2 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
SurrealDB test case for SaaS

SurrealDB test case for SaaS

Comments
1 min read
# The Ultimate SQL Cheatsheet and Guide for 2025

# The Ultimate SQL Cheatsheet and Guide for 2025

Comments
3 min read
Hackerrank - SQL - Weather Observation Station

Hackerrank - SQL - Weather Observation Station

Comments
1 min read
loading...