SQL Workshop: SQL Patterns Every Analyst Should Know w/ Ergest Xheblati

Ergest Xheblati is the author of Minimum Viable SQL Patterns, and he's spent the last 15+ years mastering SQL.
In this SQL workshop, hosted by The Operational Analytics Club & Census, Ergest teaches various SQL principles (patters) to help you take your SQL skills from intermediate to expert.
More specifically, you'll learn about:
- Query composition patterns - How to make your complex queries shorter, more legible, and more performant
- Query maintainability patterns - Constructing CTEs that can be reused. In software engineering, it's called the DRY principle (don't repeat yourself)
- Query robustness patterns - Constructing queries that don't break when the underlying data changes in unpredictable ways
- Query performance patterns - Make your queries faster (and cheaper) regardless of specific database you’re using
Toward the end of the workshop, Ergest answers over a dozen questions from SQL professionals all over the world.
---
Ready to sharpen your data skills and expand your network of awesome data professionals? Join The Operational Analytics Club, an incubator program for the next gen of data leaders, at operationalanalytics.club ⬅️

[@krispat8631]

Thank You for these elaborate explanations !

[@kannanramaswamy6904]

This video will explode at go viral. I wish you all the best! Please keep coming up with such great content.

[@Sonicboom659]

Thanks for recording this!

[@patriajimenez1553]

Note to self: 45:12 - group by in a CTE that doesn’t have aggregates to remove duplicates
String date type 32:24 casting, using functions in where clause will prevent the index from being used

[@bartvanderput998]

When using an alias, I would suggest always prefix the columnname with the alias, so it is clear from which table/cte a column originates. In your code you do it only to remove ambiguity, but I would suggest doing it always.

[@prod.lil_diva1400]

thank u helped me a lot

[@davidwsw]

Is there any way to move the presenter's face to the top right of the screen in the future to avoid covering the content?

[@peanutbutternjelly4736]

Does anyone know if there are limitations with using a CTE vs. a sub-query when using proc sql/ proc fedsql with SAS/ SAS Viya? And also whether it is compatible with custom queries in Tableau?

[@swedishpsychopath8795]

Where can I download the StackOwerflow data?

[@karelvanderwalt3625]

‘Modularizing computation via Common Table Expressions (CTEs)’
PostgresConf South Africa 2021
th-cam.com/video/xoYXwN4grQQ/w-d-xo.html