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.
Navigating MariaDB on HTB’s ‘Sequel’ Box to Retrieve the Flag

Navigating MariaDB on HTB’s ‘Sequel’ Box to Retrieve the Flag

Comments
1 min read
How to install Maven (Apache Maven) on Windows 11?

How to install Maven (Apache Maven) on Windows 11?

2
Comments
2 min read
I am Learning SQL(mysql) in 2025.

I am Learning SQL(mysql) in 2025.

4
Comments 2
1 min read
SQL vs. NoSQL | Schema Design Differences Explained Visually

SQL vs. NoSQL | Schema Design Differences Explained Visually

13
Comments 2
5 min read
PostgreSQL 🐘 Hosting Options in 2025: Pricing Comparison 💸⚖️

PostgreSQL 🐘 Hosting Options in 2025: Pricing Comparison 💸⚖️

5
Comments
5 min read
Summarize Row Counts by Dynamic Columns into JSON — From SQL to SPL #22

Summarize Row Counts by Dynamic Columns into JSON — From SQL to SPL #22

6
Comments 1
2 min read
What should we do when SQL (and stored procedure) runs too slowly?

What should we do when SQL (and stored procedure) runs too slowly?

13
Comments 6
13 min read
Aggregate according to Time Interval — From SQL to SPL #27

Aggregate according to Time Interval — From SQL to SPL #27

9
Comments 3
2 min read
Design Database Schemas Without Internet Connection

Design Database Schemas Without Internet Connection

10
Comments 3
3 min read
Mastering SQL Joins: INNER, LEFT, RIGHT, FULL Explained

Mastering SQL Joins: INNER, LEFT, RIGHT, FULL Explained

2
Comments
3 min read
Statistics by Time Window — From SQL to SPL #31

Statistics by Time Window — From SQL to SPL #31

10
Comments 3
3 min read
Full Stack Development with Spring Boot (အခန်း ၈)

Full Stack Development with Spring Boot (အခန်း ၈)

Comments
1 min read
Oracle Database 23ai Fast Ingest Enhancements

Oracle Database 23ai Fast Ingest Enhancements

Comments
2 min read
What is SQL and Why You Should Learn It

What is SQL and Why You Should Learn It

Comments
1 min read
Sparse & Dense Indexes in DBMS

Sparse & Dense Indexes in DBMS

1
Comments
3 min read
SQL for Everyone: The Ultimate Starter Guide

SQL for Everyone: The Ultimate Starter Guide

3
Comments 3
19 min read
What's New 🆕🤯 in PostgreSQL 18 🐘 - a DBA's Perspective

What's New 🆕🤯 in PostgreSQL 18 🐘 - a DBA's Perspective

5
Comments
5 min read
Serverless Is a Lie (Unless You’re Using SQLite)

Serverless Is a Lie (Unless You’re Using SQLite)

11
Comments 1
4 min read
AI-Driven SQL Dataset Optimization: Best Practices & Updates for Modern Applications

AI-Driven SQL Dataset Optimization: Best Practices & Updates for Modern Applications

Comments
8 min read
The Death of SQL? The Silent Rise of NewSQL

The Death of SQL? The Silent Rise of NewSQL

Comments
3 min read
Introduction to SQL for data science

Introduction to SQL for data science

1
Comments
2 min read
Find the Superset from the Relationship Table — From SQL to SPL #19

Find the Superset from the Relationship Table — From SQL to SPL #19

1
Comments 1
1 min read
How to Set Up PostgreSQL Database with a Django Application

How to Set Up PostgreSQL Database with a Django Application

4
Comments
2 min read
Where 1 = 1 in SQL

Where 1 = 1 in SQL

Comments 2
1 min read
Doris: Breaking Down the Barriers of SQL Dialects and Building a Unified Data Query Ecosystem

Doris: Breaking Down the Barriers of SQL Dialects and Building a Unified Data Query Ecosystem

2
Comments
4 min read
loading...