Gemini in BigQuery for Data Practitioners
Overview
This course demonstrates how to use AI/ML models for generative AI tasks in BigQuery. Through a practical use case involving customer relationship management, you learn the workflow of solving a business problem with Gemini models. To facilitate comprehension, the course also provides step-by-step guidance through coding solutions using both SQL queries and Python notebooks.
What You'll Learn
- Define the features of Gemini in BigQuery that aid the data-to-AI pipeline.
- Explore data with Insights and Table Explorer.
- Develop code with Gemini assistance.
- Discover and visualize workflow with data canvas.
- Explain the workflow of using AI/ML models for predictive and generative tasks in BigQuery.
- Create a solution for leveraging Gemini models in BigQuery with SQL queries and Jupyter Notebooks.
Who Should Attend
Data analysts, data engineers, and other data professionals who wish to use Gemini in BigQuery to boost productivity and understand their unstructured data.
Prerequisites
Prior experience with programming languages including SQL and/or Python. Basic knowledge of ML and generative AI.
Products Covered
Course Modules
Gemini on BigQuery
Topics
- Gemini on Google Cloud
- Overview of Gemini on BigQuery
- Introduction to course use case
Learning Outcomes
- Understand capabilities of Gemini on Google Cloud.
- Understand capabilities of Gemini on BigQuery.
Data Exploration and Preparation
Topics
- Data exploration and preparation
- Insights
- Table Explorer
Learning Outcomes
- Discover tools that support data exploration.
- Identify the benefits and restrictions of Insights and Table Explorer.
- Explore data cleaning and pipeline development features in BigQuery.
Activities
Code Development with Gemini
Topics
- Gemini for writing code
- Troubleshooting and testing with Gemini
- Prompting best practices
Learning Outcomes
- Explore using Gemini for writing code.
- Identify how Gemini can assist with troubleshooting.
- Discover prompting best practices.
Activities
Data Canvas
Topics
- Introduction to Data Canvas
- Data Canvas capabilities
- Prompting best practices for Data Canvas
Learning Outcomes
- Explore Data Canvas features.
- Discover prompting best practices for Data Canvas.
Activities
Working with Gemini Models in BigQuery
Topics
- BigQuery ML
- Using Gemini in your SQL queries
- Gemini in BigQuery Notebooks
Learning Outcomes
- Discover the capabilities of BigQuery ML.
- Explore using Gemini in your SQL queries.
- Explore using Gemini in Jupyter Notebooks.
Activities
Get This Training
No public classes currently scheduled. Express interest below or request private training.
Course Details
- Course Code
- T-GBQDP-I
- Duration
- 1 day
- Format
- ILT
- Level
- Intermediate
- Modules
- 5
- Activities
- 10
- Price
- Loading...
Questions About This Course?
Contact us for custom scheduling, group discounts, or curriculum customization.
Contact Us