Skip to content
Write a review
UdemyAWSPaid courseIntermediate levelCertificate

A Real World Introduction to Amazon's Redshift (Udemy.com)

Learn how to spin up Redshift Clusters and load data into Redshift Tables

4.0
105 reviews

Created by: Mike West

Last updated March 2016

icon
What you will learn

  • Be able to provision a Redshift Data Warehouse Cluster
  • You'll learn how to create tables and load data
  • The course was designed for DBAs and developers who want to get up to speed with Redshift as quickly as possible.

How it compares

Against the other 235 rated Udemy courses in AWS on CourseDuck:

  • Rating4.0 out of 5higher than 10% of them
  • Reviews105#204 of 236 by number of reviews
  • Length1.1 hoursshorter than 99% of them
  • Last updatedMarch 2016earlier than 99% of them

icon
Course Description

Note: The vast majority of the first section is free. Please view these free videos. They will give you an idea of how the rest of the course is structured. Thank you. 

Although a gross oversimplification, Amazon Redshift is a traditional data warehouse platform.

Data warehousing has been around for quite a number of years now. There have been many evolutions in data modeling, storage, and ultimately the vast variety of tools that the business user now has available to help utilize their quickly growing stores of data.

As the industry is moving more towards self service business intelligence solutions for business users, there are also changes in how data is being stored. Amazon Redshift is one of those "game-changing" platforms that is not only driving down the total cost, but also driving up the ability to store even more data to enable even better business decisions to be made.

One of the greatest features about all Amazon’s service is that much of the mundane administration tasks have been removed. The hardware, software patching, and disk management (all of which are no small tasks) have been taken on by Amazon. Disk management, particularly the automated recovery from disk failure, and even the ability to begin querying a cluster that is being restored (even before it is done) are all powerful and compelling things Amazon has done to reduce your workload and increase up-time.

In the course we will create nodes, called redshift cluster. Once we spun up a node we can upload our data sets and perform data analysis. We will walk through all the steps necessary to begin using a redshift cluster in the real world.

One of the greatest benefits of Redshift is blazing fast query performance. There are two core items that are responsible for this. The use of columnar storage technology to improve I/O efficiency and parallelizing queries across multiple nodes. The parallelizing of queries across many nodes is known as MPP or Massive Parallel Processing.

The underlying hardware is designed for high performance data processing, using local attached storage to maximize throughput between the CPUs and drives, and a 10GigE mesh network to maximize throughput between nodes.

The last nail in the coffin for the traditional brick and mortal data warehouse is cost. Redshift accomplishes all this at a fraction of the cost of the traditional data warehouse.

If you are looking to expand your knowledge about Amazon’s data platform and specially about their Redshift service then this course is for you.

Thank you and welcome to Redshift.

Read More Intermediate Intermediate Level product length iconTime: 1.1h

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Get the Udemy discount

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Mike West

I'm the founder of LogikBot. I've worked at Microsoft and Uber. I helped design courses for Microsoft's Data Science Certifications. If you're interested in machine learning, I can help.

I've worked with databases for over two decades. I've worked for or consulted with over 50 different companies as a full time employee or consultant. Fortune 500 as well as several small to mid-size companies. Some include: Georgia Pacific, SunTrust, Reed Construction Data, Building Systems Design, NetCertainty, The Home Shopping Network, SwingVote, Atlanta Gas and Light and Northrup Grumman. 

Over the last five years I've transitioned to the exciting world of applied machine learning.  I'm excited to show you what I've learned and help you move into one of the single most important fields in this space.

Experience, education and passion 

I learn something almost every day. I work with insanely smart people. I'm a voracious learner of all things SQL Server and I'm passionate about sharing what I've learned. My area of concentration is performance tuning. SQL Server is like an exotic sports car, it will run just fine in anyone's hands but put it in the hands of skilled tuner and it will perform like a race car. 

Certifications  

Read More

icon
More courses by Mike West

$14.99

Free

$13.99

$69.99

$54.99

$54.99

All courses by Mike West

icon
More AWS courses

$99.99

$49.99

$99.99

$124.99

$22.99

$84.99

All AWS courses

icon
Reviews

4.0

105 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

Write a review

By Jackie Cabrera-lindonen on 1/25/2020

Is a good beginning class. exactly what I need. His explanation are very clear and with some humor.

By Brensley Foster on 3/27/2019

Mike made things very intuitive with a fun twist. Ask Mike stated "Simple is better"

By Alexander Luft on 3/3/2019

Gut für Anfänger ohne ein jegliches Grundverständnis für Cloudtechnologie. Wenn man sich schon ein bisschen durchgeklickt hat, kennt man die Keypoints schon. Trotzdem habe ich auch, nach ersten Selbstversuchen in der AWS, noch Einiges dazugelernt.

By Rajat Rodge on 2/7/2019

It's a great course for absolute beginners in the field of Redshift. Quick takeaways and important points for reviews are very helpful.

By Patrick McPeck on 12/28/2018

The instructor speaks clearly and you will have no problem understanding what he is talking about. You will learn what Redshift is and how it compares to a normal database. You will learn a little about Data Warehousing. You will learn how to create an AWS account and how to stand up an instance. Then you will learn how to load data. It is very high level and no real best practices are talked about. Honestly I could have learned all of this from the AWS content provided for free. It was easier to listen to these videos than read.

By Spence Verde on 7/17/2017

The presenter is engaging. The material is at a level that I can understand. However, at this early point in the course, I haven't had any major new insights into the subject at hand.

By Anupama Kulapputtil on 6/24/2017

The course was clearly presented so it was easy to grasp the concepts and technology though I am new to this technology.

By Rajeev Sagar on 6/22/2017

Course is good for a introduction. But I still feel that the introduction could have been even better if some links/material was given to go through, after the course completion. For example, in Section 3 quiz, I was asked if WriteLatency is a CloudWatch metric or not. It was never discussed in the course. How can I expect myself to answer that question correctly? Also, how would I know what other metrics are monitored by CloudWatch? Some web-links which provide the exhaustive list of such metrics would have been helpful here. Although I am not entirely satisfied with the course, I am still happy with what I got here. I understood a few basics which would certainly help me in my career. Also, I want to highlight that I was able to successfully finish the course in approx. 90 minutes. This is definitely a good thing. I wish more courses were like this one. That is, Short and Simple!

By Kieran O'Brien on 11/28/2016

course was clear but expected more content. expected each of setup screen parameters to be discussed. fine at a discounted price , got me "generally" familiar with the topic quickly but would have felt very short changed had I paid the full price

By Todd Jensen on 4/1/2016

Good Introduction course. While not a deep dive the instructor keeps it simple and covers the basic need to know topics to get you started.

Showing all 10 reviews on CourseDuck

Read all 105 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 80 / 100

A Real World Introduction to Amazon's Redshift
Visit course on Udemy Write a review
  • Video Duration: icon 1.1h
  • Price: $39.99
  • Provider: icon Udemy
  • Updated: icon March 2016
  • Level: Intermediate Intermediate
  • Language: icon English
  • Certificate: icon Yes
30-day money-back guarantee on most paid courses

Udemy Coupon Price Tracker

Udemy price history

For any issues or feature requests please email CourseDuck's Co-Founder at mkuhlman12@gmail.com