BigQuery ML – Machine Learning in Google Cloud with BigQuery

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.”

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..

Course Content

  • Introduction to GCP –> 3 lectures • 17min.
  • BigQuery ML (BQML) introduction –> 6 lectures • 34min.
  • BigQuery Basics – Crash course –> 7 lectures • 23min.
  • Linear Regression –> 19 lectures • 1hr 40min.
  • Hyperparameter Tuning in BigQuery –> 4 lectures • 18min.
  • Model Explainability Functions –> 4 lectures • 13min.
  • Logistic regression –> 9 lectures • 41min.
  • Feature Pre-processing –> 4 lectures • 24min.
  • K-means Clustering –> 9 lectures • 45min.
  • Boosted Trees –> 11 lectures • 1hr 11min.
  • Model management Operations in BigQuery –> 3 lectures • 16min.
  • Deep Neural Network (DNN) –> 12 lectures • 1hr 5min.
  • BigQuery ML Pricing –> 6 lectures • 27min.
  • ARIMA+ for Time series Forecasting –> 12 lectures • 1hr 12min.
  • Additional Learnings –> 1 lecture • 2min.
  • BONUS –> 1 lecture • 3min.

BigQuery ML - Machine Learning in Google Cloud with BigQuery

Requirements

“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

Coming Soon -: Matrix Factorization, PCA

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.
Get Tutorial