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.
Six SQL patterns I use to catch transaction fraud
fixelsmith profile

Six SQL patterns I use to catch transaction fraud

#sql #analytics #frauddetection #database
Comments
8 min read
A Practical Introduction to SQL: DDL, DML, and Data Analysis
billymuli profile

A Practical Introduction to SQL: DDL, DML, and Data Analysis

#beginners #database #sql #tutorial
Comments
2 min read
Oracle AI Database 26ai: Relational Integrity, Vector Search, and AI-Ready Financial Workflows
yurii_dobrytsia profile

Oracle AI Database 26ai: Relational Integrity, Vector Search, and AI-Ready Financial Workflows

#ai #oracle #sql #database
Comments
10 min read
SQL Queries Every Developer Should Know (With Examples)
armorbreak profile

SQL Queries Every Developer Should Know (With Examples)

#beginners #database #sql #tutorial
1
Comments
4 min read
JDBC vs JPA: Which Should You Use?
chi25 profile

JDBC vs JPA: Which Should You Use?

#java #software #sql #programming
Comments
4 min read
Troubleshooting oracle database replication issues.
doreen970 profile

Troubleshooting oracle database replication issues.

#database #highavailability #sql
1
Comments
4 min read
Your AI database agent does not know what revenue means
mads_hansen_27b33ebfee4c9 profile

Your AI database agent does not know what revenue means

#mcp #database #ai #sql
Comments
2 min read
Why Your SQL Looks Like a Mess (And How to Fix It in Seconds)
snappy_tools profile

Why Your SQL Looks Like a Mess (And How to Fix It in Seconds)

#sql #webdev #beginners #productivity
Comments
4 min read
Multi-Tenant SQL Reporting: How to Show Each Customer Only Their Own Data
vivekdraxlr profile

Multi-Tenant SQL Reporting: How to Show Each Customer Only Their Own Data

#sql #database #postgres #webdev
Comments 1
5 min read
AI agents know SQL. Oracle Database Skills teach them Oracle
mark_nelson_oracle profile

AI agents know SQL. Oracle Database Skills teach them Oracle

#agents #ai #database #sql
Comments 1
8 min read
Understanding SQL query structure
weenaithdev profile

Understanding SQL query structure

#beginners #database #sql #tutorial
Comments
1 min read
ClickHouse JOINs Aren't Slow Anymore (You're Reading 2020's Docs)
aman_puri_115f49d5ad3612d profile

ClickHouse JOINs Aren't Slow Anymore (You're Reading 2020's Docs)

#clickhouse #database #performance #sql
Comments
6 min read
SQLite Corruption in Sandboxes, PostgreSQL Caching, & Rust DB Proxy Architecture
soytuber profile
soy

SQLite Corruption in Sandboxes, PostgreSQL Caching, & Rust DB Proxy Architecture

#database #sql #sqlite
Comments
3 min read
Broadcast Joins vs. Sort-Merge Joins: Choosing the Right Join Strategy in Apache Spark
hvardhan28 profile

Broadcast Joins vs. Sort-Merge Joins: Choosing the Right Join Strategy in Apache Spark

#apachespark #sql #joins
Comments
3 min read
Database AI Agents: A Paradigm Shift in Proactive Database Management
pranith_m_05c4bc7561a6ffd profile

Database AI Agents: A Paradigm Shift in Proactive Database Management

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