Serverless Machine Learning with Amazon Redshift ML: Create, train, and deploy machine learning models using familiar SQL commands - Softcover

Debabrata Panda; Phil Bates; Bhanu Pittampally; Sumeet Joshi

Softcover

ISBN 10: 1804619280 ISBN 13: 9781804619285

Publisher: Packt Publishing, 2023

Synopsis

Supercharge and deploy Amazon Redshift Serverless, train and deploy Machine learning Models using Amazon Redshift ML and run inference queries at scale.

Key Features

• Learn to build Multi-Class Classification Models
• Create a model, validate a model and draw conclusion from K-means clustering
• Learn to create a SageMaker endpoint and use that to create a Redshift ML Model for remote inference

Book Description

Amazon Redshift Serverless enables organizations to run PetaBytes scales Cloud data warehouses in minutes and in most cost effective way Developers, data analysts and BI analysts can deploy cloud data warehouses and use easy-to-use tools to train models and run predictions. Developers working with Amazon Redshift data warehouses will be able to put their SQL knowledge to work with this practical guide to train and deploy Machine Learning Models. The book provides a hands-on approach to implementation and associated methodologies that will have you up-and-running, and productive in no time. Complete with step-by-step explanations of essential concepts, practical examples and self-assessment questions, you will begin Deploying and Using Amazon Redshift Serverless and then dive into learning and deploying various types of Machine learning projects using familiar SQL Code. You will learn how to configure and deploy Amazon Redshift Serverless, understand the foundations of data analytics and types of data machine learning. Then you will deep dive into Redshift ML By the end of this book, you will be able to configure and deploy Amazon Redshift Serverless, train and deploy Machine learning Models using Amazon Redshift ML and run inference queries at scale.

What you will learn

• Learn how to implement an end-to-end serverless architecture for ingestion, analytics and machine learning using Redshift Serverless and Redshift ML
• Learn how to create supervised and unsupervised models, and various techniques to influence your model
• Learn how to run inference queries at scale in Redshift to solve a variety of business problems using models created with Redshift ML or natively in Amazon SageMaker
• Learn how to optimize your Redshift data warehouse for extreme performance
• Learn how to ensure you are using proper security guidelines with Redshift ML
• Learn how to use model explainability in Amazon Redshift ML, to help understand how each attribute in your training data contributes to the predicted result.

Who This Book Is For

Data Scientists and Machine Learning developers who work with Amazon Redshift and want to explore it's machine learning capabilities will find this definitive guide helpful. Basic understanding of machine learning techniques and working knowledge of Amazon Redshift is needed to get the best from this book.

Table of Contents

1. Introduction to Redshift Serverless
2. Data Loading and analytics on Redshift Serverless
3. Applying Machine Learning in Your Warehouse
4. Redshift ML Overview
5. Building your first model
6. Building classification models
7. Building Regression models
8. Building Unsupervised Models with K-Means Clustering
9. Redshift Auto ON vs Auto OFF
10. Creating models with XGBoost
11. Bring Your Own Models for in database inference
12. Bring Your Own Models for in remote endpoint invocation
13. Performance Considerations
14. Personalizing/Operationalizing

About this title

About the Author

Debabrata Panda, a Senior Manager, Product Management at AWS, is an industry leader in analytics, application platform, and database technologies, and has more than 25 years of experience in the IT world. Debu has published numerous articles on analytics, enterprise Java, and databases and has presented at multiple conferences such as re:Invent, Oracle Open World, and Java One. He is lead author of the EJB 3 in Action (Manning Publications 2007, 2014) and Middleware Management (Packt, 2009)<br /><br />Phil Bates is a Senior Analytics Specialist Solutions Architect at AWS. He has more than 25 years of experience implementing large scale data warehouse solutions. He is passionate about helping customers through their cloud journey and leveraging the power of ML within their data warehouse.<br /><br />Bhanu Pittampally is Analytics Specialist Solutions Architect at Amazon Web Services. His background is in data and analytics and is in the field for over 15 years. He currently lives in Frisco, TX.<br /><br />Sumeet Joshi is an Analytics Specialist Solutions Architect based out of New York. He specializes in building large-scale data warehousing solutions. He has over 17 years of experience in the data warehousing and analytical space.

From the Back Cover

Supercharge and deploy Amazon Redshift Serverless, train and deploy machine learning models using Amazon Redshift ML, and run inference queries at scale Key Features:Leverage supervised learning to build binary classification, multi-class classification, and regression models Learn to use unsupervised learning using the K-means clustering method Master the art of time series forecasting using Redshift ML Purchase of the print or Kindle book includes a free PDF eBook Book Description: Amazon Redshift Serverless enables organizations to run petabyte-scale cloud data warehouses quickly and in a cost-effective way, enabling data science professionals to efficiently deploy cloud data warehouses and leverage easy-to-use tools to train models and run predictions. This practical guide will help developers and data professionals working with Amazon Redshift data warehouses to put their SQL knowledge to work for training and deploying machine learning models. The book begins by helping you to explore the inner workings of Redshift Serverless as well as the foundations of data analytics and types of data machine learning. With the help of step-by-step explanations of essential concepts and practical examples, you'll then learn to build your own classification and regression models. As you advance, you'll find out how to deploy various types of machine learning projects using familiar SQL code, before delving into Redshift ML. In the concluding chapters, you'll discover best practices for implementing serverless architecture with Redshift. By the end of this book, you'll be able to configure and deploy Amazon Redshift Serverless, train and deploy machine learning models using Amazon Redshift ML, and run inference queries at scale. What You Will Learn:Utilize Redshift Serverless for data ingestion, data analysis, and machine learning Create supervised and unsupervised models and learn how to supply your own custom parameters Discover how to use time series forecasting in your data warehouse Create a SageMaker endpoint and use that to build a Redshift ML model for remote inference Find out how to operationalize machine learning in your data warehouse Use model explainability and calculate probabilities with Amazon Redshift ML Who this book is for: Data scientists and machine learning developers working with Amazon Redshift who want to explore its machine-learning capabilities will find this definitive guide helpful. A basic understanding of machine learning techniques and working knowledge of Amazon Redshift is needed to make the most of this book.

Edition details

• Publisher: Packt Publishing
• Publication date: 2023
• Language: English
• ISBN 10: 1804619280
• ISBN 13: 9781804619285
• Binding: Paperback
• Number of pages: 384