4.38 out of 5
4.38
300 reviews on Udemy

Mastering Amazon Redshift – Development and Administration

Professional Amazon Redshift Training - Develop petabyte size massively parallel processing data warehouse on AWS cloud
Instructor:
Siddharth Mehta
1,851 students enrolled
Work independently on Redshift development as well as administration and confidently apply for Redshift related jobs
Develop deep knowledge in Redshift Architecture, Processing and Performance
Learn A-to-Z about Redshift Development as well as Administration

Amazon Redshift is one of the key big-data analytics related services in the Amazon Web Services technology stack. Redshift can handle thousands of Terabytes (petabyte) sized data in a clustered environment, and provides data warehouse as a service on Amazon Cloud platform. Redshift is one of the relatively easier services to learn for big data scale analytics – which means an easy gateway to your entry in the big data analytics world.

Most of the projects on Amazon cloud would host their data either in DynamoDB or RDS, but would eventually ship all their data in Redshift or EMR for analytics. Redshift is also a heavy-weight topic in AWS Certified Big Data Specialty exam. 

In this course, author and instructor Siddharth Mehta would teach you A to Z of Redshift to an extent that you would master Redshift to a professional level. Course has a 40-60 weight on Theory-to-Labs. All the topics related to development, administration, performance tuning, operations and maintenance, real-world scenarios, and AWS exam related topics are covered in this course. All these topics are explained with professional quality architecture diagrams and crisp presentation, along with demos of all the labs covered in the course. After completing this course, you can confidently apply or pursue any Redshift related jobs / interviews.

Introduction and Pre-requisites

1
Instructor and Redshift - Introduction

Introduction to Amazon Redshift and Instructor, and answer to few questions like what is redshift, why to use the same, which companies use Redshift etc.

2
Pre-requisites - What you'll need for this course

Learn the skills and tools you need before your start pursuing this course.

3
Course Objectives

Learn the three course objectives of this course which explains who are the suitable audience for this course

4
Course Content, Convention and Resources

Learn how to navigate through this course, access resources, and refer to the documentation explained in this course.

Amazon Redshift Architecture and Setup - Theory

1
Section Agenda

Agenda of the topics covered in Section 2

2
Fundamentals - Types of Data Stores

Learn fundamentals of columnar data stores and benefits of columnar data stores

3
Amazon Redshift Data Warehouse Architecture Overview

Learn high-level architecture of Amazon Redshift

4
Amazon Redshift Internal Architecture and Key Features

Learn detail level architecture of Amazon Redshift

5
Amazon Redshift Fundamental Constructs

Learn about different database objects in Amazon Redshift

6
Amazon Redshift Cluster Sizing

Learn about different node types and node sizes in Amazon Redshift to determine the right size of your cluster

7
Amazon Redshift Cluster Network Configuration

Learn about network configuration and topology in AWS to understand the positioning of your Redshift cluster in AWS Network.

8
Resources

Read Amazon Reshift Frequently Asked Questions

Amazon Redshift Basic Operations - Labs

1
Section Agenda

Agenda of the topics covered in Section 3

2
Lab - Creating an Amazon Redshift cluster

Learn how to create a new Amazon Redshift Cluster

3
Lab - Terminating Amazon Redshift Cluster

Learn how to delete an existing Amazon Redshift Cluster

4
Lab - Monitoring Cost of Amazon Redshift Cluster

Learn how to monitor and analyze cost of running an Amazon Redshift Cluster

5
Lab - SQL Client Installation, Set-up and Guided-Tour

Learn how to install SQL Client Software using which you can work with Redshift Cluster Free of Cost

6
Lab - Amazon Redshift Server Configuration

Configure Database and Server parameters to configure a new Redshift Cluster

7
Lab - Loading Sample Data into Amazon Redshift

Learn how to copy sample data into Amazon Redshift Cluster

8
Lab - Backup and Restore of Amazon Redshift Cluster

Learn how to backup and restore an Amazon Redshift Cluster to save costs

9
Authorizing Redshift to access Amazon Services

Learn how to authorize Amazon Redshift to access other AWS Services like Amazon S3

10
Lab - Acceptance Testing Amazon Redshift Cluster

Learn how to execute scripts to perform acceptance testing on a new redshift environment that you generally receive from infrastructure teams who may be building your cluster.

