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.
Connecting Power BI to SQL Databases
suzanne_orido profile

Connecting Power BI to SQL Databases

#database #postgres #sql
Comments
10 min read
Mastering SQL Joins and Window Functions: A Comprehensive Guide
suzanne_orido profile

Mastering SQL Joins and Window Functions: A Comprehensive Guide

#data #database #sql #tutorial
Comments
4 min read
You Forgot to Mention the 500 Million Rows
raghavsharma_ profile

You Forgot to Mention the 500 Million Rows

#ai #dataengineering #sql #performance
Comments
4 min read
Subqueries & CTEs
emilio_ochieng_632030149c profile

Subqueries & CTEs

#database #sql
1
Comments
3 min read
SQL vs. NoSQL — stop asking the wrong question
vladut02 profile
VLAD

SQL vs. NoSQL — stop asking the wrong question

#sql #nosql #database #mongodb
2
Comments
4 min read
Why CTE vs Subquery Matters More on Redshift Than Anywhere Else
maithreyan11 profile

Why CTE vs Subquery Matters More on Redshift Than Anywhere Else

#redshift #sql #dataengineering #aws
Comments
2 min read
What actually happens in a database index (and why half of them do nothing)
vladut02 profile
VLAD

What actually happens in a database index (and why half of them do nothing)

#database #sql #postgres #performance
3
Comments 3
4 min read
SQL Taught Me That There Is Always an Easier Way to Do Things
josephine_mackylah_d6b31f profile

SQL Taught Me That There Is Always an Easier Way to Do Things

#basic #sql #analytics #luxdev
4
Comments 2
5 min read
Building a Sales Analytics Data Warehouse with PostgreSQL
otasium profile

Building a Sales Analytics Data Warehouse with PostgreSQL

#analytics #data #database #sql
Comments
3 min read
We Replaced 3 Microservices With One Postgres Table
infoinlet1 profile

We Replaced 3 Microservices With One Postgres Table

#postgres #architecture #backend #sql
11
Comments 1
7 min read
SSMS Database Diagrams: Your ERD Is Trapped Inside the Database It Documents
tbson87 profile

SSMS Database Diagrams: Your ERD Is Trapped Inside the Database It Documents

#database #sqlserver #sql #documentation
Comments
6 min read
interlace.sh: A Macro Is an Expression, Not a Template
5c4989ca297ed profile

interlace.sh: A Macro Is an Expression, Not a Template

#sql #python #opensource
Comments
6 min read
Twenty-Five Million Rows in Five Seconds, and How to Check
5c4989ca297ed profile

Twenty-Five Million Rows in Five Seconds, and How to Check

#opensource #sql #python #data
Comments
5 min read
Fixing Enterprise HR Hierarchy Lookups Without Cache Invalidation Nightmares
shubhamshaw profile

Fixing Enterprise HR Hierarchy Lookups Without Cache Invalidation Nightmares

#database #softwareengineering #architecture #sql
Comments
1 min read
Migrating jaffle_shop: A Real dbt Project, End to End
5c4989ca297ed profile

Migrating jaffle_shop: A Real dbt Project, End to End

#sql #opensource #python #data
Comments
8 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.