September 2023
Beginner to intermediate
3h 28m
English
Closed Captioning available in German, English, Spanish, French, Japanese, Korean, Portuguese (Portugal, Brazil), Chinese (Simplified), Chinese (Traditional)
Overview
Enterprise organizations are continually shifting to innovative cloud services that will provide them with a rapid, efficient, scalable and industry leading solution.
Amazon Redshift is a petabyte scale data platform as a Service (PaaS) that delivers high performance enterprise focused data services that are hosted and are fully scalable solutions without placing a massive investment in your enterprise infrastructure.
Amazon Redshift also provides robust access to a variety of data analytics tools, compliance features, integration with other AWS services and even artificial intelligence/ machine learning applications that allow customers numerous opportunities to derive value with their current business intelligence tools.
In this course you will learn everything you need to know to get started using Amazon Redshift to deploy a data warehouse/data lake and provide immediate value for your enterprise.
What you’ll learn and how you can apply it
- Understand why data warehouses are so critical to enterprise organizations and how Amazon Redshift provides immediate value for enterprises that use it.
- Identify the critical differences between a traditional enterprise data warehouse and Amazon Redshift.
- Learn the Column-Oriented file system structures and the database options available with Amazon Redshift.
- Learn how to determine proper enterprises use cases for using AWS Redshift focused on uses such as ETL, Data Transformation, Data Mining, Data Lakes and Business Intelligence.
- Describe AWS enterprise best practices for cloud security, networking, and IAM with Amazon Redshift.
- Learn the critical components and the essential features of AWS Redshift (Query Editor, Optimizer, Spectrum)
- Understand schemas, structures, SQL options, monitoring options, etc. with Amazon Redshift.
- Determine the proper node and cluster deployment option(s) for your Amazon Redshift requirements.
- Understand the options for connecting to the data warehouse and for querying the data warehouse.
This course is for you because…
- You need to understand how to simplify a data warehouse infrastructure with AWS.
- You're an aspiring data engineer, database architect, cloud developer, cloud architect, or other technical professional that wants to get started with Amazon Redshift.
- You work with AWS services daily and would like to integrate with other AWS or Partner services with AWS Redshift successfully.
- You want to obtain an AWS Specialty Certification and would like to obtain knowledge and practice around Amazon Redshift for the AWS Certified Database or Data Analytics Specialty exams. This course will help with those certification since it covers over 15% of the exam objectives.
Prerequisites:
- 6 Months of AWS “Hands on Experience” with AWS Services would be advisable.
- Basic SQL Database “Hands on Experience” around relational database is needed.
- An AWS Paid Account to be able to perform the exercises and following along with the demonstrations. Some of the services with Amazon Redshift would not be fully covered with an AWS Free Tier account.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Watch now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.