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.
Code is the execution. Thinking is the strategy.
fscosta1 profile

Code is the execution. Thinking is the strategy.

#sql #dataengineering #mysql #developer
1
Comments
1 min read
SQL Normalization vs Denormalization Explained with 1NF, 2NF, and 3NF
davinceleecode profile

SQL Normalization vs Denormalization Explained with 1NF, 2NF, and 3NF

#database #sql #backend #beginners
Comments
2 min read
SQL Server vs PostgreSQL: A Practical Comparison for Modern Developers
arthus15 profile

SQL Server vs PostgreSQL: A Practical Comparison for Modern Developers

#database #microsoft #postgres #sql
Comments
3 min read
From Messy JSON to Health Insights: Building a Modern ETL Pipeline with DBT and BigQuery
beck_moulton profile

From Messy JSON to Health Insights: Building a Modern ETL Pipeline with DBT and BigQuery

#sql #dataengineering #bigquery #healthtech
1
Comments
3 min read
Building a Smart Bible Reading Reminder System - Personalized Push Notifications at Scale
sangwoo_rhie profile

Building a Smart Bible Reading Reminder System - Personalized Push Notifications at Scale

#nestjs #firebase #sql #pushnotifications
Comments
12 min read
Generating AWR Reports in an Active Data Guard using RMF(12.2)
vahidusefzadeh profile

Generating AWR Reports in an Active Data Guard using RMF(12.2)

#oracle #database #linux #sql
Comments
4 min read
3 SQL Queries to Find Hidden WordPress Backdoors (When Plugins Fail)
md_pabel_fe07e07449db7326 profile

3 SQL Queries to Find Hidden WordPress Backdoors (When Plugins Fail)

#security #sql #tutorial #wordpress
1
Comments
3 min read
Automatic Flashback (or PITR) Standby
vahidusefzadeh profile

Automatic Flashback (or PITR) Standby

#oracle #database #linux #sql
Comments
12 min read
A Brief Review of Interval Partitioning
vahidusefzadeh profile

A Brief Review of Interval Partitioning

#oracle #linux #database #sql
Comments
6 min read
From Messy Wearables to Insights: Building a Personal Health Data Warehouse with DuckDB & Evidence
wellallytech profile

From Messy Wearables to Insights: Building a Personal Health Data Warehouse with DuckDB & Evidence

#sql #python #dataengineering #duckdb
1
Comments
3 min read
PostgreSQL SQL Recap: Building Strong Foundational SQL Skills
auyeungdavid_2847435260 profile

PostgreSQL SQL Recap: Building Strong Foundational SQL Skills

#postgres #sql #beginners
1
Comments
4 min read
Databricks SQL Essentials - CTE
rueedlinger profile

Databricks SQL Essentials - CTE

#beginners #dataengineering #sql #tutorial
Comments
3 min read
Part 2: BigQuery Deep Dive 🔍
abdelrahman_adnan profile

Part 2: BigQuery Deep Dive 🔍

#beginners #database #googlecloud #sql
Comments
4 min read
Part 3: Partitioning & Clustering for Performance 🚀
abdelrahman_adnan profile

Part 3: Partitioning & Clustering for Performance 🚀

#dataengineering #googlecloud #performance #sql
Comments
7 min read
Day 2: Advanced SQL Preparation Guide
neeraj1997dev profile

Day 2: Advanced SQL Preparation Guide

#dataengineering #sql
Comments
6 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.