Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Serverless Machine Learning with Amazon Redshift ML
  • Table Of Contents Toc
  • Feedback & Rating feedback
Serverless Machine Learning with Amazon Redshift ML

Serverless Machine Learning with Amazon Redshift ML

By : Debu Panda, Phil Bates, Bhanu Pittampally, Sumeet Joshi
5 (3)
close
close
Serverless Machine Learning with Amazon Redshift ML

Serverless Machine Learning with Amazon Redshift ML

5 (3)
By: Debu Panda, Phil Bates, Bhanu Pittampally, Sumeet Joshi

Overview of this book

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.
Table of Contents (19 chapters)
close
close
1
Part 1:Redshift Overview: Getting Started with Redshift Serverless and an Introduction to Machine Learning
5
Part 2:Getting Started with Redshift ML
11
Part 3:Deploying Models with Redshift ML

What this book covers

Chapter 1, Introduction to Amazon Redshift Serverless, presents an overview of Amazon Redshift and Redshift Serverless, walking you through how to get started in just a few minutes and connect using Redshift Query Editor v2. You will create a sample database and run queries using the Notebook feature.

Chapter 2, Data Loading and Analytics on Redshift Serverless, helps you learn different mechanisms to efficiently load data into Redshift Serverless.

Chapter 3, Applying Machine Learning in Your Data Warehouse, introduces machine learning and common use cases to apply to your data warehouse.

Chapter 4, Leveraging Amazon Redshift Machine Learning, builds on Chapter 3. Here, we dive into Amazon Redshift ML, learning how it works and how to leverage it to solve use cases.

Chapter 5, Building Your First Machine Learning Model, sees you get hands-on with Amazon Redshift ML and build your first model using simple CREATE MODEL syntax.

Chapter 6, Building Classification Models, covers classification problems and the algorithms you can use in Amazon Redshift ML to solve these problems and learn how to create a model with user guidance.

Chapter 7, Building Regression Models, helps you identify whether a problem involves regression and explores the different methods available in Amazon Redshift ML for training and building regression models.

Chapter 8, Building Unsupervised Models with K-Means Clustering, shows you how to build machine learning models with unlabeled data and make predictions at the observation level using K-means clustering.

Chapter 9, Deep Learning with Redshift ML, covers the use of deep learning in Amazon Redshift ML using the MLP model type for data that is not linearly separable.

Chapter 10, Creating Custom ML Model with XGBoost, shows you how to use the Auto Off option of Amazon Redshift ML to prepare data in order to build a custom model.

Chapter 11, Bring Your Own Models for In-Database Inference, goes beyond Redshift ML models. Up to this point in the book, we will have run inference queries only on models built directly in Amazon Redshift ML. This chapter shows how you can leverage models built outside of Amazon Redshift ML and execute inference queries inside Amazon Redshift ML.

Chapter 12, Time-Series Forecasting in Your Data Warehouse, dives into forecasting and time-series data using the integration of Amazon Forecast with Amazon Redshift ML.

Chapter 13, Operationalizing and Optimizing Amazon Redshift ML Models, concludes the book by showing techniques to refresh your model, create versions of your models, and optimize your Amazon Redshift ML models.

Unlock full access

Continue reading for free

A Packt free trial gives you instant online access to our library of over 7000 practical eBooks and videos, constantly updated with the latest in tech
bookmark search playlist download font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY