Introduction
The following provides a structured training workshop for team members to gain proficiency in SQL and BigQuery on the Google Cloud Platform (GCP). The courses are designed to cater to different levels of expertise, from beginners to advanced learners. The training will focus on hands-on experience, ensuring participants can seamlessly navigate and utilise BigQuery for various data tasks post-training.
Prerequisites
- Basic understanding of data analytics concepts.
- Familiarity with cloud platforms is beneficial but not mandatory.
Training Courses
1. Introduction to using BigQuery in the GCP (Beginner +)
- Duration: Typically 2 sessions over 2 Day(s)
- Topics Covered:
- Overview of GCP and BigQuery.
- Navigating the platform UI.
- Understanding GCP concepts, billing, and scheduling.
- Connecting to notebooks & intro to BigQuery ML.
2. Learning Standard SQL with BigQuery (Beginner to Intermediate)
- Duration: Typically 3 sessions over 3 Day(s)
- Topics Covered:
- Basic to Intermediate SQL queries.
- Data manipulation and analysis using SQL.
- Optimising queries for performance.
3. Introduction to querying GA4 & nested datasets (Advanced)
- Duration: Typically 3 sessions over 2 Day(s)
- Topics Covered:
- Querying complex, nested datasets.
- GA4 data schema and analytics.
- Hands-on exercises with real-world datasets.
4. Introduction to using DBT with BigQuery to create robust, documented, and tested SQL models (Advanced +)
- Duration: Typically 3 sessions over 3 Day(s)
- Topics Covered:
- Building, documenting, and testing SQL models using DBT.
- Best practices for robust model creation.
Participant Information Needed Before Booking:
- Who are we training up? The training is targeted towards team members who are at varying levels of expertise with SQL and BigQuery.
- Exposure to SQL The training has courses for both beginners and those with experience with SQL
- How many people? The training can accommodate a maximum of 10 participants per batch to ensure we can field questions and divide our attention
Pricing Summary
- Typical Cost per Participant per Course: £1350 + VAT (min group of 5 for each course) - This includes after course office hours, take home tasks and supplementary notes
- Custom Packages: Custom training packages can be arranged based on the specific needs and level of expertise of the team
1 day (8 hours) of support time for the cohort will be available for help needed after the course has finished - these support hours will be available for up to 3 months after course completion
