Google BigQuery Training
In this one-day training workshop we’ll first introduce the Google Cloud Platform, including integrations and costs.You’ll then learn how to load and manage data and get hands-on experience creating views and writing queries.
The course is designed for digital marketers, data analysts and engineers who are looking to answer complex business questions using large datasets.
£475 +VAT per person
What to expect
Our training days are relaxed and informal, covering a lot of ground in a fun and stimulating way. Bring along a wifi-enabled laptop and come prepared to ask questions and get stuck in with hands-on exercises.
We will be working with data from a demo account on the day. It will help if you have experience with Google Analytics and Data Studio and some familiarity with SQL.
Google Cloud Platform
Getting to know Google Cloud Platform (GCP)
Management and access control
BigQuery setup and administration
Creating datasets and tables
Things to watch
Writing efficient code
Use cases – writing and fixing code in BigQuery
Creating simple queries using BigQuery
SQL and query syntax / references
Understanding and fixing errors
Coding and Beyond
An Introduction to Nested Queries
A logical approach to queries
Questions & Answers
Meet your trainer and more
KATY BECKETT – DATA SPECIALIST
Katy is an accomplished data engineer and analyst with a wealth of experience blending and analysing big data. She regularly uses a number of open source and commercial tools and languages including SQL, R and Python to automate data processes, build predictive models and derive insight.
Our training venues
ALL OVER LONDON
We use several Central London locations – all ideal for workshop based training. In all venues, there’s a kitchen for breakfast and lunches – as well as facilities for tea, infusions, freshly brewed Fair-trade coffee, juices, soft drinks, retro-sweets, cookies, fruit and nuts-all day long.
Frequently asked questions
What people say
Pricing and payment
One-day training course is just £475 +VAT per person.
A 20% discount is applied when you buy 2 or more at the same time and a 30% discount is applied when you buy 5 or more at the same time.
We accept all major credit cards online. Alternatively, to pay via bank transfer you may select “pay by invoice” at checkout.
For bigger groups we run onsite training workshops at your offices or at an agreed location, with prices starting from £1,600 +VAT per day.