Redshift

Redshift

Price : ₹11,000.00

Offer Price : Contact for Price

Estimated Hours : 40 HOURS

Overview

Amazon Redshift is a fully managed, petabyte-scale data warehouse service in the cloud. You can start with just a few hundred gigabytes of data and scale to a petabyte or more. This enables you to use your data to acquire new insights for your business and customers.

Objective

It allows you to run complex analytic queries against petabytes of structured data, using sophisticated query optimization, columnar storage on high-performance local disks, and massively parallel query execution. In this course we start from the basic AWS storage service S3 and explore multiple option before going deep in to redshift. The course starts with overview of AWS and related Big Data services.

Amazon RedShift is a fast, fully managed data warehouse that makes it simple and cost-effective to analyze all your data using standard SQL and your existing Business Intelligence (BI) tools.

Course Curriculum

1.Introduction to Amazon Web services

  • Amazon Web Services Stack
  • Introduction to Amazon DATABASE

2.Introduction to AWS Redshift

  • AWS Redshift – Data Warehouse-as-a-Service
  • Features
  • Pricing

3.Redshift Architecture Overview

  • Clusters
  • Leader and Compute Nodes
  • Node Slices
  • Economics of Redshift
  • Key differentiators
  • Common Use cases

4.DML Operations

  • Insert, Select, Update, Delete
  • Deep Copy
  • LIMITATIONS Troubleshooting
  • S3ServiceException Errors
  • System Tables for Troubleshooting Data Loads
  • Multi-byte Character Load Errors

5.Unloading Data

  • Unloading Data to Amazon S3
  • Unloading Encrypted Data Files
  • Unloading Data in Delimited or Fixed-Width Format
  • Reloading Unloaded Data

Prerequisites

Basic IT application development and deployment concepts, and good understanding of data warehousing and analytic tools.