Google BigQuery Training Course
Google BigQuery is a robust serverless data warehousing and analytics platform that equips users with tools to query and analyze large datasets, enhance query performance, integrate with other GCP services, and even develop machine learning models.
This instructor-led, live training (available online or onsite) is designed for advanced-level data analysts who want to master Google BigQuery for data querying, optimization, and machine learning integration.
By the end of this training, participants will be able to:
- Grasp the fundamentals of Google BigQuery and its application in data analytics and cloud computing.
- Leverage Google BigQuery for data management and executing complex SQL queries.
- Apply query optimization strategies to boost performance.
- Seamlessly integrate BigQuery with other Google Cloud services.
Course Format
- Interactive lectures and discussions.
- Extensive exercises and practice sessions.
- Hands-on implementation in a live-lab environment.
Course Customization Options
- To request customized 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 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
- Foundational understanding of databases and SQL concepts
Target 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 Taiwan (online or on-site) is designed for 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.
Google AdWords: Beginner to Advanced
7 HoursThis instructor-led live training in Taiwan (online or onsite) is tailored for marketers who wish to employ Google AdWords to launch marketing campaigns.
By the conclusion of this training, participants will be able to:
- Run a Google AdWords campaign designed to capture high-quality leads.
- Develop a Google AdWords campaign intended to drive sales growth.
- Implement bidding strategies to optimize profitability on advertising expenditures.
- Refine existing marketing campaigns utilizing Google AdWords.
Introduction to Google Analytics
7 HoursThis instructor-led live training in Taiwan (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 Taiwan (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 AutoML
7 HoursThis instructor-led, live training in Taiwan (online or onsite) is aimed at 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.
By the end of this training, participants will be able to:
- Explore the AutoML product line to implement different services for various data types.
- Prepare and label datasets to create custom ML models.
- Train and manage models to produce accurate and fair machine learning models.
- Make predictions using trained models to meet business objectives and needs.
Google Cloud Platform Basics and Management
21 HoursThis instructor-led, live training in Taiwan (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.
Mastering Google Earth Pro
21 HoursThis instructor-led live training in Taiwan (online or onsite) targets intermediate-to-advanced GIS professionals who wish to learn how to utilize Google Earth Pro for mapping, data visualization, and geographic analysis.
By the conclusion of this training, participants will be able to:
- Navigate the Google Earth Pro interface and comprehend the functionality of its various tools and options.
- Efficiently traverse 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 Kubernetes Engine (GKE)
14 HoursIn this instructor-led, live training in Taiwan, 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 Taiwan (online or onsite) is designed for developers aiming to enhance their websites or web applications by adding geo-location functionality through Google Maps.
Upon completing this training, participants will be able to:
- Embed maps into new or existing websites or web applications.
- Display real-time data synchronized with the user's current location.
- Create mashups that incorporate Google Maps.
- Implement effective CSS and JavaScript coding practices.
- Develop custom maps tailored for specific applications.
Google Workspace for Commercial Managers
7 HoursThis instructor-led, live training in Taiwan (online or onsite) is designed for beginner-level commercial managers who wish to utilize 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) for Administration
14 HoursThis instructor-led live training in Taiwan (available online or onsite) is designed for system administrators who want to manage and deploy G Suite for their organizations.
Upon completing this training, participants will be able to:
- Implement Google security practices using 2SV and SSO.
- Monitor domain and service usage via reports in the Admin Console.
- Set up and configure the G Suite Admin Console.
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:
- Utilize Gmail for professional communications.
- Manage files securely in Google Drive.
- Conduct 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.
Operational Integration with Trello, QuickBooks, and Google Workspace
20 HoursThis course is tailored for organizations aiming to streamline their daily operations by seamlessly connecting digital platforms such as Trello, QuickBooks, Google Workspace, and the WhatsApp API.
Through this instructor-led live training (available online or onsite), participants will learn to connect and automate workflows, enhance project and financial oversight, and centralize data to support better decision-making.
Upon completion of this training, participants will be able to:
- Connect and automate workflows between Trello, QuickBooks, and Google Workspace.
- Integrate WhatsApp API communication into operational workflows.
- Design multi-platform automation systems focused on efficiency and control.
- Implement security and monitoring policies for active integrations.
- Document and maintain automated processes in operation.
Course Format
- Conceptual explanations and guided demonstrations.
- Practical exercises applied to real-world operational scenarios.
- Hands-on practice using company-specific data and tools.
Course Customization Options
- Adapting the content to the company’s specific platforms and processes.
- Including additional tools such as Zapier, Make/Integromat, or Power Automate.
- Analyzing and designing real data integration flows.