Level up your SQL knowledge to deliver results in real world situations.
I’ll cover:
- Joining on messy data, what can go wrong and how to avoid it.
- Window functions, what makes them great and an example of how to use them to create sessions.
- Arrays, why data engineers use them and how to access data stored in them easily.
This talk is aimed at people who already have intermediate to advanced SQL skills. For example knowing how to use joins and aggregation.
Technical level of session: Technical practitioner
Please find the handout with key links to follow along during the session here.