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.
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
Comments
5 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
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
1
Comments
4 min read
TIL: Blazing-fast correlated exists queries
epigene profile

TIL: Blazing-fast correlated exists queries

#rails #performance #sql
Comments 2
1 min read
Table Design: Database Fundamentals to Know as a Beginner
mazinocodes profile

Table Design: Database Fundamentals to Know as a Beginner

#sql #database #beginners #learning
27
Comments 2
4 min read
How SQLite Replaced PostgreSQL as My First Choice
cordlesswool profile

How SQLite Replaced PostgreSQL as My First Choice

#sql #database #programming
Comments
4 min read
Learning Databases Beyond SQL: My First Day with Oracle Tables
mazinocodes profile

Learning Databases Beyond SQL: My First Day with Oracle Tables

#sql #oracle #beginners #database
25
Comments 2
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.