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.

Osoby które kupowały "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", wybierały także:

• Windows Media Center. Domowe centrum rozrywki 66,67 zÅ‚, (8,00 zÅ‚ -88%)
• Ruby on Rails. Ćwiczenia 18,75 zÅ‚, (3,00 zÅ‚ -84%)
• Przywództwo w Å›wiecie VUCA. Jak być skutecznym liderem w niepewnym Å›rodowisku 58,64 zÅ‚, (12,90 zÅ‚ -78%)
• Scrum. O zwinnym zarzÄ…dzaniu projektami. Wydanie II rozszerzone 58,64 zÅ‚, (12,90 zÅ‚ -78%)
• Od hierarchii do turkusu, czyli jak zarzÄ…dzać w XXI wieku 58,64 zÅ‚, (12,90 zÅ‚ -78%)

Spis treści

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 eBook -- spis treści

• Getting Started with Amazon Redshift
  • Table of Contents
  • Getting Started with Amazon Redshift
  • Credits
  • About the Author
  • About the Reviewers
  • www.PacktPub.com
    • Support files, eBooks, discount offers and more
      • Why Subscribe?
      • Free Access for Packt account holders
      • Instant Updates on New Packt Books
  • Preface
    • What this book covers
    • What you need for this book
    • Who this book is for
    • Conventions
    • Reader feedback
    • Customer support
      • Downloading the example code
      • Errata
      • Piracy
      • Questions
  • 1. Overview
    • Pricing
    • Configuration options
    • Data storage
    • Considerations for your environment
    • Summary
  • 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
  • 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
  • 4. Managing Your Data
    • Backup and recovery
    • Resize
    • Table maintenance
    • Workload Management (WLM)
    • Compression
    • Streaming data
    • Query optimizer
    • Summary
  • 5. Querying Data
    • SQL syntax considerations
    • Query performance monitoring
    • Explain plans
      • Sequential scan
      • Joins
      • Sorts and aggregations
    • Working with tables
      • Insert/update
      • Alter
    • Summary
  • 6. Best Practices
    • Security
    • Cluster configuration
    • Database maintenance
    • Cluster operation
    • Database design
    • Monitoring
    • Data processing
    • Summary
  • A. Reference Materials
    • Cluster terminology
    • Compression
    • Datatypes
    • SQL commands
    • System tables
    • Third-party tools and software
  • Index