Mastering Amazon Redshift and Serverless for Data Engineers
A Comprehensive Course on Mastering Amazon Redshift including Serverless for Data Engineers to build Data Warehouse
Created by Durga Viswanatha Raju Gadiraju | 13.5 hours on-demand video course
AWS or Amazon Redshift is one of the key AWS Services used in building Data Warehouses or Data Marts to serve reports and dashboards for business users. As part of this course, you will end up learning AWS or Amazon Redshift by going through all the important features of AWS or Amazon Redshift to build Data Warehouses or Data Marts.
What you’ll learn
- Getting Started with Amazon Redshift using AWS Web Console
- Copy Data from s3 into AWS Redshift Tables using Redshift Queries or Commands
- Develop Applications using Redshift Cluster using Python as Programming Language
- Copy Data from s3 into AWS Redshift Tables using Python as Programming Language
- Create Tables using Databases setup on AWS Redshift Database Server using Distribution Keys and Sort Keys
- Run AWS Redshift Federated Queries connecting to traditional RDBMS Databases such as Postgres
- Perform ETL using AWS Redshift Federated Queries using Redshift Capacity
- Integration of AWS Redshift and AWS Glue Catalog to run queries using Redshift Spectrum
- Run AWS Redshift Spectrum Queries using Glue Catalog Tables on Datalake setup using AWS s3
- Getting Started with Amazon Redshift Serverless by creating Workgroup and Namespace
- Integration of AWS EMR Cluster with Amazon Redshift using Serverless Workgroup
- Develop and Deploy Spark Application on AWS EMR Cluster where the processed data will be loaded into Amazon Redshift Serverless Workgroup
Recommended Course
Amazon AWS SageMaker, AI and Machine Learning with Python Course