Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
3 Hour(s) 17 Minute(s)
Language
English
Taught by
Brain Analytix, Michał Kałucki
Rating
2 views
Course Overview
On Linear Regression example
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!
Course Content
- 9 section(s)
- 48 lecture(s)
- Section 1 Before start the Course
- Section 2 Introduction - basic concepts and theory
- Section 3 Creating first model and prediction
- Section 4 Data cleaning
- Section 5 Feature engineering
- Section 6 Feature engineering - built-in function
- Section 7 Hyperparameters tuning
- Section 8 Final prediction and model testing
- Section 9 Extra Section: Boosted Tree Algorithm
What You’ll Learn
- Create Machine Learning model and make prediction using only SQL code
- Evaluate and interpret model prediction quality
- Do Feature Engineering on different data types
- Clean up and limit data source with understanding of consequence of it
Reviews
-
HHatice SÖNMEZ
so far so good
-
PPwn
Great course so far, it is easy to follow with captions on. Of all the courses I have taken on UDEMY, this course packs the most useful information into each lesson as I have seen. Each lesson is a perfect balance of length and information content.
-
MMercier Benjamin
Well explained and in depth course for learning and improving Big Query and ML Machine learning. Good balance between content and exercices.
-
KKrystek Krystek
Świetny kurs
