{"course":{"productid":36646,"modality":1,"active":true,"language":"fr","title":"Gemini in BigQuery for Data Practitioners","productcode":"GBQDP","vendorcode":"GO","vendorname":"Google","fullproductcode":"GO-GBQDP","courseware":{"has_ekit":false,"has_printkit":true,"language":""},"url":"https:\/\/portal.flane.ch\/course\/google-gbqdp","objective":"<ul>\n<li>Define the features of Gemini in BigQuery that aid the datato-AI pipeline.<\/li><li>Explore data with Insights and Table Explorer.<\/li><li>Develop code with Gemini assistance.<\/li><li>Discover and visualize workflow with data canvas.<\/li><li>Explain the workflow of using AI\/ML models for predictive and generative tasks in BigQuery.<\/li><li>Create a solution for leveraging Gemini models in BigQuery with SQL queries and Jupyter Notebooks.<\/li><\/ul>","essentials":"<ul>\n<li>Prior experience with programming languages including SQL and\/or Python.<\/li><li>Basic knowledge of ML and generative AI.<\/li><\/ul>","audience":"<p>Data analysts, data engineers, and other data professionals who wish to use Gemini in BigQuery to boost productivity and understand their unstructured data.<\/p>","outline":"<h4>Module 1 - Gemini on BigQuery<\/h4><p>\n<strong>Topics:<\/strong><\/p>\n<ul>\n[list]\n<li>Gemini on Google Cloud<\/li><li>Overview of Gemini on BigQuery<\/li><li>Introduction to course use case<\/li><\/ul><p>\n<strong>Objectives:<\/strong><\/p>\n<ul>\n<li>Understand capabilities of Gemini on Google Cloud.<\/li><li>Understand capabilities of Gemini on BigQuery.<\/li><\/ul><h4>Module 2 - Data Exploration and Preparation<\/h4><p>\n<strong>Topics:<\/strong><\/p>\n<ul>\n<li>Data exploration and preparation<\/li><li>Insights<\/li><li>Table Explorer<\/li><\/ul><p>\n<strong>Objectives:<\/strong><\/p>\n<ul>\n<li>Discover tools that support data exploration.<\/li><li>Identify the benefits and restrictions of Insights and Table Explorer.<\/li><li>Explore data cleaning and pipeline development features in BigQuery.<\/li><\/ul><p>\n<strong>Activities:<\/strong><\/p>\n<ul>\n<li>Lab: Explore Data with Gemini in BigQuery<\/li><\/ul><h4>Module 3 - Code Development with Gemini<\/h4><p>\n<strong>Topics:<\/strong><\/p>\n<ul>\n<li>Gemini for writing code<\/li><li>Troubleshooting and testing with Gemini<\/li><li>Prompting best practices<\/li><\/ul><p>\n<strong>Objectives:<\/strong><\/p>\n<ul>\n<li>Explore using Gemini for writing code.<\/li><li>Identify how Gemini can assist with troubleshooting.<\/li><li>Discover prompting best practices.<\/li><\/ul><p>\n<strong>Activities:<\/strong><\/p>\n<ul>\n<li>Lab: Develop Code with Gemini in BigQuery<\/li><\/ul><h4>Module 4 - Data Canvas<\/h4><p>\n<strong>Topics:<\/strong><\/p>\n<ul>\n<li>Introduction to Data Canvas<\/li><li>Data Canvas capabilities<\/li><li>Prompting best practices for Data Canvas<\/li><\/ul><p>\n<strong>Objectives:<\/strong><\/p>\n<ul>\n<li>Explore Data Canvas features.<\/li><li>Discover prompting best practices for Data Canvas.<\/li><\/ul><p>\n<strong>Activities:<\/strong><\/p>\n<ul>\n<li>Lab: Use Data Canvas to Visualize and Design Queries<\/li><\/ul><h4>Module 5 - Working with Gemini Models in BigQuery<\/h4><p>\n<strong>Topics:<\/strong><\/p>\n<ul>\n<li>BigQuery ML<\/li><li>Using Gemini in your SQL queries<\/li><li>Gemini in BigQuery Notebooks<\/li><\/ul><p>\n<strong>Objectives:<\/strong><\/p>\n<ul>\n<li>Discover the capabilities of BigQuery ML.<\/li><li>Explore using Gemini in your SQL queries.<\/li><li>Explore using Gemini in Jupyter Notebooks.<\/li><\/ul><p>\n<strong>Activities:<\/strong><\/p>\n<ul>\n<li>Lab: Analyze Customer Reviews with SQL<\/li><li>Lab: Analyze Customer Reviews with Python Notebooks<\/li><\/ul>","summary":"<p>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.<\/p>","objective_plain":"- Define the features of Gemini in BigQuery that aid the datato-AI pipeline.\n- Explore data with Insights and Table Explorer.\n- Develop code with Gemini assistance.\n- Discover and visualize workflow with data canvas.\n- Explain the workflow of using AI\/ML models for predictive and generative tasks in BigQuery.\n- Create a solution for leveraging Gemini models in BigQuery with SQL queries and Jupyter Notebooks.","essentials_plain":"- Prior experience with programming languages including SQL and\/or Python.\n- Basic knowledge of ML and generative AI.","audience_plain":"Data analysts, data engineers, and other data professionals who wish to use Gemini in BigQuery to boost productivity and understand their unstructured data.","outline_plain":"Module 1 - Gemini on BigQuery\n\n\nTopics:\n\n\n[list]\n- Gemini on Google Cloud\n- Overview of Gemini on BigQuery\n- Introduction to course use case\n\nObjectives:\n\n\n- Understand capabilities of Gemini on Google Cloud.\n- Understand capabilities of Gemini on BigQuery.\nModule 2 - Data Exploration and Preparation\n\n\nTopics:\n\n\n- Data exploration and preparation\n- Insights\n- Table Explorer\n\nObjectives:\n\n\n- Discover tools that support data exploration.\n- Identify the benefits and restrictions of Insights and Table Explorer.\n- Explore data cleaning and pipeline development features in BigQuery.\n\nActivities:\n\n\n- Lab: Explore Data with Gemini in BigQuery\nModule 3 - Code Development with Gemini\n\n\nTopics:\n\n\n- Gemini for writing code\n- Troubleshooting and testing with Gemini\n- Prompting best practices\n\nObjectives:\n\n\n- Explore using Gemini for writing code.\n- Identify how Gemini can assist with troubleshooting.\n- Discover prompting best practices.\n\nActivities:\n\n\n- Lab: Develop Code with Gemini in BigQuery\nModule 4 - Data Canvas\n\n\nTopics:\n\n\n- Introduction to Data Canvas\n- Data Canvas capabilities\n- Prompting best practices for Data Canvas\n\nObjectives:\n\n\n- Explore Data Canvas features.\n- Discover prompting best practices for Data Canvas.\n\nActivities:\n\n\n- Lab: Use Data Canvas to Visualize and Design Queries\nModule 5 - Working with Gemini Models in BigQuery\n\n\nTopics:\n\n\n- BigQuery ML\n- Using Gemini in your SQL queries\n- Gemini in BigQuery Notebooks\n\nObjectives:\n\n\n- Discover the capabilities of BigQuery ML.\n- Explore using Gemini in your SQL queries.\n- Explore using Gemini in Jupyter Notebooks.\n\nActivities:\n\n\n- Lab: Analyze Customer Reviews with SQL\n- Lab: Analyze Customer Reviews with Python Notebooks","summary_plain":"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.","version":"1.0","duration":{"unit":"d","value":1,"formatted":"1 jour"},"pricelist":{"List Price":{"US":{"country":"US","currency":"USD","taxrate":null,"price":595},"DE":{"country":"DE","currency":"EUR","taxrate":19,"price":950},"CA":{"country":"CA","currency":"CAD","taxrate":null,"price":820},"AT":{"country":"AT","currency":"EUR","taxrate":20,"price":950},"SE":{"country":"SE","currency":"EUR","taxrate":25,"price":950},"SI":{"country":"SI","currency":"EUR","taxrate":20,"price":950},"CH":{"country":"CH","currency":"CHF","taxrate":8.1,"price":950},"IT":{"country":"IT","currency":"EUR","taxrate":20,"price":650}}},"lastchanged":"2026-03-12T22:21:49+01:00","parenturl":"https:\/\/portal.flane.ch\/swisscom\/fr\/json-courses","nexturl_course_schedule":"https:\/\/portal.flane.ch\/swisscom\/fr\/json-course-schedule\/36646","source_lang":"fr","source":"https:\/\/portal.flane.ch\/swisscom\/fr\/json-course\/google-gbqdp"}}