PacktLib: Getting Started with Amazon Redshift

Getting Started with Amazon Redshift

Credits

About the Author

About the Reviewers

www.PacktPub.com

Preface

Overview

Pricing

Configuration options

Data storage

Considerations for your environment

Summary

Transition to Redshift

Cluster configurations

Cluster creation

Cluster details

SQL Workbench and other query tools

Unsupported features

Command line

The PSQL command line

Summary

Loading Your Data to Redshift

Datatypes

Schemas

Connecting to S3

The copy command

Load troubleshooting

ETL products

Performance monitoring

Indexing strategies

Sort keys

Distribution keys

Summary

Managing Your Data

Backup and recovery

Resize

Table maintenance

Workload Management (WLM)

Compression

Streaming data

Query optimizer

Summary

Querying Data

SQL syntax considerations

Query performance monitoring

Explain plans

Working with tables

Summary

Best Practices

Security

Cluster configuration

Database maintenance

Cluster operation

Database design

Monitoring

Data processing

Summary

Reference Materials

Reference Materials

Reference Materials

Reference Materials

Reference Materials

Reference Materials

Reference Materials

Index