|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/google-bigquery-ml-machine-learning-in-sql-without-python/
课程评论：没有评论
**课程名称：** Google BigQuery ML - SQL 中的机器学习（不使用 Python） **课程概述：** 本课程旨在教授如何直接在 Google BigQuery 界面中使用 SQL 查询来创建和使用机器学习模型。您将学会如何准备数据、解读模型结果，并仅通过一个 SELECT 语句进行准确预测。我们将使用真实的美国汽车销售数据，目标是预测汽车价格。 课程共包含 7 个主要章节和 1 个奖励章节。首先，我们将搭建实验环境。随后，我们会进行必要的理论讲解，然后直接开始创建第一个模型。接下来的课程将重点讲解如何通过一些技巧和窍门来优化模型性能，这是本课程的重中之重。在此过程中，您将获得所需的所有资源，并可以在自己的免费 BigQuery 账户上进行实践。 **课程项目：** 您将在本次课程中完成一个独立项目，我们将一步步指导您完成项目的每个环节。每节实践课后，都有一个作业，将直接计入您的最终项目。项目的核心目标是预测二手车价格。为了激励您学习并验证您的作业完成情况，每次作业后都会有相应的测验题，您可以轻松找到答案。 **课程资源：** 我们提供了多种学习资源，包括： * **Google 机器学习术语词汇表电子书：** 帮助您系统化理解机器学习的基础定义。 * **速查表 (Cheat Sheets)：** 对每个主题进行高度概括，方便您快速回顾和查询。 * **SQL 代码示例：** 在资源区提供，方便您复制、粘贴和自行修改练习。 让我们一起踏上 SQL 机器学习的探索之旅吧！
The goal of this course is to learn how to create and use Machine Learning models right from the level of SQL query in Google BigQuery interface. You will also learn how to prepare data, how to interpret model results and how to make nice predictions using just one SELECT statement. You will work on a real data set - car sale offers in the USA, and the goal will be to predict the price of a car.The course consists of 7 sections and one bonus section. At the very beginning we will create an environment to work in. Next it would be good to see a little theory. Then we will straight jump into the first model creation. In further lessons we will try to improve our model performance by some hacks and tricks. This is essential for the course and we put the biggest pressure on that part. In the meantime you will get all needed resources and you will be able to practice all steps by yourself on your own free BigQuery account.In this course you will be working on your own end project. During the course, we will guide you on how to make every step of your own end project. After each practical lesson, you will have a homework assignment that will contribute to your big project. The project's goal is to predict used car prices. Additionally, to motivate you to work and check if you have done your homework correctly, you will get a question in the quiz. By carrying out practical tasks, you will easily find answers.We've added a few lesson resources. Google glossary ebook that explains all basic definitions of a wide spectrum of Machine Learning. Please read them to systematize your knowledge. Other resources are cheat sheets which present a summary for each topic. It's a really nice source of condensed knowledge. Please use them to quickly look if you forgot some stuff. For practice lessons we add our SQL in resources. You can easily copy-paste and manipulate the code by yourself.Let's get started with our journey of Machine Learning in SQL!
