Understanding Redshift- Under the Hood
The unprecedented explosion of data volumes in recent times has created an environment where companies must formulate a thorough data strategy. This strategy and the resulting solution must account for data volumes, costs, scalability, and simplicity of use.
AWS Redshift provides a complete solution for analyzing large volumes of data cost-effectively. Amazon Redshift is a fully managed, scalable cloud data warehouse that accelerates your time to insights with fast, easy, and secure analytics at scale. Thousands of customers rely on Amazon Redshift to analyze data from terabytes to petabytes and run complex analytical queries. You can get real-time insights and predictive analytics on all your data across your operational databases, data lake, data warehouse, and third-party datasets.
This workshop discusses the fundamentals of Redshift like architecture and data modeling and the advanced Redshift concepts like Query optimizations, Security, and backup & restore in Redshift.
• The fundamental understanding of Redshift and its architecture
• Data model and data types best practices
• Data loading and unloading concepts
• Query tuning best practices to optimize performance
• Security concepts with Redshift
• How Redshift manages backups and restores data
• Hands-on experience with Redshift infrastructure
Who Should Attend:
Experienced Redshift users (Data Engineers/Business Analysts): you will thoroughly understand some of the advanced Redshift concepts which will help you improve your system’s performance and save cost.
Beginners: you will learn the fundamentals of the Redshift with some advanced concepts. Additionally, hands-on experience as part of this workshop will make you familiar with the AWS interface and will motivate you to further advance your Redshift and other AWS services knowledge.
7:30 – 8:15 AM – Architecture
8:15 – 8:30 AM – Break
8:30 – 9:30 AM – Data modeling and data load and unload
9:30 – 10:00 AM – Break
10:00 – 11:00 AM – Query Tuning, Security, Operations, and Backup & restore
11:00 – 11:15 AM – Break
11:15 – 12:00 PM – Lab