0

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

Machine Learning with BigQuery ML

You're reading from Machine Learning with BigQuery ML Create, execute, and improve machine learning models in BigQuery using standard SQL queries

Product type Paperback

Published in Jun 2021

Publisher Packt

ISBN-13 9781800560307

Length 344 pages

Edition 1st Edition

Languages

Python

Tools

BigQuery

Concepts

Machine Learning

Author (1):

Alessandro Marrandino

View More author details

Table of Contents (20) Chapters

Preface

1. Section 1: Introduction and Environment Setup

2. Chapter 1: Introduction to Google Cloud and BigQuery FREE CHAPTER

3. Chapter 2: Setting Up Your GCP and BigQuery Environment

4. Chapter 3: Introducing BigQuery Syntax

5. Section 2: Deep Learning Networks

6. Chapter 4: Predicting Numerical Values with Linear Regression

7. Chapter 5: Predicting Boolean Values Using Binary Logistic Regression

8. Chapter 6: Classifying Trees with Multiclass Logistic Regression

9. Section 3: Advanced Models with BigQuery ML

10. Chapter 7: Clustering Using the K-Means Algorithm

11. Chapter 8: Forecasting Using Time Series

12. Chapter 9: Suggesting the Right Product by Using Matrix Factorization

13. Chapter 10: Predicting Boolean Values Using XGBoost

14. Chapter 11: Implementing Deep Neural Networks

15. Section 4: Further Extending Your ML Capabilities with GCP

16. Chapter 12: Using BigQuery ML with AI Notebooks

17. Chapter 13: Running TensorFlow Models with BigQuery ML

18. Chapter 14: BigQuery ML Tips and Best Practices

19. Other Books You May Enjoy

Further resources

NYC Street Tree Census public dataset: https://console.cloud.google.com/marketplace/product/city-of-new-york/nyc-tree-census
XGBoost home page: https://xgboost.ai/
XGBoost documentation: https://xgboost.readthedocs.io/en/latest/index.html
BigQuery ML CREATE MODEL statement for Boosted Tree models: https://cloud.google.com/bigquery-ml/docs/reference/standard-sql/bigqueryml-syntax-create-boosted-tree
BigQuery ML ML.EVALUATE function: https://cloud.google.com/bigquery-ml/docs/reference/standard-sql/bigqueryml-syntax-evaluate
BigQuery ML ML.PREDICT function: https://cloud.google.com/bigquery-ml/docs/reference/standard-sql/bigqueryml-syntax-predict

The rest of the chapter is locked

Register for a free Packt account to unlock a world of extra content!

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $19.99/month. Cancel anytime

Authors (1)

Marrandino

Marrandino

Alessandro Marrandino is a Google Cloud customer engineer. He helps various enterprises in the digital transformation journey through the adoption of cloud technologies. He is actively focused on and experienced in data management and smart analytics solutions. He has spent his entire career on data and artificial intelligence projects for global companies in different industries.

See other products by Marrandino

Other recommended products

Related to this chapter

Learning Google BigQuery

Learning Google BigQuery

Google BigQuery is a popular cloud data warehouse for large-scale data analytics. This book will serve as a comprehensive guide to mastering BigQuery, and how you can utilize it to quickly and efficiently get useful insights from your Big Data. You will begin with getting a quick overview of the Google Cloud Platform and the various services it supports. Then, you will be introduced to the Google BigQuery API. The book covers useful techniques to migrate your existing data from your enterprise to Google BigQuery. You will perform basic as well as advanced data querying using BigQuery, and connect the results to various third party tools for reporting and visualization purposes such as R and Tableau.

Dec 2017 8h 48m

Automated Machine Learning

Automated Machine Learning

This guide will help you to explore automated machine learning (AutoML), a rapidly growing subfield of machine learning. You'll learn how you can use AutoML to fully automate the machine learning process even if you're not an expert, and in turn increase your productivity drastically.

Feb 2021 10h 24m

Learn TensorFlow Enterprise

Learn TensorFlow Enterprise

This book is a comprehensive introduction for those who are new to scalable and optimized TensorFlow for production. You will learn how to deliver enterprise-grade support for your existing and newly built AI applications. You will address the various needs of AI-enabled organizations to manage and scale machine learning workloads in production.

Nov 2020 10h 28m

Hands-On Artificial Intelligence on Google Cloud Platform

Hands-On Artificial Intelligence on Google Cloud Platform

This book focuses on the use of powerful AI tools offered by Google Cloud Platform to develop and design intelligent applications on the cloud. You will start with topics that set the foundation for using GCP with various powerful libraries, and then move on to building end to end AI applications using them.

