AWS Redshift Fundamentals
$199.00
AWS Redshift Fundamentals teaches how Amazon Redshift data warehouses work and how to deploy, load, secure and monitor a cluster. For DBAs, data analysts and BI staff new to Redshift.
- Login details sent straight after payment
- Self-paced. Study on any device
- StemBoss Certificate of Completion
- 14-day refund promise
Secure checkout. Pay by card, Apple Pay or Google Pay.
AWS Redshift Fundamentals teaches you how Amazon Redshift works and how to run a data warehouse on AWS. It is for database administrators, data analysts, BI specialists and developers who are new to Redshift. You will move from data warehouse basics to deploying a cluster, loading data and keeping it fast and secure.
What you will learn
- Explain what a data warehouse is and where Redshift fits
- Weigh up Redshift benefits, limits and pricing
- Choose node types and cluster options
- Describe Redshift architecture and how a query runs
- Tune queries and costs and set up workload management
- Deploy, resize, back up and recover a cluster
- Secure a cluster with networking and IAM settings
- Connect to the database and load data from Amazon S3
- Monitor Redshift and query data in S3 with Redshift Spectrum
Course outline
- Introduction: welcome, course overview and what you need before you start
- Redshift fundamentals: data warehouses, benefits and limits, pricing, use cases, node types, clusters, architecture, the life of a query, workload management and column-based storage
- Advanced capabilities: deployment options, Multi-AZ, backup and recovery, networking and security, IAM, connecting with SQL tools and Excel, loading data from S3, monitoring and Redshift Spectrum
Who this course is for
- Database administrators and data architects
- Data analysts and BI specialists
- Data and cloud engineers starting with Redshift
- Developers who need to query warehouse data
Before you start
A basic understanding of databases and SQL will help. Some familiarity with the AWS console is useful, as the hands-on exercises deploy a real cluster.
You will need your own AWS account to follow the exercises. The course shows how to use the free tier and startup credits, but always check your costs and delete clusters you no longer need. By the end you will be able to deploy, load and monitor a working Redshift data warehouse.
Jobs this course supports
- Cloud Data Engineer
- Database Administrator
- Data Architect
- Business Intelligence Analyst
- Cloud Solutions Architect
| Skill level | Beginner |
|---|---|
| Prerequisites | Basic SQL and a general idea of how AWS works will help. |
| Best for | Database administrators, data architects, data analysts, BI specialists, developers |
| Topics covered | Data warehouse basics, Redshift architecture, node types and clusters, workload management, security and networking, data loading from S3, monitoring, Redshift Spectrum |
| Format | Online video lessons with demos and hands-on exercises, self-paced |
| Language | English |
| Closed captions | Yes |
| Certificate | StemBoss Certificate of Completion |
What is inside this course
3 modules and 43 lessons. Here is the full outline.
Introduction - AWS Redshift Fundamentals3 lessons
- Course Welcome
- Course Overview
- Course PreRequirements
Section 1: AWS Redshift Fundamentals17 lessons
- 1.1 Fundamentals of data warehouses and Amazon Redshift
- 1.2 AWS Benefits and Limitations
- 1.3 AWS Redshift Pricing
- 1.4 Enterprise Use Cases
- 1.5 Node Types
- 1.6 Cluster Options
- 1.7 Demo - Free Tier- Startup Credits
- 1.8 Hands on Exercise 1 - Deploy a Cluster
- 1.9 Whiteboard- Redshift Architecture
- 1.10 Life of a Query
- 1.11 Query and Cost Optimization
- 1.12 Workload Management
- 1.13 Whiteboard- Redshift WLM
- 1.14 Redshift Performance Notes
- 1.15 Column Oreiented structures
- 1.16 Section Review
- 1.17 Review Questions
Section 2: Advanced Capabilities23 lessons
- 2.1 Advanced Capabilities
- 2.2 Deployment Options (node types, cluster options, etc.)
- 2.3 Multi-AZ deployment with Amazon Redshift
- 2.4 Backup and Recovery
- 2.5 Demo -Deploy Cluster
- 2.6 Demo - Resize Cluster
- 2.7 Networking and Security
- 2.8 Demo - Networking and Security
- 2.9 HOE - Setup IAM and Deploy Cluster
- 2.10 Whiteboard - Networking
- 2.11 Demo - Connect to Database
- 2.12 HOE - SQLWB
- 2.13 Excel Connections
- 2.14 Setting up and managing data ingestion with Amazon Redshift
- 2.15 HOE - AWS S3 Data Load
- 2.16 Monitoring Redshift
- 2.17 Demo - Monitor Redshift
- 2.18 HOE - Deploy an Amazon Redshift data warehouse cluster, load data into the cluster
- 2.19 Amazon Redshift Spectrum
- 2.20 Section Review
- 2.21 Review Questions
- 2.22 Resources
- 2.23 Course Closeout
Your learning path
Where AWS Redshift Fundamentals fits. Build your skills one step at a time.
Frequently asked questions
What is Amazon Redshift?
Amazon Redshift is a cloud data warehouse on AWS. It stores large amounts of data in a column-based format so analytics queries run quickly.
Does this course include hands-on practice?
Yes. It includes demos and hands-on exercises, such as deploying a cluster, setting up IAM and loading data from Amazon S3.
What is Redshift Spectrum?
Redshift Spectrum lets you run queries on data stored in Amazon S3 without loading it into the cluster first. The course covers it near the end.
Do I need to know SQL first?
Basic SQL helps, since you will connect to the database and run queries. You do not need to be an expert.
Do I get a certificate?
Yes. You get a StemBoss Certificate of Completion when you finish the course.
Can I get a refund?
Yes, within 14 days if you have completed less than 20% of the course. See our refund policy for details. Read the refund policy.
