Course Outline

Introduction

  • Overview of Google BigQuery

Getting Started

  • Setting up a Google Cloud account
  • Introduction to BigQuery Web UI
  • Creating and managing datasets and tables
  • Loading data into BigQuery
  • Basic SQL queries in BigQuery

SQL Query in BigQuery

  • Advanced SQL querying techniques
  • Aggregating data with GROUP BY
  • Filtering and sorting data
  • Working with date and time functions
  • Joining multiple tables
  • Subqueries and window functions

Advanced BigQuery Features

  • Exporting data from BigQuery
  • Using user-defined functions (UDFs)
  • Managing and scheduling queries
  • Introduction to BigQuery scripting
  • Handling arrays and structs
  • Working with JSON data

BigQuery Optimization

  • Query performance optimization techniques
  • Partitioning and clustering tables
  • Using the Query Execution Plan
  • Troubleshooting and debugging queries
  • Cost control and billing best practices
  • Security and access control in BigQuery

Advanced Topics and Integration

  • Real-time data analysis with streaming data
  • Integrating BigQuery with Google Data Studio
  • Introduction to BigQuery ML for machine learning
  • Building and deploying machine learning models with BigQuery ML
  • Data lake integration with BigQuery

Summary and Next Steps

Requirements

  • Basic understanding of databases and SQL concepts

Audience

  • Data analysts
  • Database administrators
 28 Hours

Delivery Options

Private Group Training

Our identity is rooted in delivering exactly what our clients need.

  • Pre-course call with your trainer
  • Customisation of the learning experience to achieve your goals -
    • Bespoke outlines
    • Practical hands-on exercises containing data / scenarios recognisable to the learners
  • Training scheduled on a date of your choice
  • Delivered online, onsite/classroom or hybrid by experts sharing real world experience

Private Group Prices RRP from £7600 online delivery, based on a group of 2 delegates, £2400 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.

Contact us for an exact quote and to hear our latest promotions


Public Training

Please see our public courses

Testimonials (1)

Provisional Upcoming Courses (Contact Us For More Information)

Related Categories