Create and Manage Redshift Clusters on AWS

In this course, you will learn about building and managing Redshift clusters on AWS or Amazon Web Services. Here you will learn to create and customise both single-node and multi-node clusters on the cloud, where you can perform various kinds of operations on these clusters, such as storage, retrieval and analysis of datasets kept in the form of records and tables in databases. You will also learn to manage these clusters and perform various actions such as resizing the cluster, setting up alarms, scheduled maintenance, routine checkups and performance monitoring.

A Redshift cluster needs to be linked with a Virtual Private Cloud or VPC, and with an Identity and Access Management role or IAM role on AWS. You will learn to create an IAM role for adding security and authentication to your clusters and VPC for optimal performance on dedicated network parameters, where you can customise subnets, internet gateways and other network components.

When your cluster is ready and running on the cloud, you may write and run SQL queries on the Redshift query editor. Here you will learn to write and execute multiple SQL queries for finding insights from the dataset and to perform various analytical operations based on certain conditions. Moreover, you would also learn to save and provision SQL queries that can be executed at a predefined date and time. Scheduled queries are highly important for routine backup, maintenance, creation of shards, analysis, and other tasks.

This course has a pragmatic approach, so everything is taught with practical examples to help learners understand these advanced concepts easily and quickly without wasting much time on long, boring theoretical lessons. You can find these skills useful in various domains related to database administration and cloud computing, where a Redshift cluster is involved. 

What is Amazon Redshift?

Amazon Redshift is a fully managed, petabyte-scale data warehouse service in the cloud. This enables you to use your data to acquire new insights from the dataset. Redshift is an advanced and popular data warehousing service on AWS. Redshift is read-optimised, which makes it massively faster as compared to traditional relational databases that are write-optimised.

What is Data Warehousing?

Data Warehousing is used to store a generally very large dataset that is either meant for archival usage or for analytics. The warehouse becomes a library of historical data that can be retrieved and analysed in order to inform decision-making in the business.