• 0208 432 6218
  • WhatsApp
  • AI Assistant
  • Register

Google BigQuery SQL for Data Analysts

Query, Transform & Analyse Large Datasets with GoogleSQL

Regular Price: £480
Batch Price: From £420   📅  View Dates & Prices

Group Booking Discount: From £300 per person  🧮 Calculate & Book

1-to-1 Training: £600  📋 Booking Request Form

Course Overview

Google BigQuery SQL for Data Analysts is a practical 12-hour instructor-led course designed to help learners query, transform and analyse large datasets using Google BigQuery and GoogleSQL. Starting with essential SQL querying skills, the course progresses through filtering, aggregation, joins, Common Table Expressions (CTEs), analytical functions and other techniques commonly used by Data Analysts.

Participants will work with realistic datasets in BigQuery Studio and learn how to analyse cloud data, work with nested and repeated fields, use window functions, understand partitioning and clustering, and write queries with performance and cost in mind. Through hands-on exercises and a practical analytics project, learners will develop the confidence to work directly with BigQuery rather than relying solely on Business Intelligence tools to generate queries.


Requirements

Basic experience working with data is recommended. Previous BigQuery experience is not required; basic SQL knowledge is helpful but not essential.

You may also complete the following course(s) before attending the Google BigQuery SQL for Data Analysts course but they are not mandatory:


Course Content

  1. Introduction to Google BigQuery
    • What Google BigQuery is
    • Cloud data warehouses and serverless analytics
    • Understanding projects, datasets, tables and views
    • Introduction to BigQuery Studio
    • Understanding GoogleSQL
    • Using BigQuery Sandbox
    • Working with BigQuery public datasets
    • Understanding storage and query-processing costs
    • Navigating the BigQuery interface
  2. SQL Fundamentals with GoogleSQL
    • Writing queries with SELECT
    • Selecting individual columns
    • Using column aliases
    • Removing duplicates with DISTINCT
    • Filtering with WHERE
    • Comparison operators
    • Using AND, OR and NOT
    • Using IN, BETWEEN and LIKE
    • Handling NULL values
    • Sorting with ORDER BY
    • Limiting query results
  3. Functions, Calculations & Conditional Logic
    • Creating calculated columns
    • String functions
    • Numeric functions
    • Date and time functions
    • Converting data types
    • Working with COALESCE()
    • Creating conditional logic with CASE
    • Cleaning and standardising values using SQL
  4. Aggregation & Business Analysis
    • Using COUNT(), SUM(), AVG(), MIN() and MAX()
    • Grouping data with GROUP BY
    • Filtering grouped results with HAVING
    • Creating business KPIs
    • Analysing customers, products, sales and other business dimensions
    • Creating multi-level analytical summaries
  5. Joining & Combining Data
    • Understanding relationships between tables
    • Using INNER JOIN
    • Using LEFT JOIN
    • Understanding other join types
    • Joining multiple tables
    • Using aliases in complex queries
    • Identifying duplicate rows caused by joins
    • Combining query results with UNION ALL
  6. Subqueries & Common Table Expressions
    • Understanding subqueries
    • Using subqueries for filtering and analysis
    • Creating Common Table Expressions with WITH
    • Using multiple CTEs
    • Breaking complex analytical queries into logical stages
    • Choosing between subqueries and CTEs
  7. Window Functions for Data Analysis
    • Understanding analytical window functions
    • Using the OVER() clause
    • Using PARTITION BY
    • Using ORDER BY within a window
    • Creating row numbers with ROW_NUMBER()
    • Ranking with RANK() and DENSE_RANK()
    • Comparing values with LAG() and LEAD()
    • Creating running totals
    • Calculating values within groups
    • Filtering window-function results with QUALIFY
  8. Nested & Repeated Data in BigQuery
    • Understanding denormalised data in BigQuery
    • Introduction to STRUCT
    • Introduction to ARRAY
    • Working with nested fields
    • Working with repeated fields
    • Accessing nested values using dot notation
    • Flattening arrays with UNNEST()
    • Analysing nested business data
    • Understanding JSON data at a practical level
  9. Creating & Loading Analytical Data
    • Creating datasets and tables
    • Understanding table schemas
    • Loading CSV data
    • Loading JSON data
    • Creating tables from query results
    • Creating views
    • Preparing reusable analytical datasets
    • Understanding permissions required to create and modify data
  10. Partitioning & Clustering
    • Why large BigQuery tables are partitioned
    • Understanding partitioned tables
    • Partitioning by date or timestamp
    • Filtering partitioned tables efficiently
    • Understanding partition pruning
    • Introduction to clustering
    • Choosing useful clustering columns
    • Combining partitioning and clustering
    • Understanding how table design affects performance and cost
  11. Query Performance & Cost Awareness
    • Understanding bytes processed
    • Previewing query-processing estimates
    • Avoiding unnecessary use of SELECT *
    • Selecting only required columns
    • Filtering data as early as practical
    • Using partition filters effectively
    • Understanding how clustering can reduce scanned data
    • Reviewing query history and execution details
    • Writing readable and efficient analytical SQL
    • Understanding BigQuery free-tier limits
  12. Practical Google BigQuery Analytics Project
    • Explore a realistic BigQuery dataset
    • Understand tables, fields and relationships
    • Clean and transform data using GoogleSQL
    • Join multiple datasets
    • Create analytical CTEs
    • Use window functions
    • Analyse nested or repeated data
    • Create business KPIs
    • Analyse trends and performance
    • Review bytes processed
    • Improve a query using partitioning or filtering principles
    • Present findings derived directly from BigQuery


