Coursera Plus Annual Is 40% Off. Ends Soon!

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Coursera

AWS Redshift: Infrastructure, Performance, and Security

Packt via Coursera

Go to class Write review

Overview

Google, IBM & Meta Certificates – 40% Off a Year
One Coursera Plus subscription covers most Professional Certificates on Coursera. 40% off a full year through Dec 2.
Unlock All Certificates
Master AWS Redshift for data warehousing, including infrastructure setup, advanced database objects, performance tuning, workload management, and robust security controls. Gain practical skills to optimize and secure large-scale analytics environments. This course provides a comprehensive exploration of AWS Redshift, from infrastructure and architecture to deep dives into database objects, ACID compliance, and advanced features. Learners will develop expertise in query tuning, workload management, and implementing security measures such as RBAC, row and column-level security, and dynamic data masking. The course also covers monitoring, serverless options, pricing, integration with AWS services, and best practices for Redshift administration. Through detailed explanations and guided walkthroughs, learners build practical knowledge of Redshift's capabilities, focusing on performance optimization, security, and operational excellence. The course emphasizes hands-on understanding of Redshift features and their application in real-world data warehouse scenarios. This course is part two of a three-course Specialization designed to build a complete and cohesive understanding of the subject. While it offers valuable skills on its own, you'll gain the most benefit by progressing through all three courses as a structured learning journey. This course is based on Data Engineering on AWS Vol 1 - OLAP & Data Warehouse, by Soumyadeep Dey. This course is licensed and distributed by Packt. All rights reserved. Packt is one of the world's most prolific publishers of cutting-edge technical content. For over two decades we've made it our mission to curate and publish the knowledge of only the very best technical experts. We focus on real-world courses that help our customers get the job done, with coverage that extends across a wide range of established and cutting-edge technical topics. If you're an individual or an organisation that embraces learning by doing, Packt is the perfect fit for you.

Syllabus

  • Data Warehouse on AWS - Redshift Infra
    • This module covers the fundamentals of setting up and managing a data warehouse on AWS using Redshift. Learners will explore key architectural concepts, practical workflows, and best practices for cluster management and data storage optimization.
  • Redshift Objects
    • This module covers essential aspects of Amazon Redshift, including querying techniques, data types, transaction management, and locking mechanisms. Learners will gain hands-on experience with Redshift objects, SQL operations, and the SUPER data type for JSON handling. The content emphasizes practical application and performance optimization in a cloud data warehouse environment.
  • Redshift Deep Dive
    • This module explores essential Amazon Redshift concepts including data distribution, compression techniques, ETL processes, and table maintenance. Learners will gain hands-on experience with commands like COPY and UNLOAD, and learn how to migrate data from OLTP to DWH using AWS DMS. Practical exercises reinforce understanding of key operations and best practices for efficient data management.
  • Redshift Features
    • This module explores advanced features of Amazon Redshift, including materialized views, query federation, Redshift Spectrum, streaming ingestion, and real-time data handling. Learners will gain practical insights into integrating Redshift with other AWS services and optimizing performance for large-scale data workloads.
  • Redshift Query Tuning
    • This module focuses on optimizing Redshift queries through understanding execution plans, data distribution strategies, and hands-on tuning techniques. Learners will gain practical skills in analyzing and improving query performance for scalable data processing.
  • Redshift Workload Management (WLM)
    • This module provides learners with a comprehensive understanding of Amazon Redshift Workload Management, including how to configure and optimize query queues, utilize concurrency scaling, and implement short query acceleration for improved performance.
  • Redshift Security - RBAC, CLS, RLS, Dynamic Data masking (DDM)
    • This module covers essential security concepts in Amazon Redshift, including role-based access control, row and column-level security, dynamic data masking, and audit logging. Learners will gain practical skills in implementing and managing security policies to protect data integrity and compliance. The content combines theoretical knowledge with hands-on practice to reinforce real-world application.
  • Monitoring in Redshift
    • This module covers essential techniques for monitoring Amazon Redshift, including using the console, interpreting system views, and analyzing performance metrics. Learners will gain hands-on knowledge of how to monitor and troubleshoot Redshift clusters effectively. The content emphasizes practical application of monitoring tools and data analysis for optimal system performance.
  • Redshift Serverless
    • This module covers the fundamentals of Amazon Redshift Serverless, including how to create and manage resources, perform data loading and unloading, integrate with ZeroETL, and migrate from provisioned clusters. Learners will gain hands-on experience with query tuning, performance optimization, and architectural best practices.
  • Detailed Redshift Pricing
    • This module explores the key factors influencing Amazon Redshift pricing, including compute, storage, and various deployment models. Learners will understand how to plan and estimate costs using AWS tools. It equips learners with practical skills to analyze and manage Redshift billing scenarios.
  • Redshift Additional Information
    • This module explores the integration, comparison, best practices, and limitations of AWS Redshift within the broader data warehousing landscape. Learners will gain insights into its behavior, use cases, and challenges compared to other services like Snowflake, while also practicing practical workflow applications.

Taught by

Packt - Course Instructors

Reviews

Start your review of AWS Redshift: Infrastructure, Performance, and Security

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.