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 of 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
- 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