9781836206903_

Discover how to build a cloud-based data warehouse at petabyte-scale that is burstable and built to scale for end-to-end analytical solutions.

Key Features

Discover how to translate familiar data warehousing concepts into Redshift implementation
Use impressive Redshift features to optimize development, productionizing, and operations processes
Find out how to use advanced features such as concurrency scaling, Redshift Spectrum, and federated queries
Purchase of the print or Kindle book includes a free PDF eBook

Book Description

Amazon Redshift is a fully managed, petabyte-scale AWS cloud data warehousing service. It enables you to build new data warehouse workloads on AWS and migrate on-premises traditional data warehousing platforms to Redshift. This book on Amazon Redshift starts by focusing on Redshift architecture, showing you how to perform database administration tasks on Redshift. Youll then learn how to optimize your data warehouse to quickly execute complex analytic queries against very large datasets. Because of the massive amount of data involved in data warehousing, designing your database for analytical processing lets you take full advantage of Redshifts columnar architecture and managed services. As you advance, youll discover how to deploy fully automated and highly scalable extract, transform, and load (ETL) processes, which help minimize the operational efforts that you have to invest in managing regular ETL pipelines and ensure the timely and accurate refreshing of your data warehouse. By the end of this Redshift book, youll be able to implement a Redshift-based data analytics solution and have understood the best practice solutions to commonly faced problems.

What you will learn

Build scalable petabyte-scale data warehouses with Amazon Redshift
Integrate data warehouses with data lakes using AWS features
Create end-to-end analytical solutions from sourcing to consumption
Utilize Redshifts security for strict business requirements
Apply architectural insights with analytical recipes
Learn big data best practices for managed solutions
Enable data sharing for data mesh and hub/spoke architectures
Explore Redshift ML and generative AI with Amazon Q

Who this book is for

This book is for anyone involved in architecting, implementing, and optimizing an Amazon Redshift data warehouse, such as data warehouse developers, data analysts, database administrators, data engineers, and data scientists. Basic knowledge of data warehousing, database systems, and cloud concepts and familiarity with Redshift will be beneficial.

...(*_*)9781836206903_

Set up a petabyte-scale, cloud-based data warehouse that is burstable and built to scale for end-to-end analytical solutions

Key Features

Learn how to translate familiar data warehousing concepts into Redshift implementation
Use impressive Redshift features to optimize development, productionizing, and operation processes
Find out how to use advanced features such as concurrency scaling, Redshift Spectrum, and federated queries
Purchase of the print or Kindle book includes a free PDF eBook

Book Description

The Amazon Redshift Cookbook offers comprehensive guidance for leveraging AWSs fully managed cloud data warehousing service. Whether youre building new data warehouse workloads or migrating traditional on-premises platforms to the cloud, this essential resource delivers proven implementation strategies. Written by AWS specialists, these easy-to-follow recipes will equip you with the knowledge to successfully implement Amazon Redshift-based data analytics solutions using established best practices. The book focuses on Redshift architecture, showing you how to perform database administration tasks on Redshift. Youll learn how to optimize your data warehouse to quickly execute complex analytic queries against very large datasets. The book covers recipes to help you take full advantage of Redshifts columnar architecture and managed services. Youll discover how to deploy fully automated and highly scalable extract, transform, and load (ETL) processes, helping you minimize the operational efforts that you invest in managing regular ETL pipelines and ensure the timely and accurate refreshing of your data warehouse. By the end of this Redshift book, youll be able to implement a Redshift-based data analytics solution by adopting best practice approaches for solving commonly faced problems.

What you will learn

Integrate data warehouses with data lakes using AWS features
Create end-to-end analytical solutions from sourcing to consumption
Utilize Redshifts security for strict business requirements
Apply architectural insights with analytical recipes
Discover big data best practices for managed solutions
Enable data sharing for data mesh and hub-and-spoke architectures
Explore Redshift ML and generative AI with Amazon Q

Who this book is for

This book is for anyone involved in architecting, implementing, and optimizing an Amazon Redshift data warehouse, including data warehouse developers, data analysts, database administrators, data engineers, and data scientists. Basic knowledge of data warehousing, database systems, as well as cloud concepts and familiarity with Redshift is beneficial.

...(*_*)9781836206903_

Set up a petabyte-scale, cloud-based data warehouse that is burstable and built to scale for end-to-end analytical solutions

Key Features

Learn how to translate familiar data warehousing concepts into Redshift implementation
Use impressive Redshift features to optimize development, productionizing, and operation processes
Find out how to use advanced features such as concurrency scaling, Redshift Spectrum, and federated queries
Purchase of the print or Kindle book includes a free PDF eBook

Book Description

Amazon Redshift Cookbook offers comprehensive guidance for leveraging AWSs fully managed cloud data warehousing service. Whether youre building new data warehouse workloads or migrating traditional on-premises platforms to the cloud, this essential resource delivers proven implementation strategies. Written by AWS specialists, these easy-to-follow recipes will equip you with the knowledge to successfully implement Amazon Redshift-based data analytics solutions using established best practices. The book focuses on Redshift architecture, showing you how to perform database administration tasks on Redshift. Youll learn how to optimize your data warehouse to quickly execute complex analytic queries against very large datasets. The book covers recipes to help you take full advantage of Redshifts columnar architecture and managed services. Youll discover how to deploy fully automated and highly scalable extract, transform, and load (ETL) processes, helping you minimize the operational effort that you invest in managing regular ETL pipelines and ensuring the timely and accurate refreshing of your data warehouse. By the end of this Redshift book, youll be able to implement a Redshift-based data analytics solution by adopting best-practice approaches for solving commonly faced problems.

What you will learn

Integrate data warehouses with data lakes using AWS features
Create end-to-end analytical solutions from sourcing to consumption
Utilize Redshifts security for strict business requirements
Apply architectural insights with analytical recipes
Discover big data best practices for managed solutions
Enable data sharing for data mesh and hub-and-spoke architectures
Explore Redshift ML and generative AI with Amazon Q

Who this book is for

...

Filtros

Editorial Granica Buen Fin.