Google BigQuery Training Course
Google BigQuery is a robust serverless data warehousing and analytics platform equipped with tools to query and analyze vast datasets, enhance query performance, integrate with other Google Cloud Platform (GCP) services, and even construct machine learning models.
This instructor-led live training, available either online or onsite, targets advanced data analysts keen on mastering Google BigQuery for data querying, optimization, and machine learning integration.
Upon completion of this training, participants will be capable of:
- Grasping the core concepts of Google BigQuery and its application in data analytics and cloud computing.
- Utilizing Google BigQuery for 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.
- Extensive exercises and practical sessions.
- Hands-on implementation within a live laboratory 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
- Fundamental 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 Nigeria (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 Nigeria (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.
Architecting with Google Compute Engine
21 HoursThis three-day instructor-led programme 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 Nigeria (online or on-site) is designed for 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 Nigeria (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 Nigeria (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 HoursThis programme equips you with highly sought-after skills that will make you job-ready in a remarkably short timeframe. There is no need for a degree or prior experience.
What you'll learn
-
Grasp the significance of cybersecurity practices and their effect on organisations.
-
Spot common risks, threats, and vulnerabilities, alongside methods to mitigate them.
-
Safeguard networks, devices, personnel, and data against 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 will learn
-
Gain the fundamentals of digital marketing and e-commerce to develop the skills required for an entry-level position
-
Attract and engage customers using digital marketing channels such as search engines and email
-
Evaluate marketing performance through analytics and present key insights
-
Build e-commerce stores, analyse online performance, 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. Even better, multiple people can work on the same document simultaneously; you can see changes as they happen, and every modification is saved automatically.
In this course, you will learn how to open Google Docs, create and format a new document, and apply templates. You will explore ways to enhance your documents using features like a table of contents, headers and footers, tables, drawings, and images. You will also discover how to share documents with others, discussing sharing options and examining collaborator roles and permissions. Additionally, you will learn to manage document versions, work in real time with others, and create and manage comments and action items. We will review key Google Docs tools, show you how to set preferences to match your work style, and demonstrate how to use tools like Google Explore to add value to your content.
Mastering Google Earth Pro
21 HoursThis instructor-led, live training in Nigeria (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 the 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 in Nigeria, 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 Nigeria (online or onsite) is designed for developers who want to enhance their websites or web applications by adding geo-location functionality via 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 empowers you to design and deliver professional presentations tailored for sales pitches, project updates, training sessions, and a wide variety of other purposes.
All your Google Slides presentations are securely stored in the cloud. You can build your presentations directly within your web browser, eliminating the need for any specialized software. What’s more, multiple users can collaborate on the same slides simultaneously, allowing you to watch changes appear in real-time while every edit is automatically saved. Throughout this course, you will learn how to launch Google Slides, start a blank presentation, and utilise templates to kickstart your work. You will explore various themes and layout options, as well as techniques for adding and formatting content and speaker notes. You will also discover how to elevate your slides by incorporating tables, images, charts, and other elements. Additionally, you will learn to apply slide transitions and object animations to create compelling visual effects. We will cover methods for organizing your slides, including duplicating, arranging, importing, copying, and hiding slides. You will also gain insights into sharing your presentations, understanding collaborator permissions, tracking changes, and managing version history. Google Slides provides numerous features that simplify team collaboration. You will learn how to work effectively with your team using comments and action items. Since the ultimate aim is to present, you will also learn how to deliver your slides to an audience and explore the full range of presentation tools available.