Mar 2020 11h 40m

Google Cloud Platform Administration

Google Cloud Platform Administration

With Google Cloud Platform, you can build, test and deploy applications on Google's highly reliable and scalable infrastructure. This book will help you explore a list of different developer tools available to manage and interact with the GCP platform.

Sep 2018 7h 40m

Google Cloud Platform for Architects

Google Cloud Platform for Architects

The Google Cloud Platform is fast emerging as a leading public cloud provider. The GCP, as it is popularly known, is backed by Google's awe-inspiring engineering expertise and infrastructure and is able to draw upon the goodwill and respect that Google has come to enjoy. The GCP is one of a handful of public cloud providers to offer the full range of cloud computing services, ranging from IaaS (Infrastructure-as-a-Service) to PaaS (Platform-as-a-Service). There is another reason the GCP is fast gaining popularity; genre-defining technologies such as TensorFlow and Kubernetes originated at Google before being open-sourced, and the GCP is a natural choice of cloud on which to run them. If you are a cloud professional today, time spent on mastering the GCP is likely to be an excellent investment.

Jun 2018 12h 24m

Professional Cloud Architect – Google Cloud Certification Guide

Professional Cloud Architect – Google Cloud Certification Guide

This book will help you prepare for Google's popular Professional Cloud Architect certification from the ground up. You will learn the necessary skills to design, develop, and manage enterprise-grade cloud solutions, and thereby achieve your organization's business objectives.

Oct 2019 17h 20m

Architecting Google Cloud Solutions

Architecting Google Cloud Solutions

Google Cloud is a powerful and highly scalable cloud platform that has seen rising demand and interest from enterprises seeking digital transformation and looking to modernize their workloads. This book is a comprehensive introduction to solution architecture with Google Cloud that will have you up to speed in no time.

Apr 2021 15h 44m

Personalised recommendations for you

Based on your interests and search pattern

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m

Data Governance Handbook

Data Governance Handbook

This book provides a highly focused view of real business outcomes powered by data governance, that resonate with non-data executives such as CFOs and CEOs. You'll also find useful insights into how to implement data governance initiatives.

May 2024 13h 8m

Data Engineering with Databricks Cookbook

Data Engineering with Databricks Cookbook

This book shows you how to use Apache Spark, Delta Lake, and Databricks to build data pipelines, manage and transform data, optimize performance, and more. Additionally, you'll implement DataOps and DevOps practices, and orchestrate data workflows.

May 2024 14h 36m

Azure Data Engineer Associate Certification Guide

Azure Data Engineer Associate Certification Guide

Unlock the power of Azure data engineering with this certification guide, elevating your skills in data processing, storage, and security with the help of practical insights, hands-on exercises, and the latest advancements.

May 2024 18h 16m

Microsoft Power BI Cookbook

Microsoft Power BI Cookbook

Microsoft Power BI is the most sought-after platform for BI professionals' visualization needs. Explore the latest Power BI features, future AI enhancements, and integration with other Power Platform tools via new recipes in this updated edition.

Jul 2024 19h 56m

Python Data Cleaning Cookbook

Python Data Cleaning Cookbook

The book shows you how to clean, wrangle, and view data from multiple perspectives, including dataset and column attributes. You will cover common and not-so-common challenges that are faced while cleaning messy data for complex situations and learn to manipulate data to get it down to a form that can be useful for making the right decisions.

May 2024 16h 12m

Microsoft Azure AI Fundamentals AI-900 Exam Guide

Microsoft Azure AI Fundamentals AI-900 Exam Guide

This AI-900 study guide will help you prepare and practice for the certification exam. You'll delve into AI workloads, ML principles, computer vision, NLP, knowledge mining, and generative AI using Azure cloud services.

May 2024 9h 36m

Using Stable Diffusion with Python

Using Stable Diffusion with Python

This book shows you how to use Python to control Stable Diffusion and generate high-quality images. In addition to covering the basic usage of the diffusers package, the book provides solutions for extending the package for more advanced purposes.

Jun 2024 11h 44m

Getting Started with DuckDB

Getting Started with DuckDB

This hands-on book teaches you to analyze large datasets with blazing speed and ease. You will learn how to use DuckDB to quickly load, query, transform, analyze, and visualize data effectively through a series of practical examples.

Jun 2024 12h 44m

Databricks Certified Associate Developer for Apache Spark Using Python

Databricks Certified Associate Developer for Apache Spark Using Python

This guide gets you ready for certification with expert-backed content, key exam concepts, and topic reviews. Additionally, you'll be able to make the most of Apache Spark 3.0 to modernize workloads and more using specific tools and techniques.