A developer guide for Amazon Redshift
What you'll learn
- You can master building a datawarehouse on Amazon Redshift
- Zero to pro in less than 2 hours.
Requirements
- Basic Database/SQL Knowledge
Description
This course covers the Architecture of Redshift, Columnar vs Row oriented databases, Introduce you to the AWS VPC, IAM role, and S3 bucket creation. You can master the SQL with best practices and learn a few admin activities which help to build an effective data warehouse. This course introduces compression/encoding techniques. You can learn to implement Workload management and monitor and tune long-running queries.
I always noticed most of the data engineers are clueless about how data is retrieved from the database. Writing an optimized query is a must when dealing with big data, understanding the architecture and the movement of the data is very important to write the best query.
Without prior knowledge on SQL, you can master the SQL and become a pro with this short 2 Hour tutorial.
Who this course is for:
- Redshift beginners or Data warehousing beginners curious about AWS Redshift
Instructor
I am a data architect with more than 10 years of experience in the BI space with hands on few ETL tools (like Informatica, Ab Initio, SSIS, Talend and AWS Glue), Reporting tools(QlikView and Tableau), Data modelling tools (Erwin and Power Architect), Big data(Hadoop, Hive, Spark and Pig) and AWS(Glue, DynamoDB, Redshift, RDS, Glue, Kinesis and Lambda).