11
Resources

Links to download FREE SQL Client Software to connect with Amazon Redshift Cluster

Amazon Redshift - DDL Commands

1
Section Agenda

Agenda of the topics covered in Section 4

2
Data Types and Operators in Amazon Redshift

Learn about Theory of different data types and operators in Amazon Redshift

3
Lab - Data Types and Operators in Amazon Redshift

Practice working with different data types and operators in Amazon Redshift

4
CREATE Objects with DDL commands in Amazon Redshift

Learn how to create different database objects in Amazon Redshift

5
MODIFY Objects with DDL commands in Amazon Redshift

Learn how to modify different database objects in Amazon Redshift

6
DELETE Objects with DDL commands in Amazon Redshift

Learn how to delete different database objects in Amazon Redshift

7
Lab - DDL Statement in Amazon Redshift

Practice how to create, modify and delete different database objects in Amazon Redshift

Amazon Redshift - DML Commands

1
Section Agenda

Agenda of the topics covered in Section 5

2
Loading Data in Amazon Redshift

Learn how to load data from an external source in Amazon Redshift.

3
Lab - Loading Data in Amazon Redshift

Practice how to load data from an external source in Amazon Redshift. Sensitive details will be masked in this chapter.

4
Lab - Unloading Or Downloading Data from Amazon Redshift

Learn and practice how to extract data from Amazon Redshift

5
SQL Statements for CRUD Operations in Amazon Redshift

Learn about CRUD related SQL Statements in Amazon Redshift

6
SQL Statements for Transactions in Amazon Redshift

Learn SQL Statements to create and manage transactions in Amazon Redshift

7
SQL Statements for System Statistics in Amazon Redshift

Learn about SQL Statements that deals with System Statistics that are used to Amazon Redshift Query Engine

8
Lab - SQL Statements for Administering Privileges in Amazon Redshift

Practice how to work with privileges administration in Amazon Redshift

9
Built-in Functions, Expressions and Operators in Amazon Redshift

Learn about different functions, expressions and operators available in Amazon Redshift

Amazon Redshift - Advanced Table Design

1
Section Agenda

Agenda of the topics covered in Section 6

2
Lab: Amazon Redshift Table Design - Compression Encodings

Learn how to apply compression to reduce the size of the data and improve query performance in Amazon Redshift

3
Lab: Amazon Redshift Table Design - Distribution Styles

Learn different styles of distributing data in an Amazon Redshift Cluster

4
Update: 28-Mar-2019 : Redshift automatically selects table distribution style

Redshift automatically selects table distribution style

5
Lab: Amazon Redshift Table Design - Sort Keys

Learn different styles of sorting data in Amazon Redshift Cluster

6
Amazon Redshift Table Design - Constraints

Learn how to add different constraints and options to a table in an Amazon Redshift Cluster

7
Table Design Resources

Links to Amazon Documentation and Reference Material on Table Design

Amazon Redshift System Information

1
Section Agenda

Agenda of the topics covered in Section 7

2
System and Catalog Tables in Amazon Redshift

Learn about all the system and catalog tables in an Amazon Redshift Cluster

3
System Views in Amazon Redshift

Learn about all the system views in an Amazon Redshift Cluster

Performance Tuning and Optimizing Queries in Amazon Redshift

1
Section Agenda

Agenda of the topics covered in Section 8

2
Lab: Query Planning and Execution Workflow in Amazon Redshift

Learn and practice analyzing and fine tuning performance of queries in an Amazon Redshift Cluster

3
Query Performance Factors in Amazon Redshift

Learn about difference factors and considerations that affect query performance in an Amazon Redshift Cluster

4
How to Diagnose Query Performance in Amazon Redshift

Learn about frequently encountered performance issues, how to detect or confirm performance issues, and how to fix these issues.

Operations and Workload Management in Amazon Redshift

1
Section Agenda

Agenda of the topics covered in Section 9

2
Lab: Incremental data loads in Amazon Redshift

Learn and practice how to implement incremental data loads in an Amazon Redshift Cluster

3
Parameter Groups in Amazon Redshift

Learn how to implement operations and management in an Amazon Redshift Cluster

4
Workload Management in Amazon Redshift

Learn how to implement operations and management in an Amazon Redshift Cluster

5
Lab: Parameters Groups and Workload Management in Amazon Redshift

