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 Injection – UNION attack | PortSwigger Lab Note #3

SQL Injection – UNION attack | PortSwigger Lab Note #3

5
Comments 1
1 min read
Connecting Power BI to SQL Databases: A Comprehensive Guide

Connecting Power BI to SQL Databases: A Comprehensive Guide

2
Comments
9 min read
Data Engineers: What If Your BigQuery Function Could Return Multiple Tables?

Data Engineers: What If Your BigQuery Function Could Return Multiple Tables?

3
Comments
2 min read
SQL ANALYTICAL MECHANICS: JOINS & WINDOW FUNCTIONS

SQL ANALYTICAL MECHANICS: JOINS & WINDOW FUNCTIONS

1
Comments
7 min read
PostgreSQL Query Optimization: 10 Techniques That Actually Work

PostgreSQL Query Optimization: 10 Techniques That Actually Work

2
Comments
12 min read
SQL Queries Asked In Interview

SQL Queries Asked In Interview

6
Comments
2 min read
Understanding SQL Joins with Practical Examples (Beginner Friendly Guide)

Understanding SQL Joins with Practical Examples (Beginner Friendly Guide)

2
Comments
8 min read
What is MySQL's Optimizer Trace? Why is it Essential for SQL Optimization?

What is MySQL's Optimizer Trace? Why is it Essential for SQL Optimization?

1
Comments
4 min read
Mastering SQL Joins and Window Functions: A Practical Guide with an E‑commerce Dataset

Mastering SQL Joins and Window Functions: A Practical Guide with an E‑commerce Dataset

4
Comments
20 min read
I Eliminated SQLite Race Conditions in a Multi-Threaded Python App 🚀

I Eliminated SQLite Race Conditions in a Multi-Threaded Python App 🚀

Comments
3 min read
Understanding SQL Joins and Window Functions

Understanding SQL Joins and Window Functions

2
Comments
4 min read
SQL Directly in Java — Why I Built a Java Framework (third attempt in 10 years) #10

SQL Directly in Java — Why I Built a Java Framework (third attempt in 10 years) #10

1
Comments
8 min read
Building a Resilient Financial Engine: How I Fixed a Data Duplication Bug with Idempotent SQL

Building a Resilient Financial Engine: How I Fixed a Data Duplication Bug with Idempotent SQL

Comments 2
2 min read
Advanced SQL Techniques Every Data Analyst Should Know

Advanced SQL Techniques Every Data Analyst Should Know

3
Comments 2
11 min read
SQL Joins and Window Functions: A Practical Guide.

SQL Joins and Window Functions: A Practical Guide.

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