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.
Connecting Power BI to SQL databases.

Connecting Power BI to SQL databases.

4
Comments
5 min read
PostgreSQL vs MySQL in 2026: Performance, Features and When to Use Each

PostgreSQL vs MySQL in 2026: Performance, Features and When to Use Each

1
Comments
10 min read
Advanced SQL for Data Analytics: Advanced Techniques Every Data Analyst Should Know

Advanced SQL for Data Analytics: Advanced Techniques Every Data Analyst Should Know

1
Comments 1
6 min read
Databricks SQL Essentials - CTE

Databricks SQL Essentials - CTE

Comments
3 min read
PostgreSQL vs MySQL vs SQL Server: Enterprise Database Decision Guide

PostgreSQL vs MySQL vs SQL Server: Enterprise Database Decision Guide

1
Comments
11 min read
SQL Joins & Window Functions

SQL Joins & Window Functions

2
Comments
2 min read
Why Production Databases Break Normalization (And Why That's Okay)

Why Production Databases Break Normalization (And Why That's Okay)

4
Comments
8 min read
Part 2: BigQuery Deep Dive 🔍

Part 2: BigQuery Deep Dive 🔍

Comments
4 min read
Part 3: Partitioning & Clustering for Performance 🚀

Part 3: Partitioning & Clustering for Performance 🚀

Comments
7 min read
What is Snowflake? A Beginner's Guide to the Cloud Data Warehouse Everyone's Talking About

What is Snowflake? A Beginner's Guide to the Cloud Data Warehouse Everyone's Talking About

1
Comments
4 min read
PostgreSQL vs MySQL vs MongoDB: The Definitive Database Comparison

PostgreSQL vs MySQL vs MongoDB: The Definitive Database Comparison

3
Comments
15 min read
Monitoring TimescaleDB in Production: A Complete Checklist

Monitoring TimescaleDB in Production: A Complete Checklist

2
Comments
4 min read
Day 2: Advanced SQL Preparation Guide

Day 2: Advanced SQL Preparation Guide

Comments
6 min read
Understanding `GROUP BY` in SQL

Understanding `GROUP BY` in SQL

8
Comments
6 min read
SQLite as an MCP context saver: stop cramming raw API data into your LLM

SQLite as an MCP context saver: stop cramming raw API data into your LLM

21
Comments 14
9 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.