YoVDO

A developer guide for Amazon Redshift

Offered By: Udemy

Tags

Amazon Redshift Courses SQL Courses Data Warehousing Courses Data Retrieval Courses IAM Roles Courses

Course Description

Overview

A complete guide to the BI developer who wants to build a datawarehouse on AWS cloud using Redshift.

What you'll learn:
  • You can master building a datawarehouse on Amazon Redshift
  • Zero to pro in less than 2 hours.

This course covers the Architecture of Redshift, Columnar vs Row oriented databases, Introduce you to the AWS VPC, IAM role, and S3 bucket creation. You can master the SQL with best practices and learn a few admin activities which help to build an effective data warehouse. This course introduces compression/encoding techniques. You can learn to implement Workload management and monitor and tune long-running queries.


I always noticed most of the data engineers are clueless about how data is retrieved from the database. Writing an optimized query is a must when dealing with big data, understanding the architecture and the movement of the data is very important to write the best query.


Without prior knowledge on SQL, you can master the SQL and become a pro with this short 2 Hour tutorial.


Taught by

Sravan Konde

Related Courses

Introduction to AWS Identity and Access Management
Amazon Web Services via edX Creating And Controlling Git Repository Using AWS CodeCommit
Coursera Project Network via Coursera Edición de España: Introducción a AWS Identity and Access Management (IAM) | Introduction to AWS Identity and Access Management (IAM)
Amazon Web Services via AWS Skill Builder Introduction to AWS Identity and Access Management (IAM) (Spanish)
Amazon Web Services via AWS Skill Builder Introduction to AWS Identity and Access Management (IAM) (Traditional Chinese)
Amazon Web Services via AWS Skill Builder