Mastering Amazon Redshift 2020 Development & Administration
4.3 (901 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
5,728 students enrolled

Mastering Amazon Redshift 2020 Development & Administration

THE BEST Professional Amazon Redshift Training. Every NEW Redshift feature (even preview features) covered with labs.
4.3 (901 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
5,728 students enrolled
Created by Siddharth Mehta
Last updated 7/2020
English
Current price: $69.99 Original price: $99.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 15 hours on-demand video
  • 7 articles
  • 25 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • 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
  • Redshift releases at least 35-50 new features every year. Stay up-to-date and learn these new features in this course
Course content
Expand all 116 lectures 14:58:24
+ Introduction and Pre-requisites
4 lectures 15:23

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.

Preview 04:37

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

Preview 04:11

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

Preview 01:51

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

Course Content, Convention and Resources
04:44
+ Amazon Redshift Architecture and Setup - Theory
8 lectures 01:17:06

Agenda of the topics covered in Section 2

Section Agenda
02:22

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

Fundamentals - Types of Data Stores
20:00

Learn high-level architecture of Amazon Redshift

Preview 10:02

Learn detail level architecture of Amazon Redshift

Amazon Redshift Internal Architecture and Key Features
09:28

Learn about different database objects in Amazon Redshift

Amazon Redshift Fundamental Constructs
10:51

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

Amazon Redshift Cluster Sizing
13:32

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

Amazon Redshift Cluster Network Configuration
10:50

Read Amazon Reshift Frequently Asked Questions

Resources
00:01
+ Amazon Redshift Basic Operations - Labs
12 lectures 01:33:07

Agenda of the topics covered in Section 3

Section Agenda
02:09
New Redshift Console UI
00:43

Learn how to create a new Amazon Redshift Cluster

Lab - Creating an Amazon Redshift cluster
15:00

Learn how to delete an existing Amazon Redshift Cluster

Lab - Terminating Amazon Redshift Cluster
02:55

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

Lab - Monitoring Cost of Amazon Redshift Cluster
04:09

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

Lab - SQL Client Installation, Set-up and Guided-Tour
13:24

Configure Database and Server parameters to configure a new Redshift Cluster

Lab - Amazon Redshift Server Configuration
13:17

Learn how to copy sample data into Amazon Redshift Cluster

Lab - Loading Sample Data into Amazon Redshift
13:28

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

Lab - Backup and Restore of Amazon Redshift Cluster
08:30

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

Authorizing Redshift to access Amazon Services
02:19

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.

Lab - Acceptance Testing Amazon Redshift Cluster
17:06

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

Resources
00:06
+ Amazon Redshift - DDL Commands
7 lectures 01:13:52

Agenda of the topics covered in Section 4

Section Agenda
01:28

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

Data Types and Operators in Amazon Redshift
19:31

Practice working with different data types and operators in Amazon Redshift

Lab - Data Types and Operators in Amazon Redshift
10:23

Learn how to create different database objects in Amazon Redshift

CREATE Objects with DDL commands in Amazon Redshift
19:56

Learn how to modify different database objects in Amazon Redshift

MODIFY Objects with DDL commands in Amazon Redshift
03:59

Learn how to delete different database objects in Amazon Redshift

DELETE Objects with DDL commands in Amazon Redshift
06:28

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

Lab - DDL Statement in Amazon Redshift
12:07
+ Amazon Redshift - DML Commands
9 lectures 01:46:49

Agenda of the topics covered in Section 5

Section Agenda
02:28

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

Loading Data in Amazon Redshift
13:10

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

Lab - Loading Data in Amazon Redshift
14:42

Learn and practice how to extract data from Amazon Redshift

Lab - Unloading Or Downloading Data from Amazon Redshift
11:40

Learn about CRUD related SQL Statements in Amazon Redshift

SQL Statements for CRUD Operations in Amazon Redshift
17:47

Learn SQL Statements to create and manage transactions in Amazon Redshift

SQL Statements for Transactions in Amazon Redshift
13:48

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

SQL Statements for System Statistics in Amazon Redshift
13:17

Practice how to work with privileges administration in Amazon Redshift

Lab - SQL Statements for Administering Privileges in Amazon Redshift
12:36

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

Built-in Functions, Expressions and Operators in Amazon Redshift
07:21
+ Amazon Redshift - Advanced Table Design
7 lectures 58:57

Agenda of the topics covered in Section 6

Section Agenda
01:57

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

Lab: Amazon Redshift Table Design - Compression Encodings
14:29

Learn different styles of distributing data in an Amazon Redshift Cluster

Lab: Amazon Redshift Table Design - Distribution Styles
18:47

Redshift automatically selects table distribution style

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

Learn different styles of sorting data in Amazon Redshift Cluster

Lab: Amazon Redshift Table Design - Sort Keys
14:47

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

Amazon Redshift Table Design - Constraints
08:52

Links to Amazon Documentation and Reference Material on Table Design

Table Design Resources
00:03
+ Amazon Redshift System Information
3 lectures 25:50

Agenda of the topics covered in Section 7

Section Agenda
02:11

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

System and Catalog Tables in Amazon Redshift
17:32

Learn about all the system views in an Amazon Redshift Cluster

System Views in Amazon Redshift
06:07
+ Performance Tuning and Optimizing Queries in Amazon Redshift
4 lectures 36:59

Agenda of the topics covered in Section 8

Section Agenda
01:52

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

Lab: Query Planning and Execution Workflow in Amazon Redshift
17:44

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

Query Performance Factors in Amazon Redshift
10:03

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

How to Diagnose Query Performance in Amazon Redshift
07:20
+ Operations and Workload Management in Amazon Redshift
5 lectures 58:44

Agenda of the topics covered in Section 9

Section Agenda
01:59

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

Lab: Incremental data loads in Amazon Redshift
11:34

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

Parameter Groups in Amazon Redshift
12:11

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

Workload Management in Amazon Redshift
14:20

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

Lab: Parameters Groups and Workload Management in Amazon Redshift
18:40
+ Amazon Redshift Cluster Administration
15 lectures 02:24:07

Agenda of the topics covered in Section 10

Section Agenda
05:53

Learn the limits and capacities of Amazon Redshift Clusters

Amazon Redshift Limits
04:37

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

Lab: Configuration and Status Overview of Amazon Redshift Dashboard
13:10

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

Lab: Advanced Network Configuration of Amazon Redshift Cluster
17:42

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

Lab: Resource Tagging in Amazon Redshift Cluster
05:07

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

Lab: Events and Subscriptions in Amazon Redshift Cluster
12:15

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

Lab: Auditing and Logging in Amazon Redshift Cluster
12:39

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

Lab: Backups and Disaster Recovery in Amazon Redshift
12:18

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

Lab: Backups and Disaster Recovery in Amazon Redshift Cluster
08:14

Learn how to monitor performance in an Amazon Redshift Cluster

Lab: Performance Monitoring of Amazon Redshift Cluster
14:01

Learn how to develop management dashboardss in an Amazon Redshift Cluster

Lab: Developing Cluster Management Dashboards for Amazon Redshift Cluster
09:48

Learn how to resize an Amazon Redshift Cluster

Lab: Resizing Amazon Redshift Cluster
06:15

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

Cost Optimization of Amazon Redshift Cluster
07:47

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

Lab: Data Encryption in Amazon Redshift Cluster
14:16

Links to Amazon documentation of Amazon Redshift Best Practices

Amazon Redshift Best Practices
00:05
Requirements
  • Basic knowledge of database and data warehouse concepts
  • Basic knowledge of AWS Concepts like VPC, S3, and EC2
  • Course includes demo of all the labs. An AWS Account would be required to try labs hands-on.
  • Basic working knowledge of any SQL style query language
  • No prior knowledge of Amazon Redshift is required
Description

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 teaches A to Z of Redshift to an extent that you would master Redshift to a professional level. Course has a 20-80 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.

To ensure everything is covered and students always remain updated with the latest Redshift updates, this course is regularly updated with each and every new update that Redshift keeps releasing. Check out the updates section at the bottom of the course which has updates right from 2018 till date.

Who this course is for:
  • Anyone who wants to learn Redshift and secure a job role like Analyst / Developer / Architect / Administrator can take this course
  • Students who are pursuing AWS Big Data Specialty exam can take this course