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.
Uniface 10.4 + Informix: Simple Guide to Stored Procedures 🚀
f345345dfg profile

Uniface 10.4 + Informix: Simple Guide to Stored Procedures 🚀

#database #sql #performance #tutorial
Comments
4 min read
Amazon RDS vs Amazon DYNAMODB
mukesh_b_9758c3ceb936cdf1 profile

Amazon RDS vs Amazon DYNAMODB

#database #aws #sql #architecture
Comments
2 min read
Uniface 10.4 + Informix: Simple Guide to DSQL Support 🧩
f345345dfg profile

Uniface 10.4 + Informix: Simple Guide to DSQL Support 🧩

#database #sql #tutorial
Comments
3 min read
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
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
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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.