What you'll learn
Understanding Amazon Redshift Essentials
Deploying data warehouse on Amazon Redshift
Maintaining and Montoring Data
Analyzing and Visualizing Data in Redshift with AWS QuickSight
Setting Up Redshift Security
Requirements
AWS account (you can use free tier account)
Any SQL Client supports PostgreSQL
Basic knowledge on relational databases and database design concepts
A Windows, Linux or Mac PC/Laptop
Description
This course AWS Data Warehouse - Build with Redshift and QuickSight covers all of the main concepts you need to know about Data Warehouse and Redshift. This course assumes you have no experience on Redshift but are eager to learn AWS solution on Data Warehouse. This course has seven hands-on labs from launching Redshift cluster, loading data, managing cluster, monitoring performance to visualizing data on QuickSight. The advanced experimental bonus sections focus on the latest Redshift features. You will learn Redshift essentials, QuickSight visualization, and Machine Learning prediction. You will also get the basic knowledge of other associated AWS services (e.g. S3, IAM, VPC, CloudWatch, and CloudTrial) during this step-by-step deploying and analytical processing. Plus the advanced knowledge of Redshift usage on data streaming and machine learning.
Once you have completed this course, you should be able to deploy your data warehouse on Redshift, operate and maintain data, analyze and visualize data on Quicksight, and set up security for Redshift.
Advanced Bonus Sections:
Hands-on lab: AWS Machine Learning on Redshift Data
Redshift Spectrum
Redshift with Kinesis
Who this course is for?
AWS beginners and developers
Database developers and analysts
Database administrators