Course
digicode: GBQDP
Gemini in BigQuery for Data Practitioners
This course demonstrates how to use AI/ML models for generative AI tasks in BigQuery.
Duration
1 day
Price
850.–
exkl. 8.1% MWST
Course facts
- Defining the features of Gemini in BigQuery that aid the datato-AI pipeline
- Exploring data with Insights and Table Explorer
- Developing code with Gemini assistance
- Discovering and visualizing workflow with data canvas
- Explaining the workflow of using AI/ML models for predictive and generative tasks in BigQuery
- Creating a solution for leveraging Gemini models in BigQuery with SQL queries and Jupyter Notebooks
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.
1 Gemini on BigQuery
- Gemini on Google Cloud
- Overview of Gemini on BigQuery
- Introduction to course use case
- Understand capabilities of Gemini on Google Cloud.
- Understand capabilities of Gemini on BigQuery.
2 Data Exploration and Preparation
- Insights
- Table Explorer
- 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.
- Lab: Explore Data with Gemini in BigQuery
3 Code Development with Gemini
- Gemini for writing code
- Troubleshooting and testing with Gemini
- Prompting best practices
- Explore using Gemini for writing code.
- Identify how Gemini can assist with troubleshooting.
- Discover prompting best practices.
- Lab: Develop Code with Gemini in BigQuery
4 Data Canvas
- Data Canvas capabilities
- Prompting best practices for Data Canvas
- Explore Data Canvas features.
- Discover prompting best practices for Data Canvas.
- Lab: Use Data Canvas to Visualize and Design Queries
5 Working with Gemini Models in BigQuery
- BigQuery ML
- Using Gemini in your SQL queries
- Gemini in BigQuery Notebooks
- Discover the capabilities of BigQuery ML.
- Explore using Gemini in your SQL queries.
- Explore using Gemini in Jupyter Notebooks.
- Lab: Analyze Customer Reviews with SQL
- Lab: Analyze Customer Reviews with Python Notebooks
Data analysts, data engineers, and other data professionals who wish to use Gemini in BigQuery to boost productivity and understand their unstructured data.
- Prior experience with programming languages including SQL and/or Python
- Basic knowledge of ML and generative AI
Products:
- Gemini
- BigQuery
- Vertex AI