Certificate Authentication

Day 1

DQL (Data Query Language) in Detail

• SELECT clause
• Column aliases
• Table aliases
• Date types and Date functions
• Group function
• Table joins
• JOIN clause
• UNION operator
• Nested queries
• Correlated subqueries

Day 2 (provided by Olly)

1. Assuming we might have covered all the basics on day 1. If not we will finish off
2. Talk about GA4 data structure in BQ and unnesting
3. Work through some of our use cases (in the attached email)
   
   1. I think we have time on Friday for us to work through all the examples.
   2. An additional one might be to build a visit summary table and schedule it for daily run in BQ
4. Bonus content: Working with GIT & Using Chat GPT to cheat. (If we get time I might cover this at the end of the day)