AWS Data Warehouse - Build with Redshift and QuickSight
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 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
Who this course is for:
- AWS beginners and developers
- Database developers and analysts
- Database administrators
Course content
- Preview05:40
- Preview03:00
- Preview02:42
- 02:22Deploy Data Warehouse on Redshift
- 00:55Prerequisites and Sample Flow
- 00:41Summary
- 2 questionsAWS Data Warehouse Introduction Quiz
Instructor
![Liya Peng](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 3.4 Instructor Rating
- 159 Reviews
- 4,167 Students
- 3 Courses
Liya Peng is an IT Architect and IT blogger with 20 years of experience in the financial service industry, Ms. Peng focused on various multi-million dollar projects to support global financial transaction and the technical infrastructure refresh to enhance overall performance and functionalities. She holds several IT certifications such as GCP PCA (Google Cloud Certified Professional Cloud Architect), PDE (Google Cloud Certified Professional Data Engineer), AWS Big Data Specialty, AWS Certified Solutions Architect Associate, SCEA (SUN Certified Enterprise Architect), and PMP (Project Management Professional). She would like to help you shorten your learning curve on information technology.