Introduction to Amazon Redshift: Data Management Essentials

Course details

Amazon Redshift is an approachable, easy-to-use option for storing, querying, and managing large amounts of data—offering fast, cloud-based analytics and data warehousing at scale. In this course, instructor Jeremy Villeneuve—the founder of IT consulting firm Halvanta—gives you a quick, hands-on introduction to the essential perks of Redshift. Jeremy begins with the basics, offering beginner-level coverage of big data fundamentals, Redshift, data warehousing, and relational database management. He then helps you explore the Redshift user interface, get your data into Redshift, and start writing your own queries using 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.

Learning objectives
Understand key terms around big data.
Explain the fundamentals of relational databases and how they apply to managing data in Amazon Redshift.
Use Redshift with a sample dataset by following along with a hands-on tutorial.
Discuss best practices for using Redshift.

Concepts

Introduction

Turn data into information with Redshift

Big Data Fundamentals

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

Using Redshift

What is Redshift
Creating a workgroup
Querying Redshift
Getting your data into Redshift
Using CoderPad for this code challenge
Solution - Write your own query

Best Practices for Redshift

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

Conclusion

More Redshift features to explore