Practice how to implement operations and management in an Amazon Redshift Cluster

Amazon Redshift Cluster Administration

1
Section Agenda

Agenda of the topics covered in Section 10

2
Amazon Redshift Limits

Learn the limits and capacities of Amazon Redshift Clusters

3
Lab: Configuration and Status Overview of Amazon Redshift Dashboard

Learn how to create a configuration and status dashboard in an Amazon Redshift Cluster

4
Lab: Advanced Network Configuration of Amazon Redshift Cluster

Learn how to configure advanced network settings in an Amazon Redshift Cluster

5
Lab: Resource Tagging in Amazon Redshift Cluster

Learn how to add tags to resources in an Amazon Redshift Cluster

6
Lab: Events and Subscriptions in Amazon Redshift Cluster

Learn how to monitor events and subscribe for notifications in an Amazon Redshift Cluster

7
Lab: Auditing and Logging in Amazon Redshift Cluster

Learn how to configure different types of activities in an Amazon Redshift Cluster

8
Lab: Backups and Disaster Recovery in Amazon Redshift

Learn how to configure Backups and Disaster Recovery Solution in an Amazon Redshift Cluster

9
Lab: Backups and Disaster Recovery in Amazon Redshift Cluster

Practice how to configure Backups and Disaster Recovery Solution in an Amazon Redshift Cluster

10
Lab: Performance Monitoring of Amazon Redshift Cluster

Learn how to monitor performance in an Amazon Redshift Cluster

11
Lab: Developing Cluster Management Dashboards for Amazon Redshift Cluster

Learn how to develop management dashboardss in an Amazon Redshift Cluster

12
Lab: Resizing Amazon Redshift Cluster

Learn how to resize an Amazon Redshift Cluster

13
Cost Optimization of Amazon Redshift Cluster

Learn how to optimize costs and save 40 to 70 percent costs of hosting an Amazon Redshift Cluster

14
Lab: Data Encryption in Amazon Redshift Cluster

Learn how to configure encryption and security in an Amazon Redshift Cluster

15
Amazon Redshift Best Practices

Links to Amazon documentation of Amazon Redshift Best Practices

Wrap-up

1
Clean-Up Amazon Redshift Resources

Learn how to clean swipe AWS account and delete all Redshift related resources to ensure you are not charged.

Redshift Updates - 2018, 2019

1
04-Oct-2018 : Query editor to run Redshift queries from AWS Console

Query editor to run Redshift queries from AWS Console

2
31-May-2018 : Self Optimizing Short Query Acceleration

Self Optimizing Short Query Acceleration

3
05-June-2018 : Copy ORC and Parquet Data in Redshift

Copy ORC and Parquet Data in Redshift

4
26-July-2018 : Redsift Customized Best Practice Recommendation with Advisor

Redsift Customized Best Practice Recommendation with Advisor

5
30-July-2018 : Cluster Performance metrics in Amazon Redshift

Cluster Performance metrics in Amazon Redshift

6
07-Aug-2018 : Support for lateral column alias reference in Amazon Redshift

Support for lateral column alias reference in Amazon Redshift

7
16-Oct-2018 : Encrypt existing unencrypted Redshift cluster

Encrypt existing unencrypted Redshift cluster

8
15-Nov-2018 : Redshift Elastic Resize vs Classic Resize

Redshift Elastic Resize vs Classic Resize

9
20-Nov-2018 : Redshift Deferred Maintenance with Advance Event Notifications

Redshift Deferred Maintenance with Advance Event Notifications

10
19-Dec-2018 : Redshift Automatic Vacuum Delete

Redshift Automatic Vacuum Delete

11
18-Jan-2019 : Redshift automatic Table Statistics update

Redshift automatic Table Statistics update

12
27-Mar-2019 : Redshift concurrency scaling

Redshift concurrency scaling

13
04-Apr-2019 : Redshift snapshot enhancements

Redshift snapshot enhancements

Summary

You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.4
4.4 out of 5
300 Ratings

Detailed Rating

Stars 5
130
Stars 4
114
Stars 3
45
Stars 2
9
Stars 1
3
27a9178bfb0d1696511a1d7160914a04
30-Day Money-Back Guarantee

Includes

12 hours on-demand video
6 articles
Full lifetime access
Access on mobile and TV
Certificate of Completion