✔ Amazon Web Services Stack
✔ Introduction to Amazon DATABASE

✔ AWS Redshift – Data Warehouse-as-a-Service

✔ Features
✔ Pricing

✔ Clusters
✔ Leader and Compute Nodes
✔ Node Slices
✔ Columnar Storage for performance
✔ Economics of Redshift
✔ Common Use cases

✔ Launch a new Redshift Cluster
✔ Modifying a Cluster – resize, showdown, delete, reboot.
✔ Security Groups.
✔ Parameter groups.
✔ Database Encryption.
✔ Backup and recovery – creating manual snapshots and automatic snapshots.
✔ Authorize access to Cluster
✔ Getting Information about Cluster Configuration.
✔ Database Audit Logging

✔ Install and configure client SQL tools using
✔ Create Database, Users, user groups, permissions, and access controls.
✔ Connect to Redshift Cluster
✔ Load sample data into the cluster
✔ Create and test queries against the data

✔ Analyzing cluster Performance data
✔ Analyze query execution
✔ Creating Alarm and working with performance metrics

✔ DDL SQL – Creating Tables, Alter tables, Drop tables.
✔ LIMITATIONS and what is implemented differently.
✔ Selecting distribution Style and distribution keys.
✔ Selecting Sort Key.
✔ Choose best Distribution key covering various use cases
✔ Choosing best sort keys covering various use cases.
✔ Choosing a column compression type.
✔ Define constraints

✔ Using Copy to Load data
✔ Loading data from S3
✔ Using a Manifest to Specify Data Files
✔ Loading Compressed Files
✔ Loading Fixed-Width Data

✔ Insert, Select, Update, Delete
✔ Deep Copy
✔ System Tables for Troubleshooting Data Loads

✔ Unloading Data to Amazon S3
✔ Unloading Data in Delimited or Fixed-Width Format
✔ Reloading Unloaded Data

✔ Query Processing
✔ Query Planning and Execution Workflow
✔ Reviewing Query Plan Steps
✔ Query Plan
✔ Factors Affecting Query Performance
✔ Analyzing and Improving Queries
✔ Query Analysis Workflow
✔ Reviewing Query Alerts
✔ Analyzing the Query Plan
✔ Analyzing the Query Summary
✔ Improving Query Performance
✔ Diagnostic Queries for Query Tuning
✔ Implementing Workload Management
✔ Defining Query Queues
✔ Modifying the WLM Configuration
✔ WLM Queue Assignment Rules
✔ Assigning Queries to QueuesDynamic and Static Properties
✔ Monitoring Workload Management
✔ Configuring WLM Queues to Improve Query Processing
✔ Troubleshooting Queries
✔ Building Admin queries from system tables to analyze performance.
✔ Migration of Existing BI Systems to Redshift
✔ Build custom ETL and/or ELT framework from an OLTP db to Redshift
✔ Limitations and Best Practices for Redshift Data warehouse implementation.