Udemy - AWS Redshift - A Comprehensive Guide

What you'll learn
Redshift - Core Components and Features
Loading and Querying Data - Query Editor, SQL Client Tools, BI Tools, CLI, APIs
Automated Table Design, Data Distribution, Sorting and Workload Management
Cluster Resizing, Relocation, Pause, Shutdown, Backup
Security, Logging and Monitoring in Redshift
Redshift Spectrum - Querying the Datalake
Federated Queries - Querying RDS (relational database)
Redshift ML - Advanced analytics with Redshift & Sagemaker
Stored Procedures, Materialized Views
Description
Amazon Redshift is a fast, easy to use, cost-effective, peta-byte level, cloud based data warehousing solution. It promises to deliver up to 3x better price-performance than other cloud data warehouses. It takes advantage of AWS designed-hardware and machine learning (ML) to deliver the best price performance at any scale.
The objective of the course is to understand redshift from an end to end perspective. The course is divided in following sections
Overview - Brief introduction to Datawarehouse, Evolution and AWS redshift.
Getting Started - We will get started on redshift where we will load and query sample data. We will understand what redshift created for us behind the scenes. we will also get familiar with the redshift console in this section.
How does it work - We will jump into the core mechanics of redshift. we will understand the core components, functions of redshift which help in high performance and scalability.
Manage Data - we will move to manage data section where we will understand the data types, data loading, data querying, data design with distribution and sort keys, stored procedures, materialized views and workload management in redshift.
AWS Services - we are going to cover the integration aspects of redshift with other AWS services such as datalake formation, aws EMR, AWS glue, amazon kinesis, amazon quick sight, sagemaker, migration tools, etc. We will also understand the redshift spectrum and federated queries in this section.
Manage Cluster - We will cover the cluster operations, snapshots, moniroting & security.
Conclude - Pricing, Best Practices, Reading references.
Who this course is for:
Database Engineers,Architects curious about AWS Redshift

Homepage

https://www.udemy.com/course/aws-redshift-a-comprehensive-guide/