HOT
blank

Mastering Amazon Redshift Development & Administration

Development

Rating4.5
Enroll Now

Mastering Amazon Redshift Development & Administration, available at $69.99, has an average rating of 4.48, with 147 lectures, based on 2388 reviews, and has 16514 subscribers.

You will learn about 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 This course is ideal for individuals who are Anyone who wants to learn Redshift and secure a job role like Analyst / Developer / Architect / Administrator can take this course or Students who are pursuing AWS Big Data Specialty exam can take this course It is particularly useful for Anyone who wants to learn Redshift and secure a job role like Analyst / Developer / Architect / Administrator can take this course or Students who are pursuing AWS Big Data Specialty exam can take this course.

Enroll now: Mastering Amazon Redshift Development & Administration

Summary

Title: Mastering Amazon Redshift Development & Administration

Price: $69.99

Average Rating: 4.48

Number of Lectures: 147

Number of Published Lectures: 147

Number of Curriculum Items: 147

Number of Published Curriculum Objects: 147

Original Price: $89.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

  • 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

Target Audiences

  • 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

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.

Course Curriculum

Chapter 1: Introduction and Pre-requisites

Lecture 1: Instructor and Redshift – Introduction

Lecture 2: IMPORTANT : SKIP COURSE SECTIONS AS PER YOUR EXPERTISE

Lecture 3: Pre-requisites – What you'll need for this course

Lecture 4: Course Objectives

Lecture 5: Course Content, Convention and Resources

Chapter 2: Amazon Redshift Architecture and Setup – Theory

Lecture 1: Section Agenda

Lecture 2: Fundamentals – Types of Data Stores

Lecture 3: Amazon Redshift Data Warehouse Architecture Overview

Lecture 4: Amazon Redshift Internal Architecture and Key Features

Lecture 5: Amazon Redshift Fundamental Constructs

Lecture 6: Amazon Redshift Cluster Sizing

Lecture 7: Amazon Redshift Cluster Network Configuration

Lecture 8: Resources

Chapter 3: Amazon Redshift Basic Operations – Labs

Lecture 1: Section Agenda

Lecture 2: New Redshift Console UI

Lecture 3: Lab – Creating an Amazon Redshift cluster

Lecture 4: Lab – Creating Redshift cluster using NEW Redshift Console

Lecture 5: Lab – Terminating Amazon Redshift Cluster

Lecture 6: Lab – Monitoring Cost of Amazon Redshift Cluster

Lecture 7: Lab – SQL Client Installation, Set-up and Guided-Tour

Lecture 8: Lab – Amazon Redshift Server Configuration

Lecture 9: Lab – Loading Sample Data into Amazon Redshift

Lecture 10: Lab – Backup and Restore of Amazon Redshift Cluster

Lecture 11: Authorizing Redshift to access Amazon Services

Lecture 12: Lab – Acceptance Testing Amazon Redshift Cluster

Lecture 13: Resources

Chapter 4: Amazon Redshift – DDL Commands

Lecture 1: Section Agenda

Lecture 2: Data Types and Operators in Amazon Redshift

Lecture 3: Lab – Data Types and Operators in Amazon Redshift

Lecture 4: CREATE Objects with DDL commands in Amazon Redshift

Lecture 5: MODIFY Objects with DDL commands in Amazon Redshift

Lecture 6: DELETE Objects with DDL commands in Amazon Redshift

Lecture 7: Lab – DDL Statement in Amazon Redshift

Chapter 5: Amazon Redshift – DML Commands

Lecture 1: Section Agenda

Lecture 2: Loading Data in Amazon Redshift

Lecture 3: Lab – Loading Data in Amazon Redshift

Lecture 4: Lab – Unloading Or Downloading Data from Amazon Redshift

Lecture 5: SQL Statements for CRUD Operations in Amazon Redshift

Lecture 6: SQL Statements for Transactions in Amazon Redshift

Lecture 7: SQL Statements for System Statistics in Amazon Redshift

Lecture 8: Lab – SQL Statements for Administering Privileges in Amazon Redshift

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

Chapter 6: Amazon Redshift – Advanced Table Design

Lecture 1: Section Agenda

Lecture 2: Lab: Amazon Redshift Table Design – Compression Encodings

Lecture 3: Lab: Amazon Redshift Table Design – Distribution Styles

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

Lecture 5: Lab: Amazon Redshift Table Design – Sort Keys

Lecture 6: Amazon Redshift Table Design – Constraints

Lecture 7: Table Design Resources

Chapter 7: Amazon Redshift System Information

Lecture 1: Section Agenda

Lecture 2: System and Catalog Tables in Amazon Redshift

Lecture 3: System Views in Amazon Redshift

Chapter 8: Performance Tuning and Optimizing Queries in Amazon Redshift

Lecture 1: Section Agenda

Lecture 2: Lab: Query Planning and Execution Workflow in Amazon Redshift

Lecture 3: Query Performance Factors in Amazon Redshift

Lecture 4: How to Diagnose Query Performance in Amazon Redshift

Chapter 9: Operations and Workload Management in Amazon Redshift

Lecture 1: Section Agenda

Lecture 2: Lab: Incremental data loads in Amazon Redshift

Lecture 3: Parameter Groups in Amazon Redshift

Lecture 4: Workload Management in Amazon Redshift

Lecture 5: Lab: Parameters Groups and Workload Management in Amazon Redshift

Chapter 10: Amazon Redshift Cluster Administration

Lecture 1: Section Agenda

Lecture 2: Amazon Redshift Limits

Lecture 3: Lab: Configuration and Status Overview of Amazon Redshift Dashboard

Lecture 4: Lab: Advanced Network Configuration of Amazon Redshift Cluster

Lecture 5: Lab: Resource Tagging in Amazon Redshift Cluster

Lecture 6: Lab: Events and Subscriptions in Amazon Redshift Cluster

Lecture 7: Lab: Auditing and Logging in Amazon Redshift Cluster

Lecture 8: Lab: Backups and Disaster Recovery in Amazon Redshift

Lecture 9: Lab: Backups and Disaster Recovery in Amazon Redshift Cluster

Lecture 10: Lab: Performance Monitoring of Amazon Redshift Cluster

Lecture 11: Lab: Developing Cluster Management Dashboards for Amazon Redshift Cluster

Lecture 12: Lab: Resizing Amazon Redshift Cluster

Lecture 13: Cost Optimization of Amazon Redshift Cluster

Lecture 14: Lab: Data Encryption in Amazon Redshift Cluster

Lecture 15: Amazon Redshift Best Practices

Chapter 11: Wrap-up

Lecture 1: Clean-Up Amazon Redshift Resources

Chapter 12: Redshift New Features & Releases – 2018

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

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

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

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

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

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

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

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

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

Lecture 10: 19-Dec-2018 : Redshift Automatic Vacuum Delete

Chapter 13: Redshift New Features & Releases – 2019

Instructors

Rating Distribution

  • 1 stars: 47 votes
  • 2 stars: 70 votes
  • 3 stars: 315 votes
  • 4 stars: 882 votes
  • 5 stars: 1074 votes

Frequently Asked Questions


How long do I have access to the course materials?


You can view and review the lecture materials indefinitely, like an on-demand channel.


Can I take my courses with me wherever I go?


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!

You may also like

Top 10 Ethical AI Courses to Learn in November 2024

Top 10 Game Development Courses to Learn in November 2024

Top 10 Software Testing Courses to Learn in November 2024