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.
SQLNet is A social network that looks like Twitter, but you write SQL to do anything
levla profile

SQLNet is A social network that looks like Twitter, but you write SQL to do anything

#sql #programming #database #socialmedia
2
Comments
7 min read
The second-highest salary: Why the simplest SQL query is often the smartest
vardan_matevosian_tech profile

The second-highest salary: Why the simplest SQL query is often the smartest

#sql #leetcode #database #programming
Comments
4 min read
Old Oracle Joins vs ANSI JOINs: Why I Chose One and Stuck With It
mazinocodes profile

Old Oracle Joins vs ANSI JOINs: Why I Chose One and Stuck With It

#oracle #sql #database #beginners
16
Comments
2 min read
“How I Built an End-to-End ETL Pipeline Using Databricks & Delta Lake”
khandare_shubham_4d9ec230 profile

“How I Built an End-to-End ETL Pipeline Using Databricks & Delta Lake”

#databricks #sql #pyspark #etl
Comments
2 min read
Medallion Architecture 101: Building Data Pipelines That Don't Fall Apart
aawiegel profile

Medallion Architecture 101: Building Data Pipelines That Don't Fall Apart

#dataengineering #database #python #sql
Comments
11 min read
Querying & Filtering in Oracle Databases: What Actually Clicked for Me As a Beginner
mazinocodes profile

Querying & Filtering in Oracle Databases: What Actually Clicked for Me As a Beginner

#oracle #sql #database #beginners
30
Comments 1
4 min read
The Day I Chose VARCHAR(255) and Regretted It: A PostgreSQL String Story
igornosatov_15 profile

The Day I Chose VARCHAR(255) and Regretted It: A PostgreSQL String Story

#postgres #database #performance #sql
2
Comments 1
8 min read
How One Can Start Their Journey in Data Engineering
chaets profile

How One Can Start Their Journey in Data Engineering

#programming #dataengineering #sql #beginners
Comments 2
4 min read
MSSQL DBCC How good are they really ?
abeamar profile

MSSQL DBCC How good are they really ?

#sql #tutorial #sqlserver #database
1
Comments
6 min read
SQL Nulls Finally Made Sense: COALESCE, NULLIF, and Safer Calculations
mazinocodes profile

SQL Nulls Finally Made Sense: COALESCE, NULLIF, and Safer Calculations

#sql #postgres #database #beginners
30
Comments
3 min read
PostgreSQL Dead Rows: The Ultimate Guide to MVCC, Database Bloat, Performance Degradation, and Long-Term Optimization
amr-saafan profile

PostgreSQL Dead Rows: The Ultimate Guide to MVCC, Database Bloat, Performance Degradation, and Long-Term Optimization

#postgres #postgressql #sql #database
3
Comments
7 min read
Columns & Data Types in Oracle: What Actually Stuck on Day 2 (As a Beginner)
mazinocodes profile

Columns & Data Types in Oracle: What Actually Stuck on Day 2 (As a Beginner)

#oracle #sql #beginners #database
29
Comments 2
3 min read
Subqueries vs JOINs: When to Use Each in SQL
hinlocaesar profile

Subqueries vs JOINs: When to Use Each in SQL

#beginners #database #performance #sql
3
Comments
4 min read
SQL - PostgreSQL: Execution Order
yurilbrok profile

SQL - PostgreSQL: Execution Order

#sql #postgres #dataengineering #database
4
Comments
5 min read
TIL: Blazing-fast correlated exists queries
epigene profile

TIL: Blazing-fast correlated exists queries

#rails #performance #sql
Comments 2
1 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.