Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Hands-On Amazon Redshift for Data Warehousing
Rating: 3.9 out of 5(45 ratings)
275 students

Hands-On Amazon Redshift for Data Warehousing

Leverage cutting-edge techniques to build data warehouses in the cloud
Created byPackt Publishing
Last updated 7/2023
English

What you'll learn

  • Understand data warehousing principles and how Redshift is challenging the traditional way of thinkingf
  • See how Redshift integrates with the AWS Cloud ecosystem
  • Learn how Redshift leverages the latest technology to provide up to 10x the performance of competing technologies
  • Create a cloud-native, fully managed data warehouse and use it to join together disparate data sets
  • Connect your new data warehouse with disjointed data stored on Amazon S3 with Redshift Spectrum
  • Visualize your newly connected data sets with Amazon QuickSight
  • Dive headfirst into building a Redshift data warehouse using a diversified data set
  • Connect to and optimize your data warehouse and join data sets together
  • Connect data in your data warehouse with data on Amazon S3 with Redshift spectrum

Course content

6 sections • 23 lectures • 2h 13m total length

  • The Course Overview2:51

    This video gives a glimpse of the entire course.

  • Do We Still Need a Data Warehouse?6:20

    Understanding the use cases for data warehousing in a modern data landscape.

       •  Understand the data landscape today

       •  Understand the case for BI

       •  Have a look at the BI Use cases

  • Data Technologies Compared: Relational, Data Warehouse, NoSQL, and Big Data5:04

    Understanding the modern data landscape and the technologies that make it up.

       •  Understand NoSQL

       •  Understand big data

       •  Understand RDBMS

  • Providing Business Intelligence on Internet Scale Data5:37

    Understanding the BI use case in detail and how to solve that problem on large datasets.

       •  Have a look at the BI use case

       •  Scale up the BI tools

  • Cloud-Native Data Warehousing3:33

    Introducing cloud native BI data warehouse tools like Redshift.

       •  Go through the Cloud Native Data Tools

       •  Introduction to Redshift

       •  Cloud native data warehousing

Requirements

  • Familiarity with AWS is assumed.

Description

Amazon Redshift is a low-cost cloud data platform that can scale from gigabytes to petabytes on a high-performance, column-oriented SQL engine. Amazon Redshift brings the power of scale-out architecture to the world of traditional data warehousing.

In this course, you will explore this low-cost, cloud-based storage, which can be scaled up or down to meet your true size and performance needs. You will learn to configure a sample data warehouse. Next, you will explore Redshift's internal workings and architecture, and learn what makes it so fast. You will get hands-on experience connecting, querying, and building BI and data viz products and 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

Colibri Digital is a technology consultancy company founded in 2015 by James and Ingrid Cross. The company works to help its clients navigate the rapidly changing and complex world of emerging technologies, with deep expertise in areas like big data, data science, machine learning, and cloud computing.

Over the past few years they have worked with some of the world's largest and most prestigious companies, including tier 1 investment banks, a leading management consultancy group, and one of the world's most popular soft drinks companies, helping each of them to better make sense of its data, and process it in more intelligent ways.

At the frontier of AI, big data and cloud computing, we are Colibri Digital.

James Cross is a big data engineer and certified AWS Solutions architect with a passion for data-driven applications. He's spent the last 3-5 years helping his clients to design and implement huge-scale streaming big data platforms, Cloud-based analytics stacks, and serverless architectures.

He started his professional career in Investment Banking, working with well-established technologies such as Java and SQL Server, before moving into the big data space. Since then, he's worked with a huge range of big data tools including most of the Hadoop eco-system, Spark, and many No-SQL technologies such as Cassandra, MongoDB, Redis, and DynamoDB. More recently, his focus has been on Cloud technologies and how they can be applied to data analytics, culminating in his work at Scout Solutions as a CTO, and more recently with Mckinsey.

James is an AWS-certified solutions architect with several years' experience designing and implementing solutions on this cloud platform. As the CTO of Scout Solutions Ltd, he built a fully serverless set of API's and an analytics stack based around Lambda and Redshift.

Who this course is for:

  • If you are a data analyst, data scientist, or AWS professional and are looking for a data warehouse solution using AWS services, then this course is for you! It is also suitable for professionals using DynamoDB, RDS, or any other AWS Database services.

Report abuse