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.
3 SQL Queries to Find Hidden WordPress Backdoors (When Plugins Fail)
md_pabel_fe07e07449db7326 profile

3 SQL Queries to Find Hidden WordPress Backdoors (When Plugins Fail)

#security #sql #tutorial #wordpress
1
Comments
3 min read
Automatic Flashback (or PITR) Standby
vahidusefzadeh profile

Automatic Flashback (or PITR) Standby

#oracle #database #linux #sql
Comments
12 min read
A Brief Review of Interval Partitioning
vahidusefzadeh profile

A Brief Review of Interval Partitioning

#oracle #linux #database #sql
Comments
6 min read
From Messy Wearables to Insights: Building a Personal Health Data Warehouse with DuckDB & Evidence
wellallytech profile

From Messy Wearables to Insights: Building a Personal Health Data Warehouse with DuckDB & Evidence

#sql #python #dataengineering #duckdb
1
Comments
3 min read
PostgreSQL SQL Recap: Building Strong Foundational SQL Skills
auyeungdavid_2847435260 profile

PostgreSQL SQL Recap: Building Strong Foundational SQL Skills

#postgres #sql #beginners
1
Comments
4 min read
Databricks SQL Essentials - CTE
rueedlinger profile

Databricks SQL Essentials - CTE

#beginners #dataengineering #sql #tutorial
Comments
3 min read
Part 2: BigQuery Deep Dive 🔍
abdelrahman_adnan profile

Part 2: BigQuery Deep Dive 🔍

#beginners #database #googlecloud #sql
Comments
4 min read
Part 3: Partitioning & Clustering for Performance 🚀
abdelrahman_adnan profile

Part 3: Partitioning & Clustering for Performance 🚀

#dataengineering #googlecloud #performance #sql
Comments
7 min read
Day 2: Advanced SQL Preparation Guide
neeraj1997dev profile

Day 2: Advanced SQL Preparation Guide

#dataengineering #sql
Comments
6 min read
Hello Everyone!
joan_ifezue_90fa2ed6fed55 profile

Hello Everyone!

#productivity #machinelearning #sql #python
1
Comments 1
1 min read
From Zero to Cached: Building a High-Performance Housing Portal with Django, Next.js, and Redis - Part 4 : Optimization Pillars
ajitkumar profile

From Zero to Cached: Building a High-Performance Housing Portal with Django, Next.js, and Redis - Part 4 : Optimization Pillars

#django #python #sql #redis
Comments
17 min read
How to Turn Slow Queries into Actionable Reliability Metrics with OpenTelemetry
svrnm profile

How to Turn Slow Queries into Actionable Reliability Metrics with OpenTelemetry

#opentelemetry #sql #postgres
Comments
11 min read
GeoSQL-Eval: Finally, a PostGIS Benchmark That Doesn’t Make Me Scream
rebooter_s profile

GeoSQL-Eval: Finally, a PostGIS Benchmark That Doesn’t Make Me Scream

#llm #postgres #sql #testing
Comments
2 min read
Bancos de Dados Relacionais: A Estrutura que Sustenta Aplicações Modernas
maurilosantos profile

Bancos de Dados Relacionais: A Estrutura que Sustenta Aplicações Modernas

#architecture #backend #database #sql
Comments
3 min read
What is MySQL's Optimizer Trace? Why is it Essential for SQL Optimization?
rebooter_s profile

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

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