Google BigQuery Training Course
Google BigQuery is a powerful serverless data warehousing and analytics platform that provides tools to query and analyze large datasets, optimize query performance, integrate with other GCP services, and even build machine learning models.
This instructor-led, live training (online or onsite) is aimed at advanced-level data analysts who wish to learn how to use Google BigQuery for data querying, optimization, and machine learning integration.
By the end of this training, participants will be able to:
- Understand the fundamentals of Google BigQuery and its use for data analytics and cloud computing.
- Use Google BigQuery for data management and complex SQL queries.
- Implement query optimization strategies to improve performance.
- Integrate BigQuery with other Google Cloud services.
Format of the Course
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
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
Open Training Courses require 5+ participants.
Google BigQuery Training Course - Booking
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
Upcoming Courses
Related Courses
Google Cloud Platform Fundamentals and Core Service
24 HoursThis instructor-led, live training in Slovenia (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 Slovenia (online or onsite) 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.
Google Certified Associate Cloud Engineer
35 HoursThis instructor-led, live training in Slovenia (online or onsite) is aimed at intermediate-level IT professionals who wish to gain expertise in managing cloud infrastructure and services on Google Cloud.
By the end of this training, participants will be able to:
- Set up and configure cloud environments using Google Cloud services.
- Manage and configure virtual machines, storage, and networking.
- Deploy and monitor applications in GCP environments.
- Implement security best practices and identity management.
- Use Google Cloud tools for automation and troubleshooting.
Google Cloud Platform Basics and Management
21 HoursThis instructor-led, live training in Slovenia (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 program, you’ll learn in-demand skills that will have you job-ready in a very short time. No degree or experience required.
What you'll learn
-
Understand the importance of cybersecurity practices and their impact for organizations.
-
Identify common risks, threats, and vulnerabilities, as well as techniques to mitigate them.
-
Protect networks, devices, people, and data from unauthorized access and cyberattacks using Security Information and Event Management (SIEM) tools.
-
Gain hands-on experience with Python, Linux, and SQL.
Google Digital Marketing & E-commerce Professional
35 HoursWhat you'll learn
-
Learn the fundamentals of digital marketing and e-commerce to gain the skills needed to land an entry-level job
-
Attract and engage customers through digital marketing channels like search and email
-
Measure marketing performance through analytics and present insights
-
Build e-commerce stores, analyze online performance, and grow customer loyalty
Google Docs - 1 Day
7 HoursWith Google Docs, your documents are stored in the cloud, and you can access them from any computer or device. You create and edit documents right in your web browser; no special software is required. Even better, multiple people can work at the same time, you can see people’s changes as they make them, and every change is saved automatically.
In this course, you will learn how to open Google Docs, create and format a new document, and apply a template to a new document. You will learn how to enhance your documents using a table of contents, headers and footers, tables, drawings, images, and more. You will learn how to share your documents with others. We will discuss your sharing options and examine collaborator roles and permissions. You will learn how to manage versions of your documents. Google Docs allows you to work in real time with others on the same document. You will learn how to create and manage comments and action items in your documents. We will review a few of the Google Docs tools. You will understand how to set your preferences to suit your own work style and explore how to use tools such as Google Explore to add value to your content.
Mastering Google Earth Pro
21 HoursThis instructor-led, live training in Slovenia (online or onsite) is aimed at intermediate-to-advanced level GIS professionals who wish to learn how to use Google Earth Pro for mapping, data visualization, and geographic analysis.
By the end of this training, participants will be able to:
- Learn to navigate the user interface of Google Earth Pro and understand the functionality of its various tools and options.
- Efficiently navigate the globe using Google Earth Pro, including the use of search functions, coordinates, and various view modes.
- Create, edit, and utilize placemarks, paths, and polygons to mark and analyze geographical locations.
- Use Google Earth Pro for advanced visualization, including 3D buildings, historical imagery, and street view integration.
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 Sheets - 1 Day
7 HoursWHAT YOU WILL LEARN
-
Add, import, manage, and format data using Google Sheets.
-
Filter, summarize, and protect data in Google Sheets.
-
Perform calculations and visualize your spreadsheet data.
-
Apply best practices to share and collaborate in Google Sheets.
Google Slides: Professional Presentation & Collaboration
7 HoursWith Google Slides, you can create and present professional presentations for sales, projects, training modules, and much more.
Google Slides presentations are stored safely in the cloud. You build presentations right in your web browser—no special software is required. Even better, multiple people can work on your slides at the same time, you can see people’s changes as they make them, and every change is automatically saved. You will learn how to open Google Slides, create a blank presentation, and create a presentation from a template. You will explore themes, layout options, and how to add and format content, and speaker notes in your presentations. You will learn how to enhance your slides by adding tables, images, charts, and more. You will also learn how to use slide transitions and object animations in your presentation for visual effects. We will discuss how to organize slides and explore some of the options, including duplicating and ordering your slides, importing existing slides, copying slides, and hiding slides. You will learn how to share your presentation with others and will also learn about collaborator permissions, tracking changes, and version management. Google Slides offers many features that make team collaboration easy. You will learn how to collaborate with your team using comments and action items. Presenting your slides is the ultimate goal so you will learn how to present your slides to others and explore the presentation tools available.
Google Workspace for Commercial Managers
7 HoursThis instructor-led, live training in Slovenia (online or onsite) is aimed at beginner-level commercial managers who wish to use Google Workspace tools to enhance productivity, collaboration, and organization within their respective roles.
By the end of this training, participants will be able to:
- Understand the basics of Google Workspace.
- Effectively schedule and manage meetings using Google Calendar.
- Confidently host, join, and manage virtual meetings, and use collaboration features like screen sharing.
- Create professional documents, use collaboration features, and convert documents to various formats.
- Create, format, and share presentations, and collaborate with others on the same presentation.
Google Workspace: Communication, Collaboration, and Productivity
14 HoursGoogle Workspace is a suite of cloud-based tools designed to enhance communication, collaboration, and productivity in both professional and academic environments. This blended training combines virtual and in-person sessions to provide participants with practical skills for effectively using Gmail, Calendar, Meet, Drive, Docs, Sheets, Slides, and Chat/Gemini, with hands-on activities and guided practice.
This instructor-led, live training (online and onsite) is aimed at beginner-level to intermediate-level professionals who wish to strengthen their use of Google Workspace to streamline teamwork and operations.
By the end of this training, participants will be able to:
- Organize and manage email, events, and meetings effectively with Gmail, Calendar, and Meet.
- Collaborate in real time using Google Drive, Docs, Sheets, and Slides.
- Apply communication tools like Chat/Gemini to streamline team interactions.
- Develop practical outputs such as schedules, collaborative reports, dashboards, and presentations.
Format of the Course
- Blended learning: 2 hours virtual + 12 hours in-person sessions.
- Interactive lecture and discussion.
- Hands-on exercises, group projects, and simulations.
- Video tutorials and guided virtual practice activities.
Course Customization Options
- To request a customized version tailored to your organization’s processes, please contact us to arrange.
Google Workspace (G Suite) Essentials
7 HoursGoogle Workspace is a cloud-based suite of productivity and collaboration tools designed to streamline communication, file sharing, and team productivity. This course covers the essential apps and features to help participants work more efficiently and collaboratively.
This instructor-led, live training (online or onsite) is aimed at beginner-level to intermediate-level users who wish to get the most out of Google Workspace tools for daily work and collaboration.
By the end of this training, participants will be able to:
- Use Gmail for professional communications.
- Manage files securely in Google Drive.
- Run effective meetings in Google Meet.
- Collaborate in real time with Docs, Sheets, and Slides.
- Organize schedules with Google Calendar.
- Communicate quickly using Google Chat.
- Create forms and collect responses with Google Forms.
- Capture ideas and manage tasks with Keep and Tasks.
Format of the Course
- Interactive lecture and discussion.
- Hands-on exercises and practice.
- Live demonstrations.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
Optimizing Analytics and Machine Learning with Google BigQuery
14 HoursGoogle BigQuery is a fully managed, serverless data warehouse that supports cost-efficient query optimization, predictive analytics with BigQuery ML, and seamless data ingestion for analytics workflows. It is designed for teams that want to maximize query efficiency, build machine learning models directly in SQL, and streamline reporting pipelines.
This instructor-led, live training (online or onsite) is aimed at teams with a basic understanding of SQL who wish to optimize queries, use BigQuery ML for predictive modeling, and improve ingestion and transformation processes for reporting.
By the end of this training, participants will be able to:
- Optimize queries in BigQuery to improve performance and reduce costs.
- Use BigQuery ML to build, train, and evaluate predictive models.
- Design efficient data ingestion and transformation pipelines for reporting.
- Apply best practices for scaling analytics in Google BigQuery.
Format of the Course
- Interactive lecture and discussion.
- Hands-on labs with Google BigQuery and BigQuery ML.
- Practical exercises for query optimization and pipeline design.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.