Getting Started with Amazon Redshift

Getting Started with Amazon Redshift
eBook: $14.99
Formats: PDF, PacktLib, ePub and Mobi formats
save 15%!
Print + free eBook + free PacktLib access to the book: $44.98    Print cover: $29.99
save 33%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Table of Contents
Sample Chapters
  • Step-by-step instructions to create and manage your Redshift cluster
  • Understand the technology behind the database engine, as you learn about compression, block level storage, and column stores
  • Learn the implementation and database design considerations you will need to understand to successfully implement your own Amazon Redshift cluster

Book Details

Language : English
Paperback : 154 pages [ 235mm x 191mm ]
Release Date : June 2013
ISBN : 1782178082
ISBN 13 : 9781782178088
Author(s) : Stefan Bauer
Topics and Technologies : All Books, Big Data and Business Intelligence, Data, Cloud, Enterprise

Table of Contents

Chapter 1: Overview
Chapter 2: Transition to Redshift
Chapter 3: Loading Your Data to Redshift
Chapter 4: Managing Your Data
Chapter 5: Querying Data
Chapter 6: Best Practices
Appendix: Reference Materials
  • Chapter 1: Overview
    • Pricing
    • Configuration options
    • Data storage
    • Considerations for your environment
    • Summary
    • Chapter 2: Transition to Redshift
      • Cluster configurations
      • Cluster creation
      • Cluster details
      • SQL Workbench and other query tools
      • Unsupported features
      • Command line
      • The PSQL command line
        • Connection options
        • Output format options
        • General options
        • API
      • Summary
      • Chapter 3: Loading Your Data to Redshift
        • Datatypes
        • Schemas
          • Table creation
        • Connecting to S3
        • The copy command
        • Load troubleshooting
        • ETL products
        • Performance monitoring
        • Indexing strategies
        • Sort keys
        • Distribution keys
        • Summary
        • Chapter 4: Managing Your Data
          • Backup and recovery
          • Resize
          • Table maintenance
          • Workload Management (WLM)
          • Compression
          • Streaming data
          • Query optimizer
          • Summary
          • Chapter 5: Querying Data
            • SQL syntax considerations
            • Query performance monitoring
            • Explain plans
              • Sequential scan
              • Joins
              • Sorts and aggregations
            • Working with tables
              • Insert/update
              • Alter
            • Summary
            • Chapter 6: Best Practices
              • Security
              • Cluster configuration
              • Database maintenance
              • Cluster operation
              • Database design
              • Monitoring
              • Data processing
              • Summary

                Stefan Bauer

                Stefan Bauer has worked in business intelligence and data warehousing since the late 1990s on a variety of platforms in a variety of industries. Stefan has worked with most major databases, including Oracle, Informix, SQL Server, and Amazon Redshift as well as other data storage models, such as Hadoop. Stefan provides insight into hardware architecture, database modeling, as well as developing in a variety of ETL and BI tools, including Integration Services, Informatica, Analysis Services, Reporting Services, Pentaho, and others. In addition to traditional development, Stefan enjoys teaching topics on architecture, database administration, and performance tuning. Redshift is a natural extension fit for Stefan's broad understanding of database technologies and how they relate to building enterprise-class data warehouses.

                Code Downloads

                Download the code and support files for this book.

                Submit Errata

                Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.


                - 1 submitted: last submission 19 May 2014

                Errata type: Others | Page number: 36

                On page 36, under the "The PSQL command line" section, the command line follows a paragraph which is formatted as command line itself. Please don't consider it as part of the command.

                Sample chapters

                You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

                Frequently bought together

                Getting Started with Amazon Redshift +    Squid Proxy Server 3.1: Beginner's Guide =
                50% Off
                the second eBook
                Price for both: $30.45

                Buy both these recommended eBooks together and get 50% off the cheapest eBook.

                What you will learn from this book

                • Provision your own Redshift cluster
                • Connect third party tools and software to your Redshift cluster
                • Load data using Redshift's copy tools and manage your data files
                • Manage queries through the implementation of Workload Management
                • Gain an understanding of the underlying architecture, everything from a detailed view of compression, to column store block-level storage
                • Resize your cluster and use Redshift scalability to expand and grow with ease as your data storage needs grow

                In Detail

                Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse service. It provides an excellent approach to analyzing all your data using your existing business intelligence tools.

                Getting Started with Amazon Redshift is an easy-to-read, descriptive guide that breaks down the complex topics of data warehousing and Amazon Redshift. You will learn the fundamentals of Redshift technology and how to implement your own Redshift cluster, through practical, real-world examples. This exciting new technology is a powerful tool in your arsenal of data management and this book is a must-have to implement and manage your next enterprise Data Warehouse.

                Packed with detailed descriptions, diagrams, and explanations, Getting Started with Amazon Redshift will bring you along, regardless of your current level of understanding, to a point where you will feel comfortable with running your own Redshift cluster. The author's own experiences will give you an understanding of what you will need to consider when working with your own data. You will also learn about how compression has been implemented and what that means relative to a column store database structure. As you progress, you will gain an understanding of monitoring techniques, performance considerations, and what it will take to successfully run your Amazon Redshift cluster on a day-to-day basis. There truly is something in this book for everyone who is interested in learning about this technology.


                Getting Started With Amazon Redshift is a step-by-step, practical guide to the world of Redshift. Learn to load, manage, and query data on Redshift.

                Who this book is for

                This book is for CIOs, enterprise architects, developers, and anyone else who needs to get familiar with RedShift. The CIO will gain an understanding of what their technical staff is working on; the technical implementation personnel will get an in-depth view of the technology, and what it will take to implement their own solutions.

                Code Download and Errata
                Packt Anytime, Anywhere
                Register Books
                Print Upgrades
                eBook Downloads
                Video Support
                Contact Us
                Awards Voting Nominations Previous Winners
                Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
                Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software