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.
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
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
How to connect Power BI to a SQL database
avedi profile

How to connect Power BI to a SQL database

#sql #database #datascience
4
Comments
4 min read
How I Used PostgreSQL to Diagnose an Ecommerce Revenue Decline
legacyunlimited profile

How I Used PostgreSQL to Diagnose an Ecommerce Revenue Decline

#ecommerce #dataanalytics #postgressql #sql
2
Comments
4 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
Connecting Power BI to SQL databases.
murimikelvin profile

Connecting Power BI to SQL databases.

#analytics #database #microsoft #sql
4
Comments
5 min read
PostgreSQL vs MySQL in 2026: Performance, Features and When to Use Each
philip_mcclarence_2ef9475 profile

PostgreSQL vs MySQL in 2026: Performance, Features and When to Use Each

#database #performance #postgres #sql
1
Comments
10 min read
Advanced SQL for Data Analytics: Advanced Techniques Every Data Analyst Should Know
kithokoi profile

Advanced SQL for Data Analytics: Advanced Techniques Every Data Analyst Should Know

#sql #data #analytics #database
1
Comments
6 min read
Databricks SQL Essentials - CTE
rueedlinger profile

Databricks SQL Essentials - CTE

#beginners #dataengineering #sql #tutorial
Comments
3 min read
SQL Joins & Window Functions
philip_weit_e7b1cffd983b2 profile

SQL Joins & Window Functions

#sql #postgres #postgressql
2
Comments
2 min read
Why Production Databases Break Normalization (And Why That's Okay)
ayushshrivastav profile

Why Production Databases Break Normalization (And Why That's Okay)

#architecture #database #sql #systemdesign
4
Comments
8 min read
SQLite as an MCP context saver: stop cramming raw API data into your LLM
richardbaxter profile

SQLite as an MCP context saver: stop cramming raw API data into your LLM

#ai #mcp #sql
43
Comments 14
9 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
Part 2: BigQuery Deep Dive 🔍
abdelrahman_adnan profile

Part 2: BigQuery Deep Dive 🔍

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