Getting Started with Amazon Redshift

Start by learning the fundamentals and then progress to creating and managing your own Redshift cluster. This guide walks you step-by-step through the world of big data, cloud computing, and scalable data warehousing.
Preview in Mapt

Getting Started with Amazon Redshift

Stefan Bauer

Start by learning the fundamentals and then progress to creating and managing your own Redshift cluster. This guide walks you step-by-step through the world of big data, cloud computing, and scalable data warehousing.
Mapt Subscription
FREE
$29.99/m after trial
eBook
$10.50
RRP $14.99
Save 29%
Print + eBook
$29.99
RRP $29.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$10.50
$29.99
$29.99 p/m after trial
RRP $14.99
RRP $29.99
Subscription
eBook
Print + eBook
Start 30 Day Trial

Frequently bought together


Getting Started with Amazon Redshift Book Cover
Getting Started with Amazon Redshift
$ 14.99
$ 10.50
Getting Started with Deep Learning with R [Integrated Course] Book Cover
Getting Started with Deep Learning with R [Integrated Course]
$ 124.99
$ 106.25
Buy 2 for $28.00
Save $111.98
Add to Cart

Book Details

ISBN 139781782178088
Paperback154 pages

Book Description

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.

Table of Contents

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
Summary
Chapter 3: 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
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
Working with tables
Summary
Chapter 6: Best Practices
Security
Cluster configuration
Database maintenance
Cluster operation
Database design
Monitoring
Data processing
Summary

What You Will Learn

  • 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

Authors

Table of Contents

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
Summary
Chapter 3: 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
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
Working with tables
Summary
Chapter 6: Best Practices
Security
Cluster configuration
Database maintenance
Cluster operation
Database design
Monitoring
Data processing
Summary

Book Details

ISBN 139781782178088
Paperback154 pages
Read More

Read More Reviews

Recommended for You

Data Lake Development with Big Data Book Cover
Data Lake Development with Big Data
$ 27.99
$ 19.60
Amazon EC2 Cookbook Book Cover
Amazon EC2 Cookbook
$ 27.99
$ 19.60
Learning pandas Book Cover
Learning pandas
$ 47.99
$ 33.60
Chef Essentials Book Cover
Chef Essentials
$ 26.99
$ 18.90
Big Data Analytics Book Cover
Big Data Analytics
$ 39.99
$ 28.00
Microsoft Azure: Enterprise Application Development Book Cover
Microsoft Azure: Enterprise Application Development
$ 26.99
$ 18.90