Course Information
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Course Overview
Create Machine Learning models in Google Cloud Big Query using standard SQL. Big query ML course for ML, Data engineers
"BigQuery ML lets you create and execute machine learning models in BigQuery using standard SQL queries."
Big Query ML is a blessing for engineers who want to work in Machine Learning domain but lack programming language like Python, R. With Big Query ML, they can use their existing SQL knowledge to build operational production-grade Machine learning models.
What's included in the course ?
Brief introduction to various Machine Learning services of Google Cloud.
Fundamentals of BigQuery ML and challenges which it solves.
All of the Machine Learning algorithms are explained in 2 Steps :
Step 1 : Theoretical explanation of working of an ML algorithm.
Step 2 : Practical implementation of the ML algorithm in BigQuery ML.
Each and every Machine learning algorithm is explained with HANDS-ON examples.
Hyperparameter tuning of models, Model Explainability functions, Feature pre-processing functions.
Model management operations using bq commands.
BigQuery ML pricing (Flat rate & On-demand pricing models).
Assignment for each Machine learning algorithm for self Hands-On in Big Query ML.
Learn Best practices and Optimization techniques for BigQuery ML.
Machine Learning algorithms explained:
Linear regression
Logistic regression
K-means clustering
Boosted Tree
Deep neural networks
ARIMA+ Time series Forecasting
Product Component Analysis (PCA)
Matrix Factorization
After completing this course, you can confidently start creating production-grade Machine Learning models in Real-world corporate projects using BigQuery ML.
Add-Ons
Questions and Queries will be answered very quickly.
Queries, datasets and references used in lectures are attached in the course for your convenience.
I am going to update it frequently, every time adding new components of Bigquery ML.
Course Content
- 18 section(s)
- 125 lecture(s)
- Section 1 Introduction to GCP
- Section 2 BigQuery ML (BQML) introduction
- Section 3 BigQuery Basics - Crash course
- Section 4 Linear Regression
- Section 5 Hyperparameter Tuning in BigQuery
- Section 6 Model Explainability Functions
- Section 7 Logistic regression
- Section 8 Feature Pre-processing
- Section 9 K-means Clustering
- Section 10 Boosted Trees
- Section 11 Model management Operations in BigQuery
- Section 12 Deep Neural Network (DNN)
- Section 13 Principal Component Analysis (PCA)
- Section 14 BigQuery ML Pricing
- Section 15 Matrix Factorization (Collaborative Filtering)
- Section 16 ARIMA+ for Time series Forecasting
- Section 17 Additional Learnings
- Section 18 Bonus
What You’ll Learn
- BigQuery ML - Learn Machine Learning in Google Cloud using BigQuery.
- Learn to Train, Evaluate, Inference, Tune and Explain Machine leaning models using standard SQL with Big Query.
- Theory + BigQuery ML implementation of many Machine learning algorithms.
- Detailed theory for each of the ML algorithm with a Real-world example implementation in BigQuery ML.
- Linear regression, Logistic regression, K-means clustering, Boosted Tree.
- Deep neural networks, ARIMA+ Time series Forecasting, Matrix Factorization, PCA.
- Hyperparameter tuning of models, Model Explainability functions, Feature pre-processing functions, model management operations in BigQuery ML.
Skills covered in this course
Reviews
-
IINICIATIVAS VIRTUALES DE MEXICO IVM0101291R9
The explication is very clear.
-
GGeorge Falkovich
This curse is amazing as all courses of this author
-
SSatyajit Baliarsingh
excellent content
-
VVincent Yin
Among the many excellent aspects of this course, I particularly like the instructor's step-by-step explanation, diagramming and examples of the math formula behind Neural Networks.