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

Developing Scalable Apps in Python
Google via Udacity
Capstone: Retrieving, Processing, and Visualizing Data with Python
University of Michigan via Coursera
Teaching Impacts of Technology: Workplace of the Future
University of California, San Diego via Coursera
Build Native Mobile Apps with Flutter
Google via Udacity
Health Informatics and Technology in Decision Making
Doane University via edX