Google BigQuery Training Course
Google BigQuery is a robust serverless data warehousing and analytics platform that equips users with tools to query and analyze vast datasets, enhance query performance, integrate seamlessly with other GCP services, and construct machine learning models.
This instructor-led, live training (available online or onsite) is designed for 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.
- Utilizing Google BigQuery for efficient data management and executing complex SQL queries.
- Applying query optimization strategies to boost performance.
- Integrating BigQuery with other Google Cloud services.
Course Format
- Interactive lectures and discussions.
- Ample exercises and practical application.
- Hands-on implementation within a live-lab environment.
Course Customization Options
- To request customized training for this course, please get in touch with 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
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 Kenya (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 Kenya (available online or onsite) is designed for data analysts who intend to use Google Analytics to monitor and report on website data.
By the conclusion of this training, participants will be able to:
- Configure Google Analytics to gather website data.
- Generate and analyze reports.
- Extract insights and facilitate 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 Kenya (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:
- Establish and configure cloud environments using Google Cloud services.
- Administer and configure virtual machines, storage systems, and networking.
- Deploy and monitor applications within GCP environments.
- Apply security best practices and manage identities.
- Utilize Google Cloud tools for automation and troubleshooting.
Google Cloud AutoML
7 HoursThis instructor-led live training in Kenya (online or onsite) is designed for data scientists, data analysts, and developers who want 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:
- Navigate the AutoML product suite to implement diverse services for various data types.
- Prepare and annotate datasets to generate custom ML models.
- Train and oversee models to ensure they yield accurate and fair machine learning outcomes.
- Leverage trained models for making predictions that address business goals and needs.
Google Cloud Platform Basics and Management
21 HoursThis instructor-led live training in Kenya (online or onsite) is designed for 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 HoursThis programme equips you with high-demand skills, enabling you to become job-ready in a short timeframe. No prior degree or professional experience is necessary.
Key Learning Outcomes
-
Comprehend the significance of cybersecurity practices and their impact on organisational integrity.
-
Identify prevalent risks, threats, and vulnerabilities, alongside strategies to mitigate them.
-
Defend networks, devices, personnel, and data against unauthorised access and cyber threats using Security Information and Event Management (SIEM) tools.
-
Acquire practical experience with Python, Linux, and SQL.
Google Digital Marketing & E-commerce Professional
35 HoursKey Learning Outcomes
-
Master the core principles of digital marketing and e-commerce to acquire the competencies required for securing an entry-level role
-
Draw in and interact with audiences via digital marketing platforms such as search engines and email
-
Evaluate marketing efficacy through data analytics and communicate actionable insights
-
Develop online stores, monitor digital performance metrics, and cultivate long-term customer loyalty
Google Docs - 1 Day
7 HoursGoogle Docs keeps your documents securely in the cloud, allowing you to access and edit them from any computer or device via your web browser without the need for additional software. It supports simultaneous collaboration, enabling multiple users to work on the same document in real time, with all changes visible and saved automatically.
This course covers the fundamentals of opening Google Docs, creating and formatting new documents, and applying templates. Participants will learn how to enhance their work using features like tables of contents, headers and footers, tables, drawings, and images. The training also addresses sharing documents, exploring sharing options, and understanding collaborator roles and permissions. You will master version management and real-time co-authoring techniques. Additionally, the course includes creating and managing comments and action items, reviewing essential Google Docs tools, customizing preferences to fit your workflow, and utilizing Google Explore to enrich your content.
Mastering Google Earth Pro
21 HoursThis instructor-led live training in Kenya (online or onsite) is tailored for intermediate to advanced GIS professionals aiming to utilize Google Earth Pro for mapping, data visualization, and geographic analysis.
By the conclusion of this course, participants will be able to:
- Navigate the Google Earth Pro user interface effectively and comprehend the functionality of its tools and options.
- Efficiently move across the globe using Google Earth Pro, including utilizing search capabilities, coordinates, and different view modes.
- Create, edit, and apply placemarks, paths, and polygons to mark and analyze geographical locations.
- Leverage Google Earth Pro for advanced visualization, encompassing 3D buildings, historical imagery, and street view integration.
Google IT Support Professional
35 HoursKey Learning Outcomes
-
Acquire the essential skills needed to thrive in an entry-level IT role
-
Master daily IT support duties, such as assembling computers, configuring wireless networks, installing software, and delivering customer service
-
Develop the ability to provide comprehensive customer support, from diagnosing issues to troubleshooting and debugging
-
Gain proficiency in systems including Linux, Domain Name Systems, Command-Line Interface, and Binary Code
Google Kubernetes Engine (GKE)
14 HoursIn this instructor-led live training held in Kenya, 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 Kenya (online or on-site) is designed for developers who wish to enhance their websites or web applications by adding geo-location functionality through Google Maps.
By the end of this training, participants will be able to:
- Embed a map into a new or existing website or web application.
- Display live data that synchronizes with the current location.
- Create a mashup that includes Google Maps.
- Apply good CSS and JavaScript coding practices
- Create a custom map for an application.
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 HoursGoogle Slides enables you to develop and deliver high-quality presentations for sales pitches, project updates, training materials, and beyond.
Your Google Slides presentations are securely stored in the cloud. You create presentations directly within your web browser, eliminating the need for specialized software. Moreover, multiple users can collaborate on slides simultaneously, allowing you to view changes as they happen, with every update automatically saved. You will master opening Google Slides, building a blank presentation, and utilizing pre-designed templates. The course covers exploring themes, layout options, and adding or formatting content, including speaker notes. You will discover how to elevate your slides by incorporating tables, images, charts, and other elements. Additionally, you will learn to use slide transitions and object animations for engaging visual effects. We will examine slide organization techniques, such as duplicating, ordering, importing, copying, and hiding slides. You will also learn to share presentations, manage collaborator permissions, track changes, and handle version control. Google Slides simplifies team collaboration through features like comments and action items. Since presenting is the final objective, you will learn how to deliver your slides effectively and utilize available presentation tools.