Amazon Redshift Quick Start Guide
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.
|Date Of Publication||9 Apr 2020|