Amazon Redshift Quick Start Guide

More Information
Learn
  • Set up and configure Redshift
  • Analyze large volumes of data using Redshift
  • implement a simple database in Redshift
  • Learn ETL design for Redshift in detail along with disaster recovery
  • Implement parallel processing in Redshift
  • Integrate Redshift with other AWS services
About

Amazon Redshift is a fast and scalable database that can be used for analysis work on large volumes of data. This book will be your guide to understand how to operate Redshift correctly.

The book starts with a very brief introduction to the different database types and their uses and then bringing you to Redshift and why is it useful. It then moves to the fundamental database theory, which is the set theory, and will cover all about sorting, column-storage and the zone map.

It will teach you some core concepts which need to be understood to operate Redshift correctly. These concepts include joins, column compression, materialization strategy, data distribution and many more. Moving ahead, the book covers the administrative and practical aspects of Redshift. These include vacuum behavior, query compilation, and the Redshift Spectrum. It will also cover ETL design for Redshift in detail along with disaster recovery. Finally, you will learn how to implement a simple database and understand the output of the ANALYZE command which is critical to developing database systems.

By the end of this book, you will have all the knowledge you need to get started with using Amazon Redshift for your warehousing and data processing needs.

Features
  • Quick introduction to Redshift cluster management and how to administer it effectively
  • Implement effective Extract, Transform, and Load (ETL) and faster Big Data processing on AWS using Redshift
  • Includes tips on ensuring high performance of your Redshift cluster without spending a lot of time on it
Course Length tbc
ISBN 9781788996914
Date Of Publication 9 Apr 2020