List: SQL Like a Pro | Curated by Joao Marques @ Data Beyond Ltd | Medium

Joao Marques @ Data Beyond Ltd

Feb 9, 2023

7 stories

SQL Like a Pro

Joao Marques @ Data Beyond Ltd

SQL Like a Pro: Query Tuning by Example

If you ever get fed up with queries that run for hours… this one’s for you!

Feb 9, 2023

SQL Like a Pro: Query Tuning by Example

Feb 9, 2023

Joao Marques @ Data Beyond Ltd

Can You Have Too Many Joins? YES!

Joins are databases’ “bread and butter”, but can you actually have “too many” joins? TLDR: yes!

Jun 19, 2022

Can You Have Too Many Joins? YES!

Jun 19, 2022

Joao Marques @ Data Beyond Ltd

SQL Like a Pro: Please Stop Using Distinct!!

Every time I see a “DISTINCT” I ask the same question: Why??

Mar 27, 2022

SQL Like a Pro: Please Stop Using Distinct!!

Mar 27, 2022

Joao Marques @ Data Beyond Ltd

SQL Like a Pro: Query Tuning #1

If you ever got fed up with queries that run for hours… this one is for you! #sql #tuning

Feb 14, 2022

SQL Like a Pro: Query Tuning #1

Feb 14, 2022

Joao Marques @ Data Beyond Ltd

SQL Like a Pro: Window Functions

You probably use window functions already… but have you taken them this far?

Feb 7, 2022

SQL Like a Pro: Window Functions

Feb 7, 2022

Joao Marques @ Data Beyond Ltd

SQL Like a Pro: Looks Do Matter!

Any fresh-out-of-college junior can write SQL that works… but if you want to be a pro, that won’t “cut the mustard”…

Dec 14, 2021

SQL Like a Pro: Looks Do Matter!

Dec 14, 2021

Joao Marques @ Data Beyond Ltd

SQL Like a Pro: How to Write a “For Loop” in SQL

That mind blowing moment when someone just totally changes your understanding of how SQL works

Dec 1, 2021

SQL Like a Pro: How to Write a “For Loop” in SQL

Dec 1, 2021

Joao Marques @ Data Beyond Ltd

Joao Marques @ Data Beyond Ltd

Just a technical Data Architect having too much fun building new data platforms! Want to support my writing? Why not BuyMeACoffee.com/joao.marques.db

Following

Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams