Amazon Redshift Essentials

Course details

If you need to store, query, and manage a large amount of data, AWS Redshift is one of the most approachable, easy-to-use options that’s currently available on the market. Not only that, Redshift offers fast, cloud-based analytics and data warehousing at scale. In this course, instructor Jeremy Villeneuve gives you a quick introduction to the essential perks of Redshift.

Get a better understanding of big data fundamentals, Redshift, data warehousing, and relational database management. Explore the Redshift user interface and customized configuration options with a hands-on tutorial and sample dataset. If you’re an early-career developer, Jeremy shows you what you need to know to get the most out of Redshift as a product, including best practices for data optimization, data distribution, storage, cost management, and more.

Concepts

0. Introduction

01 - Turn data into information with Redshift

1. Big Data Fundamentals

02 - When you need big data
03 - How relational databases retrieve data
04 - Database locks - Gatekeepers of your data
05 - Separating your old and new data
06 - Data warehouse types
07 - Challenge - A proposal for a data warehouse
08 - Solution - A proposal for a data warehouse

2. Using Redshift

09 - What is Redshift
10 - Creating a cluster
11 - Querying the Redshift cluster
12 - Getting your data into Redshift
13 - Challenge - Write your own query
14 - Solution - Write your own query

3. Best Practices for Redshift

15 - Make Redshift faster with data optimization
16 - Distribute your data evenly across the cluster
17 - Managing data storage and costs
18 - Challenge - Choose a distribution style
19 - Solution - Choose a distribution style

Conclusion

20 - More Redshift features to explore