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.
Database Normalization Summary

Database Normalization Summary

Comments
1 min read
SQL DDL Commands Explained: Structuring Your Database

SQL DDL Commands Explained: Structuring Your Database

Comments
2 min read
Beginner's Guide to ADO.NET: Connection, Command & Dataset Explained

Beginner's Guide to ADO.NET: Connection, Command & Dataset Explained

Comments
1 min read
Building a RAG System with Firebase Functions, OpenAI, and Pinecone

Building a RAG System with Firebase Functions, OpenAI, and Pinecone

3
Comments
3 min read
Hands-On WrenAI Review: Text-to-SQL Powered by RAG

Hands-On WrenAI Review: Text-to-SQL Powered by RAG

Comments
3 min read
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
Why T-SQL’s Most Misunderstood Keyword Is Actually It's Safest

Why T-SQL’s Most Misunderstood Keyword Is Actually It's Safest

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

I am Learning SQL(mysql) in 2025.

4
Comments 2
1 min read
Level Up Your Data Skills: 10 Essential SQL Books for Devs & Data Scientists

Level Up Your Data Skills: 10 Essential SQL Books for Devs & Data Scientists

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

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

5
Comments
5 min read
Annotations in Oracle Database 23ai

Annotations in Oracle Database 23ai

2
Comments
2 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
Transforming Rows to Columns and Back: SQL PIVOT/UNPIVOT Techniques

Transforming Rows to Columns and Back: SQL PIVOT/UNPIVOT Techniques

1
Comments
2 min read
Top 10 AI Reporting Tools in 2025

Top 10 AI Reporting Tools in 2025

13
Comments
8 min read
SQL Server for NoSQL

SQL Server for NoSQL

Comments
1 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
Compression Algorithms You Probably Inherited: gzip, Snappy, LZ4, zstd

Compression Algorithms You Probably Inherited: gzip, Snappy, LZ4, zstd

2
Comments
4 min read
Mastering SQL Joins: INNER, LEFT, RIGHT, FULL Explained

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

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

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

Comments
1 min read
Connect Any Postgres to Real-Time Analytics

Connect Any Postgres to Real-Time Analytics

1
Comments
7 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
TiDB’s Chat2Query: Instant Business Insights, No SQL Required

TiDB’s Chat2Query: Instant Business Insights, No SQL Required

Comments
4 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
Consultas SQL reales para un restaurante: mi primer reto en análisis de datos

Consultas SQL reales para un restaurante: mi primer reto en análisis de datos

Comments
6 min read
loading...