book

Serverless Machine Learning with Amazon Redshift ML

Name: Serverless Machine Learning with Amazon Redshift ML
ISBN: 9781804619285

by Debu Panda, Phil Bates, Bhanu Pittampally, Sumeet Joshi

August 2023

Intermediate to advanced

290 pages

6h 4m

English

Packt Publishing

Read now

Unlock full access

Serverless Machine Learning with Amazon Redshift ML
ForewordContributorsAbout the authorsAbout the reviewers
Preface
Who this book is forWhat this book coversTo get the most out of this bookDownload the example code filesConventions usedGet in touchShare Your ThoughtsDownload a free PDF copy of this book
Part 1:Redshift Overview: Getting Started with Redshift Serverless and an Introduction to Machine Learning
Chapter 1: Introduction to Amazon Redshift Serverless
What is Amazon Redshift?Getting started with Amazon Redshift ServerlessWhat is a namespace?What is a workgroup?Connecting to your data warehouseUsing Amazon Redshift query editor v2Loading sample dataRunning your first querySummary
Chapter 2: Data Loading and Analytics on Redshift Serverless
Technical requirementsData loading using Amazon Redshift Query Editor v2Creating tablesLoading data from Amazon S3Loading data from a local driveData loading from Amazon S3 using the COPY commandLoading data from a Parquet fileAutomating file ingestion with a COPY jobBest practices for the COPY commandData loading using the Redshift Data APICreating tableLoading data using the Redshift Data APISummary
Chapter 3: Applying Machine Learning in Your Data Warehouse
Understanding the basics of MLComparing supervised and unsupervised learningClassificationRegressionTraditional steps to implement MLData preparationEvaluating an ML modelOvercoming the challenges of implementing ML todayExploring the benefits of MLApplication of ML in a data warehouseSummary
Part 2:Getting Started with Redshift ML
Chapter 4: Leveraging Amazon Redshift ML
Why Amazon Redshift ML?An introduction to Amazon Redshift MLA CREATE MODEL overviewAUTO everythingAUTO with user guidanceXGBoost (AUTO OFF)K-means (AUTO OFF)BYOMSummary
Chapter 5: Building Your First Machine Learning Model
Technical requirementsRedshift ML simple CREATE MODELUploading and analyzing the dataDiving deep into the Redshift ML CREATE MODEL syntaxCreating your first machine learning modelEvaluating model performanceChecking the Redshift ML objectivesRunning predictionsComparing ground truth to predictionsFeature importanceModel performanceSummary
Chapter 6: Building Classification Models
Technical requirementsAn introduction to classification algorithmsDiving into the Redshift CREATE MODEL syntaxTraining a binary classification model using the XGBoost algorithmEstablishing the business problemUploading and analyzing the dataUsing XGBoost to train a binary classification modelRunning predictionsPrediction probabilitiesTraining a multi-class classification model using the Linear Learner model typeUsing Linear Learner to predict the customer segmentEvaluating the model qualityRunning prediction queriesExploring other CREATE MODEL optionsSummary

Chapter 7: Building Regression Models
Technical requirementsIntroducing regression algorithmsRedshift’s CREATE MODEL with user guidanceCreating a simple linear regression model using XGBoostUploading and analyzing the dataSplitting data into training and validation setsCreating a simple linear regression modelRunning predictionsCreating multi-input regression modelsLinear Learner algorithmUnderstanding model evaluationPrediction querySummary
Chapter 8: Building Unsupervised Models with K-Means Clustering
Technical requirementsGrouping data through cluster analysisDetermining the optimal number of clustersCreating a K-means ML modelCreating a model syntax overview for K-means clusteringUploading and analyzing the dataCreating the K-means modelEvaluating the results of the K-means clusteringSummary
Part 3:Deploying Models with Redshift ML
Chapter 9: Deep Learning with Redshift ML
Technical requirementsIntroduction to deep learningBusiness problemUploading and analyzing the dataPrediction goalSplitting data into training and test datasetsCreating a multiclass classification model using MLPRunning predictionsSummary
Chapter 10: Creating a Custom ML Model with XGBoost
Technical requirementsIntroducing XGBoostIntroducing an XGBoost use caseDefining the business problemUploading, analyzing, and preparing data for trainingSplitting data into train and test datasetsPreprocessing the input variablesCreating a model using XGBoost with Auto OffCreating a binary classification model using XGBoostGenerating predictions and evaluating model performanceSummary
Chapter 11: Bringing Your Own Models for Database Inference
Technical requirementsBenefits of BYOMSupported model typesCreating the BYOM local inference modelCreating a local inference modelRunning local inference on RedshiftBYOM using a SageMaker endpoint for remote inferenceCreating BYOM remote inferenceGenerating the BYOM remote inference commandSummary
Chapter 12: Time-Series Forecasting in Your Data Warehouse
Technical requirementsForecasting and time-series dataTypes of forecasting methodsWhat is time-series forecasting?Time trending dataSeasonalityStructural breaksWhat is Amazon Forecast?Configuration and securityCreating forecasting models using Redshift MLBusiness problemUploading and analyzing the dataCreating a table with output resultsSummary
Chapter 13: Operationalizing and Optimizing Amazon Redshift ML Models
Technical requirementsOperationalizing your ML modelsModel retraining process without versioningThe model retraining process with versioningAutomating the CREATE MODEL statement for versioningOptimizing the Redshift models’ accuracyModel qualityModel explainabilityProbabilitiesUsing SageMaker Autopilot notebooksSummary
Index
Why subscribe?
Other Books You May EnjoyPackt is searching for authors like youShare Your ThoughtsDownload a free PDF copy of this book

Content preview from Serverless Machine Learning with Amazon Redshift ML

Part 2:Getting Started with Redshift ML

Part 2 begins with an overview of Amazon Redshift ML, then dives into how to create various machine learning models using Amazon Redshift ML.

By the end of Part 2, you will have an understanding of how to create a model by simply running a SQL command, the difference between supervised and unsupervised learning, and how to solve classification, regression, and clustering problems.

This part comprises the following chapters:

Chapter 4, Leveraging Amazon Redshift Machine Learning
Chapter 5, Building Your First Machine Learning Model
Chapter 6, Building Classification Models
Chapter 7, Building Regression Models
Chapter 8, Building Unsupervised Models with K-Means Clustering

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Build Your Own IoT Platform: Develop a Flexible and Scalable Internet of Things Platform

Publisher Resources

ISBN: 9781804619285

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

Serverless Machine Learning with Amazon Redshift ML

by Debu Panda, Phil Bates, Bhanu Pittampally, Sumeet Joshi

Part 2:Getting Started with Redshift ML

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.