Mastering Amazon Redshift and Serverless for Data Engineers

In-Depth Course on Amazon Redshift, Redshift Serverless, Integration with EMR, AWS Step Functions, AWS Lambda and more

Created by: Durga Viswanatha Raju Gadiraju
CEO at ITVersity and CTO at Analytiqs, Inc

Created by: Pratik Kumar

Created by: Sathvika Dandu

Created by: Madhuri Gadiraju

Created by: Sai Varma

Created by: Phani Bhushan Bozzam
Aspiring Project Manager & Creative UI/UX Designer

Created by: Anushka Chakraborty

What Will I 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

Requirements

• A computer science or IT Degree or 1 or 2 years of IT Experience
• Ability to write SQL Queries using any Relational or Data Warehouse or MPP Database
• Basic Linux Skills with ability to run commands using Terminal
• Basic Programming using Python is desired even though it is mandatory for most part of the course

Target audience

• University Students who want to learn AWS Redshift for Data Warehousing
• Aspiring Data Engineers and Data Scientists who want to learn about AWS Redshift for Data Warehousing
• Experienced Application Developers who would like to explore AWS Redshift for Data Warehousing
• Experienced Data Engineers to build end to end data pipelines using Python around Data Marts created using AWS Redshift
• Any IT Professional who is keen to deep dive into AWS Redshift for Data Warehousing on AWS