Building Your First Amazon Redshift Data Warehouse

Amazon Redshift is a low-cost cloud data platform that can scale from gigabytes to petabytes on a high performance column-oriented SQL engine. Join data pro Russ Thomas on a demo-heavy dive into Redshift and build your first data warehouse on AWS.
Course info
Rating
(24)
Level
Intermediate
Updated
Mar 9, 2018
Duration
2h 40m
Table of contents
Description
Course info
Rating
(24)
Level
Intermediate
Updated
Mar 9, 2018
Duration
2h 40m
Description

Amazon Redshift brings the power of scale-out architecture to the world of traditional data warehousing. In Building Your First Amazon Redshift Data Warehouse, you will explore this low cost, cloud based storage that can be scaled up or down to meet your true size and performance needs. First, you will learn to stand up and configure a sample data warehouse. Next, you will explore the internal workings and architecture of Redshift and what makes it so fast. Finally, you will get hands on experience connecting, querying, and building BI and data viz products as well as learn how to secure, maintain, and administer your new platform. By the end of this course, you will be able to scale from gigabytes to petabytes on this high performance column-oriented SQL engine.

About the author
About the author

Currently an IT leader in Denver Colorado's financial sector Russ has focused on database development, modelling, administration, and BI since 1997 across the Microsoft stack. Russ is a passionate trainer and SQL community volunteer presenting regularly at PASS SQL Saturday events and local user groups around the US.

More from the author
More courses by Russ Thomas
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Imagine scaling a data warehouse from a handful of gigabytes to petabytes in a few clicks, and not just file fragments spread across mounds of servers. I'm talking actual structed data that you can leverage complex analytical SQL queries against. Column-oriented, OLAP-optimized, relational data, meaning it's fast and being built on a scale-out, cloud-based architecture keeps it fast, even at massive scale. Amazon Redshift is an excited cloud-based data warehousing platform, perfect for folks already familiar with SQL-based databases and languages. Join me, Russ Thomas, in a dive into Redshift. You'll build your own data warehouse, get familiar with the architecture, learn how to query, load, secure, and manage your own cluster in a demo-heavy, fast-paced course. And if you have a background with SQL Server, PostgreSQL, or MySQL, you're going to be amazed at how familiar it all feels. Either way, I don't like spending a lot of time lecturing, so if you want to actually get hands on, get hands on you will. Whether you've been using the cloud, AWS, or this is your first experience with any of this, come join me in this course, and add some legitimate Redshift experience onto your resume.