SQL Workshop: SQL Patterns Every Analyst Should Know w/ Ergest Xheblati
Census Census
1.47K subscribers
15,882 views
0

 Published On Oct 13, 2022

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 ⬅️

show more

Share/Embed