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.
Exodus Point Data Engineering Interview Questions: Full DE Prep Guide
gowthampotureddi profile

Exodus Point Data Engineering Interview Questions: Full DE Prep Guide

#python #sql #interview #dataengineering
Comments
20 min read
Oracle Fusion vs EBS: 7 SQL Patterns Every BIP Report Developer Needs
david_jiang_9686f6cf0cfb7 profile

Oracle Fusion vs EBS: 7 SQL Patterns Every BIP Report Developer Needs

#oracle #sql #database #tutorial
Comments
5 min read
ORM library Ujorm 3.0 is released
pponec profile

ORM library Ujorm 3.0 is released

#news #database #java #sql
Comments
1 min read
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
Refreshing PostgreSQL Materialized Views Without Downtime
data_with_jelimo profile

Refreshing PostgreSQL Materialized Views Without Downtime

#database #performance #postgres #sql
Comments
7 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
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
Design review: Live SQL queries on PostgreSQL
oxharris profile

Design review: Live SQL queries on PostgreSQL

#postgres #sql #database #javascript
Comments
2 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
👋 Sign in for the ability to sort posts by relevant, latest, or top.