Amazon Redshift

1. System Overview

   What Amazon Redshift is and its data warehouse features.

2. Architecture

   Leader node, compute nodes, slices and columnar storage.

3. Table Design Best Practices

   Distribution styles, sort keys and compression encodings.

4. Data Distribution

   KEY, ALL, EVEN and AUTO distribution.

5. Sort Keys

   Compound and interleaved sort keys.

6. Loading Data

   COPY from S3, loading best practices and ingestion.

7. Query Performance

   Query planning, analyzing and tuning.

8. Workload Management

   Queues, concurrency scaling and query priorities.

9. Redshift Spectrum

   Querying data in S3 with external tables.

10. Materialized Views

    Precomputed query results and refresh.

11. Data Sharing

    Sharing live data across clusters and accounts.

12. Redshift Serverless

    Serverless workgroups and namespaces.

13. Security

    Access control, encryption and auditing.

14. Snapshots and Backup

    Automated and manual snapshots and restore.

Each section links to the official page. Titles and summaries by Extra Credit; the docs belong to their authors.