Course Dates, Prices & Enrolment

Scroll right for more details
Online Training using Zoom
10 Feb 2027 - 12 Feb 2027
Wed, Thu & Fri
10:00 AM - 02:00 PM BT
£420 £480
Classroom Training
10 Feb 2027 - 12 Feb 2027
Wed, Thu & Fri
10:00 AM - 02:00 PM BT
£480
Online Training using Zoom
23 Mar 2027 - 25 Mar 2027
Tuesday & Thursday
10:00 AM - 04:00 PM BT
£420 £480
Classroom Training
23 Mar 2027 - 25 Mar 2027
Tuesday & Thursday
10:00 AM - 04:00 PM BT
£480
Online Training using Zoom
20 Apr 2027 - 22 Apr 2027
Tuesday & Thursday
10:00 AM - 04:00 PM BT
£420 £480
Classroom Training
20 Apr 2027 - 22 Apr 2027
Tuesday & Thursday
10:00 AM - 04:00 PM BT
£480
Online Training using Zoom
25 May 2027 - 27 May 2027
Tuesday & Thursday
10:00 AM - 04:00 PM BT
£420 £480
Classroom Training
25 May 2027 - 27 May 2027
Tuesday & Thursday
10:00 AM - 04:00 PM BT
£480

Price Calculator & Booking Request Form

Calculate prices for Corporate, 1-on-1 or group training and request a booking.

Do you have a special training requirement or unable to find any suitable training date? Please complete and submit the booking request form, if you want to:

  • book a course on different dates
  • book for a group of delegates
  • book corporate training
  • book a customised training
  • book a one-on-one training

The price person is less when you book a course for more people. You can find the price per person and the total cost by changing the values of the training hours and the number of people below:

Frequently Asked Questions

Google BigQuery is a cloud-based analytics platform designed for querying and analysing large datasets using SQL.

Data Analysts can use BigQuery to work directly with cloud data, create analytical queries, transform datasets and produce information that can later be used by reporting and Business Intelligence tools.

Previous SQL knowledge is helpful but not essential. The course reviews core SQL concepts before moving on to joins, CTEs, window functions, and BigQuery-specific analytical techniques.

Complete beginners who would like more time to practise SQL fundamentals may benefit from completing our SQL for Beginners course first.

Google provides a BigQuery Sandbox that allows learners to explore BigQuery without providing a credit card or creating a billing account.

The sandbox includes limited storage and monthly query-processing allowances and is suitable for many learning exercises. Some BigQuery features are restricted in the sandbox.

Yes. Window functions are an important part of the course because they are widely used in professional analytical SQL.

Learners will work with functions such as ROW_NUMBER(), RANK(), DENSE_RANK(), LAG() and LEAD(), as well as running totals and QUALIFY.

Yes. BigQuery commonly works with nested and repeated data, so learners will be introduced to STRUCT, ARRAY and UNNEST().

This helps learners analyse hierarchical and semi-structured datasets that may look very different from traditional relational database tables.

Yes. The course covers practical query-performance and cost-awareness techniques including selecting only required columns, filtering partitioned data appropriately and reviewing the amount of data processed by queries.

The focus is on writing efficient analytical SQL rather than advanced platform performance engineering.

Yes. The course concludes with a practical BigQuery analytics project using a realistic dataset.

Learners will combine joins, aggregations, CTEs, window functions, nested data and query-optimisation techniques to answer business questions and produce insights directly with GoogleSQL.

No. Previous experience with Google BigQuery or Google Cloud is not required.

The course introduces the BigQuery environment, datasets, tables and GoogleSQL before progressing into more advanced analytical techniques.

GoogleSQL is the SQL dialect used by Google BigQuery.

It supports familiar SQL features such as joins, aggregations, subqueries and CTEs, along with analytical functionality including window functions, arrays, structures and the QUALIFY clause.

Yes. The course uses realistic analytical datasets, and exercises may also use datasets available through the BigQuery Public Dataset Program.

Public datasets provide an excellent way to practise analysing larger datasets without having to build every dataset from scratch.

QUALIFY allows you to filter the results produced by window functions.

It is particularly useful for analytical tasks such as selecting the highest-ranked records within groups without having to wrap the window-function query inside another query.

Yes. Learners will understand how partitioning and clustering can improve analytical query performance and reduce unnecessary data processing.

The course focuses on the practical knowledge a Data Analyst needs rather than advanced BigQuery administration.

BigQuery ML may be demonstrated as an optional or bonus topic, but it is not part of the core 12-hour syllabus.

The main course focuses on SQL and analytical skills required by Data Analysts.

Yes. The course is particularly suitable for professionals whose organisations already store data in BigQuery but who want to become more confident in querying and analysing that data directly.

It can help learners become less dependent on Business Intelligence tools for generating queries and give them greater control over data analysis and transformation.

What we do?

At London Academy of IT, we provide instructor-led online and in-person IT training in Data Analytics, SQL, Python, Power BI, and more. Our cutting-edge courses are designed to boost performance and enhance employability, providing the competitive edge employers look for.

Our Contacts

London Academy of IT
64 Broadway
Stratford
London E15 1NT
United Kingdom

Regional Training

2012 - 2026 © London Academy of IT Limited. All Rights Reserved.
UKPRN: 10045491. Registered in England & Wales with company no. 07923992.