1 / 21

Amazon Redshift Tutorial | AWS Tutorial for Beginners | AWS Certification Training | Edureka

(AWS Certification Training: https://www.edureka.co/cloudcomputing) <br>This u201cAmazon Redshift" tutorial by Edureka will help you understand what Amazon Redshift is & how to set up a data warehouse on cloud using Amazon Redshift. Below are the topics covered in the ppt: <br>1. Traditional Data Warehouse <br>2. Amazon Redshift u2013 A to Z <br>3. Demo on Amazon Redshift <br><br>Check out our complete AWS Playlist here: https://goo.gl/8qrfKU

EdurekaIN
Download Presentation

Amazon Redshift Tutorial | AWS Tutorial for Beginners | AWS Certification Training | Edureka

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Agenda 1 Traditional Data Warehouse 2 Amazon Redshift – A to Z 3 Demo On Amazon Redshift Amazon Redshift https://www.edureka.co/cloudcomputing AWS Architect Certification Training

  2. Traditional Data Warehouse Copyright © 2018, edureka and/or its affiliates. All rights reserved.

  3. Data Warehouse “A data warehouse is a subject-oriented, integrated, time-variant and non-volatile collection of data in support of organisation’s decision-making process” https://www.edureka.co/cloudcomputing AWS Architect Certification Training

  4. Architecture Of Traditional Data Warehouse Data Sources Bottom Tier Top Tier Middle Tier OLAP Server Data Warehouse Query Reports Operational Database Analytics OLAP Server Data Marts Data Mining External Sources https://www.edureka.co/cloudcomputing AWS Architect Certification Training

  5. Disadvantages of Traditional Data Warehouse Difficult to scale up or down Difficult to set-up, deploy & manage Business Services Company Spiralling costs Performance Issues https://www.edureka.co/cloudcomputing AWS Architect Certification Training

  6. Amazon Redshift Copyright © 2018, edureka and/or its affiliates. All rights reserved.

  7. Amazon Redshift It is a massively parallel, column-orientated database deployed on the AWS platform that makes it simple and cost-effective to analyse all your data across your data warehouse and data lake. Amazon Redshift https://www.edureka.co/cloudcomputing AWS Architect Certification Training

  8. Key Concepts Cluster & Nodes Nodes Client Applications Dense Storage(DS) ODBC JDBC Dense Compute(DC) Leader Node Node you choose depends on: Data Quantity 1 ….. Compute Noden Compute Node1 Complexity Of Queries 2 Node Slices Node Slices Downstream Systems 3 https://www.edureka.co/cloudcomputing AWS Architect Certification Training

  9. Key Concepts Client Applications ODBC JDBC Leader Node ….. Compute Noden Compute Node1 Node Slices Node Slices https://www.edureka.co/cloudcomputing AWS Architect Certification Training

  10. Why Use Amazon Redshift 1 1 Difficult to set-up, deploy & manage Easy to set-up, deploy & manage Manage, Monitor & Scale Deploy with just a click Configure the details https://www.edureka.co/cloudcomputing AWS Architect Certification Training

  11. Why Use Amazon Redshift 2 2 Difficult to scale up or down Scales quickly to meet you needs LN LN Cluster CN CN CN CN CN CN CN LN Scale-Up Scale-Down LN CN CN CN LN CN CN CN CN Single-Node Multiple-Node https://www.edureka.co/cloudcomputing AWS Architect Certification Training

  12. Why Use Amazon Redshift 3 3 Columnar Data Store Decrease in the performance 10x better & faster performance Column Storage Row Storage SSN NAME Jenson Sam AGE 25 27 SSN NAME Jenson Sam AGE 25 27 107135024 382634557 107135024 382634557 107135024 | Jenson | 25 Block 1 382634557 | 107135024 | …… Jenson | Sam | …… Block 2 382634557 | Sam | 25 Block 2 Block 1 https://www.edureka.co/cloudcomputing AWS Architect Certification Training

  13. Why Use Amazon Redshift 3 Massively Parallel Processing - Clustering 10x better & faster performance Cluster LN CN CN CN Compute Node1 https://www.edureka.co/cloudcomputing AWS Architect Certification Training

  14. Why Use Amazon Redshift 4 4 Spiralling - costs Cost - Effective Cost – Effective & 1/10thof traditional data warehouse Cheaper to set-up because of no hardware or upfront costs https://www.edureka.co/cloudcomputing AWS Architect Certification Training

  15. Why Use Amazon Redshift 5 Allows to query from data lake Needs More Effort & Cost Data Catalog ( CSV, Paraquet, TSV, RCFile etc) Data Lake Amazon Redshift Spectrum Amazon Redshift https://www.edureka.co/cloudcomputing AWS Architect Certification Training

  16. Why Use Amazon Redshift 6 Backup & Recovery Data is secure in Redshift Encryption S3 101101 101101 101000 101000 101101 101000 101000 101101 https://www.edureka.co/cloudcomputing AWS Architect Certification Training

  17. Demo - Setting Up A Data Warehouse Copyright © 2018, edureka and/or its affiliates. All rights reserved.

  18. Prerequisites Install SQL Drivers & Tools Install SQL Workbench/J Install JDBC Driver Make sure you have Java Runtime Enabled on your OS https://www.edureka.co/cloudcomputing AWS Architect Certification Training

  19. https://www.edureka.co/cloudcomputing AWS Architect Certification Training

More Related