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: SQL for Beginners Course Content 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 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 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 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 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 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 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 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 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 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 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 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 All Training Physical Classes Virtual Classes UTC British Time (UK, Ireland, Iceland) Central European Time (France, Germany, Sweden) Eastern European Time (Finland, Cyprus) Eastern Time (New York, Toronto, Montreal) Central Time (Chicago, Houston, Winnipeg) Mountain Time (Calgary, Denver, Edmonton) Mountain Time (Phoenix) Pacific Time (Los Angeles, Seattle, Vancouver) Singapore Time Arabic Standard Time (Qatar, Saudi Arabia) Gulf Standard Time (UAE, Oman) Australian Eastern Time (Sydney, Melbourne) Australian Central Time (Adelaide) Western Australia Time (Perth) New Zealand Time China Standard Time (China, Taiwan, Hong Kong) Scroll right for more details Classroom Training 10 Feb 2027 - 12 Feb 2027 Wed, Thu & Fri 10:00 AM - 02:00 PM BT £480 Enrol Now Classroom Training 23 Mar 2027 - 25 Mar 2027 Tuesday & Thursday 10:00 AM - 04:00 PM BT £480 Enrol Now Classroom Training 20 Apr 2027 - 22 Apr 2027 Tuesday & Thursday 10:00 AM - 04:00 PM BT £480 Enrol Now Classroom Training 25 May 2027 - 27 May 2027 Tuesday & Thursday 10:00 AM - 04:00 PM BT £480 Enrol Now Training venue: Unit 15, Boardman House, 64 Broadway, Stratford, London E15 1NT, United Kingdom 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: How many hours? How many people? Total Cost Price per person Preferred Dates and Times Any other information