Introduction and Pre-requisites
  • Instructor and Redshift - Introduction
  • IMPORTANT : SKIP COURSE SECTIONS AS PER YOUR EXPERTISE
  • Pre-requisites - What you'll need for this course
  • Course Objectives
  • Course Content, Convention and Resources
Amazon Redshift Architecture and Setup - Theory
  • Section Agenda
  • Fundamentals - Types of Data Stores
  • Amazon Redshift Data Warehouse Architecture Overview
  • Amazon Redshift Internal Architecture and Key Features
  • Amazon Redshift Fundamental Constructs
  • Amazon Redshift Cluster Sizing
  • Amazon Redshift Cluster Network Configuration
  • Resources
Amazon Redshift Basic Operations - Labs
  • Section Agenda
  • New Redshift Console UI
  • Lab - Creating an Amazon Redshift cluster
  • Lab - Creating Redshift cluster using NEW Redshift Console
  • Lab - Terminating Amazon Redshift Cluster
  • Lab - Monitoring Cost of Amazon Redshift Cluster
  • Lab - SQL Client Installation, Set-up and Guided-Tour
  • Lab - Amazon Redshift Server Configuration
  • Lab - Loading Sample Data into Amazon Redshift
  • Lab - Backup and Restore of Amazon Redshift Cluster
  • Authorizing Redshift to access Amazon Services
  • Lab - Acceptance Testing Amazon Redshift Cluster
  • Resources
Amazon Redshift - DDL Commands
  • Section Agenda
  • Data Types and Operators in Amazon Redshift
  • Lab - Data Types and Operators in Amazon Redshift
  • CREATE Objects with DDL commands in Amazon Redshift
  • MODIFY Objects with DDL commands in Amazon Redshift
  • DELETE Objects with DDL commands in Amazon Redshift
  • Lab - DDL Statement in Amazon Redshift
Amazon Redshift - DML Commands
  • Section Agenda
  • Loading Data in Amazon Redshift
  • Lab - Loading Data in Amazon Redshift
  • Lab - Unloading Or Downloading Data from Amazon Redshift
  • SQL Statements for CRUD Operations in Amazon Redshift
  • SQL Statements for Transactions in Amazon Redshift
  • SQL Statements for System Statistics in Amazon Redshift
  • Lab - SQL Statements for Administering Privileges in Amazon Redshift
  • Built-in Functions, Expressions and Operators in Amazon Redshift
Amazon Redshift - Advanced Table Design
  • Section Agenda
  • Lab: Amazon Redshift Table Design - Compression Encodings
  • Lab: Amazon Redshift Table Design - Distribution Styles
  • Update: 28-Mar-2019 : Redshift automatically selects table distribution style
  • Lab: Amazon Redshift Table Design - Sort Keys
  • Amazon Redshift Table Design - Constraints
  • Table Design Resources
Amazon Redshift System Information
  • Section Agenda
  • System and Catalog Tables in Amazon Redshift
  • System Views in Amazon Redshift
Performance Tuning and Optimizing Queries in Amazon Redshift
  • Section Agenda
  • Lab: Query Planning and Execution Workflow in Amazon Redshift
  • Query Performance Factors in Amazon Redshift
  • How to Diagnose Query Performance in Amazon Redshift
Operations and Workload Management in Amazon Redshift
  • Section Agenda
  • Lab: Incremental data loads in Amazon Redshift
  • Parameter Groups in Amazon Redshift
  • Workload Management in Amazon Redshift
  • Lab: Parameters Groups and Workload Management in Amazon Redshift
Amazon Redshift Cluster Administration
  • Section Agenda
  • Amazon Redshift Limits
  • Lab: Configuration and Status Overview of Amazon Redshift Dashboard
  • Lab: Advanced Network Configuration of Amazon Redshift Cluster
  • Lab: Resource Tagging in Amazon Redshift Cluster
  • Lab: Events and Subscriptions in Amazon Redshift Cluster
  • Lab: Auditing and Logging in Amazon Redshift Cluster
  • Lab: Backups and Disaster Recovery in Amazon Redshift
  • Lab: Backups and Disaster Recovery in Amazon Redshift Cluster
  • Lab: Performance Monitoring of Amazon Redshift Cluster
  • Lab: Developing Cluster Management Dashboards for Amazon Redshift Cluster
  • Lab: Resizing Amazon Redshift Cluster
  • Cost Optimization of Amazon Redshift Cluster
  • Lab: Data Encryption in Amazon Redshift Cluster
  • Amazon Redshift Best Practices
Wrap-up
  • Clean-Up Amazon Redshift Resources
Redshift New Features & Releases - 2018
  • 04-Oct-2018 : Query editor to run Redshift queries from AWS Console
  • 31-May-2018 : Self Optimizing Short Query Acceleration
  • 05-June-2018 : Copy ORC and Parquet Data in Redshift
  • 26-July-2018 : Redshift Customized Best Practice Recommendation with Advisor
  • 30-July-2018 : Cluster Performance metrics in Amazon Redshift
  • 07-Aug-2018 : Support for lateral column alias reference in Amazon Redshift
  • 16-Oct-2018 : Encrypt existing unencrypted Redshift cluster
  • 15-Nov-2018 : Redshift Elastic Resize vs Classic Resize
  • 20-Nov-2018 : Redshift Deferred Maintenance with Advance Event Notifications
  • 19-Dec-2018 : Redshift Automatic Vacuum Delete
Redshift New Features & Releases - 2019