Google BigQuery Training Course
Google BigQuery is a robust serverless data warehousing and analytics platform that equips users with tools to query and analyse extensive datasets, enhance query performance, integrate with other GCP services, and construct machine learning models.
This instructor-led, live training (available online or onsite) targets advanced-level data analysts eager to master Google BigQuery for data querying, optimization, and machine learning integration.
Upon completion of this training, participants will be capable of:
- Grasping the fundamentals of Google BigQuery and its application in data analytics and cloud computing.
- Utilising Google BigQuery for data management and executing complex SQL queries.
- Implementing query optimisation strategies to boost performance.
- Integrating BigQuery with other Google Cloud services.
Course Format
- Interactive lectures and discussions.
- Extensive exercises and practical practice.
- Hands-on implementation within a live-lab environment.
Course Customisation Options
- To request customised training for this course, please contact us to make arrangements.
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 Optimisation
- Query performance optimisation 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
Need help picking the right course?
southafrica@nobleprog.co.za or +27 (0)10 005 5793
Google BigQuery Training Course - Enquiry
Testimonials (2)
The final day which is the Machine Learning Topic
John Erick Baltazar - Globe Telecom
Course - Google BigQuery
The scheduling of every topic and the breaks inserted it helps in digesting the information specially to the newbie to the topic
Jerico Torres - Globe Telecom
Course - Google BigQuery
Related Courses
Google Cloud Platform Fundamentals and Core Service
24 HoursThis instructor-led, live training in Botswana (online or onsite) is aimed at beginner-level IT professionals who wish to use Google Cloud Platform to understand core services, deploy cloud workloads, and follow operational best practices.
By the end of this training, participants will be able to explain core Google Cloud services, deploy basic workloads, and apply security and monitoring practices.
Introduction to Google Analytics
7 HoursThis instructor-led, live training in Botswana (online or on-site) is aimed at data analysts who wish to use Google Analytics to track and report website data.
By the end of this training, participants will be able to:
- Set up Google Analytics to collect website data.
- Create and analyze reports.
- Gain insights and make data-driven decisions.
Architecting with Google Compute Engine
21 HoursThis three-day instructor-led class introduces participants to the comprehensive and flexible infrastructure and platform services provided by Google Cloud Platform, with a focus on Compute Engine. Through a combination of presentations, demos, and hands-on labs, participants explore and deploy solution elements, including infrastructure components such as networks, systems, and application services. This course also covers deploying practical solutions including securely interconnecting networks, customer-supplied encryption keys, security and access management, quotas and billing, and resource monitoring.
Google Certified Associate Cloud Engineer
35 HoursThis instructor-led, live training in Botswana (online or onsite) is designed for intermediate-level IT professionals who wish to develop expertise in managing cloud infrastructure and services on Google Cloud.
Upon completion of this training, participants will be able to:
- Establish and configure cloud environments using Google Cloud services.
- Administer and configure virtual machines, storage solutions, and networking.
- Deploy and monitor applications within GCP environments.
- Implement security best practices and manage identities.
- Utilise Google Cloud tools for automation and troubleshooting.
Google Cloud AutoML
7 HoursThis instructor-led, live training in Botswana (online or onsite) is designed for data scientists, data analysts, and developers who wish to explore AutoML products and features to create and deploy custom ML training models with minimal effort.
Upon completion of this training, participants will be equipped to:
- Explore the AutoML product suite to implement diverse services for various data types.
- Prepare and label datasets to generate custom ML models.
- Train and manage models to ensure the production of accurate and fair machine learning outcomes.
- Utilize trained models to make predictions that align with business objectives and needs.
Google Cloud Platform Basics and Management
21 HoursThis instructor-led, live training in Botswana (online or onsite) is aimed at beginner-level IT professionals who wish to manage and operate the Google Cloud Platform.
By the end of this training, participants will be able to:
- Understand the core services and infrastructure of GCP.
- Learn how to manage networks and virtual machines.
- Understand and apply general security best practices in GCP.
- Explore Kubernetes and container management in GCP.
- Learn about storage options and how to configure them.
- Deploy and configure databases on GCP.
Google Cybersecurity Professional
35 HoursIn this programme, you will acquire high-demand skills that will prepare you for employment in a short period. No academic qualifications or prior experience are necessary.
What you will learn
-
Grasp the significance of cybersecurity practices and their influence on organisations.
-
Recognise common risks, threats, and vulnerabilities, as well as techniques to mitigate them.
-
Shield networks, devices, personnel, and data from unauthorised access and cyberattacks using Security Information and Event Management (SIEM) tools.
-
Gain practical experience with Python, Linux, and SQL.
Google Digital Marketing & E-commerce Professional
35 HoursWhat you'll learn
-
Master the core principles of digital marketing and e-commerce to equip yourself with the competencies needed for an entry-level position
-
Draw in and interact with clients via digital channels such as search engines and email
-
Evaluate marketing effectiveness through analytics and communicate key insights
-
Construct e-commerce stores, assess online performance metrics, and foster customer loyalty
Google Docs - 1 Day
7 HoursGoogle Docs stores your documents in the cloud, allowing you to access them from any computer or device. You can create and edit documents directly in your web browser without needing special software. Additionally, multiple people can collaborate simultaneously, view changes in real time, and rely on automatic saving for every modification.
During this course, you will learn to open Google Docs, create and format new documents, and apply templates. You will enhance your documents using features such as tables of contents, headers and footers, tables, drawings, and images. You will also learn how to share documents and understand sharing options, collaborator roles, and permissions. The course covers managing document versions, working in real time with others, and creating and managing comments and action items. You will explore various Google Docs tools, set preferences to match your work style, and utilise features like Google Explore to add value to your content.
Mastering Google Earth Pro
21 HoursThis instructor-led live training in Botswana (online or on-site) is designed for intermediate to advanced GIS professionals seeking to apply Google Earth Pro for mapping, data visualisation, and geographic analysis.
By the end of this training, participants will be able to:
- Master the Google Earth Pro user interface and comprehend the utility of its diverse tools and settings.
- Efficiently navigate the globe through search functions, coordinate inputs, and various viewing modes within Google Earth Pro.
- Create, edit, and employ placemarks, paths, and polygons to identify and analyse geographical sites.
- Leverage Google Earth Pro for sophisticated visualisation, encompassing 3D structures, historical imagery, and integrated street views.
Google IT Support Professional
35 HoursWhat you'll learn
-
Gain skills required to succeed in an entry-level IT job
-
Learn to perform day-to-day IT support tasks including computer assembly, wireless networking, installing programs, and customer service
-
Learn how to provide end-to-end customer support, ranging from identifying problems to troubleshooting and debugging
-
Learn to use systems including Linux, Domain Name Systems, Command-Line Interface, and Binary Code
Google Kubernetes Engine (GKE)
14 HoursIn this instructor-led live training, participants will learn how to set up and manage a production-scale container environment using Kubernetes on Google Cloud.
By the end of this training, participants will be able to:
- Configure and manage Kubernetes on Google Cloud.
- Deploy, manage and scale a Kubernetes cluster.
- Deploy containerized (Docker) applications on Google Cloud.
- Migrate an existing Kubernetes environment from on-premise to Google Cloud.
- Integrate Kubernetes with third-party continuous integration (CI) software.
- Ensure high availability and disaster recovery in Kubernetes.
Google Maps API for Developers
14 HoursThis instructor-led, live training in Botswana (online or onsite) is designed for developers who wish to enhance their website or web application by adding geo-location functionality via Google Maps.
Upon completion of this training, participants will be able to:
- Embed a map into a new or existing website or web application.
- Display live data that synchronises with the current location.
- Create a mashup incorporating Google Maps.
- Apply best practices for CSS and JavaScript coding.
- Create a custom map for an application.
Google Sheets - 1 Day
7 HoursKEY LEARNING OUTCOMES
-
Add, import, manage, and format data using Google Sheets.
-
Filter, summarise, and protect data within Google Sheets.
-
Perform calculations and visualise spreadsheet data effectively.
-
Apply best practices for sharing and collaborating in Google Sheets.
Google Slides: Professional Presentation & Collaboration
7 HoursGoogle Slides empowers you to design and deliver polished presentations for sales pitches, project updates, training sessions, and beyond.
All your Google Slides presentations are securely stored in the cloud. You create content directly within your web browser, eliminating the need for specialized software. A key advantage is real-time collaboration: multiple users can work on the same deck simultaneously, view each other’s edits instantly, and rely on automatic saving. This course will guide you through opening Google Slides, creating new presentations from scratch or using pre-designed templates, and mastering themes and layout structures. You will learn to add and format text, images, tables, and charts, as well as utilise speaker notes. Further, you will discover how to apply slide transitions and animations to enhance visual impact. The curriculum also covers slide organization techniques, such as sorting, duplicating, importing, copying, and hiding slides. You will gain skills in sharing presentations, understanding collaborator permissions, tracking version history, and managing changes. With features designed to simplify teamwork, you will learn to utilise comments and action items for effective group collaboration. As the primary objective is to present your work, you will also master the tools required to deliver your slides confidently to an audience.