Mastering Amazon Redshift Development & Administration from Udemy

What's inside

Learning objectives

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

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

Syllabus

Learn about instructor, pre-requisites to pursue this course, objectives this course aims to achieve and how to navigate this course selectively.

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.

IMPORTANT : SKIP COURSE SECTIONS AS PER YOUR EXPERTISE

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

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

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

Learn about the theory of Amazon Redshift Architecture and Setup of a client tool to access Redshift in detail.

Agenda of the topics covered in Section 2

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

Learn high-level architecture of Amazon Redshift

Learn detail level architecture of Amazon Redshift

Learn about different database objects in Amazon Redshift

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

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

Read Amazon Reshift Frequently Asked Questions

Learn and practice basic operations of Amazon Redshift to begin hands-on working on Amazon Redshift

Agenda of the topics covered in Section 3

New Redshift Console UI

Learn how to create a new Amazon Redshift Cluster

Creating Redshift cluster using NEW Redshift Console

Learn how to delete an existing Amazon Redshift Cluster

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

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

Configure Database and Server parameters to configure a new Redshift Cluster

Learn how to copy sample data into Amazon Redshift Cluster

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

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

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.

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

Learn and practice different Data Definition Language commands in Amazon Redshift

Agenda of the topics covered in Section 4

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

Practice working with different data types and operators in Amazon Redshift

Learn how to create different database objects in Amazon Redshift

Learn how to modify different database objects in Amazon Redshift

Learn how to delete different database objects in Amazon Redshift

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

Learn and practice different Data Manipulation Language commands in Amazon Redshift

Agenda of the topics covered in Section 5

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

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

Learn and practice how to extract data from Amazon Redshift

Learn about CRUD related SQL Statements in Amazon Redshift

Learn SQL Statements to create and manage transactions in Amazon Redshift

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

Practice how to work with privileges administration in Amazon Redshift

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

Learn about advanced and core concepts of Table Design in Amazon Redshift

Agenda of the topics covered in Section 6

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

Learn different styles of distributing data in an Amazon Redshift Cluster

Redshift automatically selects table distribution style

Learn different styles of sorting data in Amazon Redshift Cluster

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

Links to Amazon Documentation and Reference Material on Table Design

Learn about all the system tables, catalog tables and system views in Amazon Redshift

Agenda of the topics covered in Section 7

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

Learn about all the system views in an Amazon Redshift Cluster

Learn about internals of query design, execution, workflow, debugging and optimization in Amazon Redshift

Agenda of the topics covered in Section 8

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

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

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

Learn how to configure a Redshift Amazon Cluster for optimizing resource usage by different tasks executed on an Amazon Redshift Cluster

Agenda of the topics covered in Section 9

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

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

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

Learn about a variety of administration topics in Amazon Redshift like Configuration, Networking, Encryption, Disaster Recovery, Clusting Sizing, Alerts, and Performance Monitoring

Agenda of the topics covered in Section 10

Learn the limits and capacities of Amazon Redshift Clusters

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

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

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

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

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

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

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

Learn how to monitor performance in an Amazon Redshift Cluster

Learn how to develop management dashboardss in an Amazon Redshift Cluster

Learn how to resize an Amazon Redshift Cluster

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

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

Links to Amazon documentation of Amazon Redshift Best Practices

Learn which resources you should delete after you are done with all the labs in the course

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

Learn about Amazon Redshift Updates in the Year 2018, 2019, and 2020

Query editor to run Redshift queries from AWS Console

Self Optimizing Short Query Acceleration

Copy ORC and Parquet Data in Redshift

Redsift Customized Best Practice Recommendation with Advisor

Cluster Performance metrics in Amazon Redshift

Support for lateral column alias reference in Amazon Redshift

Encrypt existing unencrypted Redshift cluster

Redshift Elastic Resize vs Classic Resize

Redshift Deferred Maintenance with Advance Event Notifications

Redshift Automatic Vacuum Delete

Redshift New Features & Releases - 2019

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Teaches learners how to apply for and execute job functions related to Amazon Redshift

Develops foundational and advanced knowledge in the setup, use, and function of Amazon Redshift

Continually updated with Amazon Redshift's latest feature and software releases

Target audience is defined by those with knowledge and experience in cloud computing, sql, and AWS

Reviews summary

Practical redshift course

Learners say that this course is a good learning experience that is especially beneficial for those who prefer hands-on learning. However, it might lack some detail for more experienced learners.

Students enjoyed the hands-on practice.

"This was a good information."

"always learn with hands on practice"

"Good job..."

The course may lack sufficient detail.

"Was looking for bit more detail information"

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Mastering Amazon Redshift Development & Administration with these activities:

Review SQL

Show steps

Reinforce your understanding of SQL, a fundamental skill for working with Redshift.

Browse courses on Structured Query Language

Show steps

Review basic SQL syntax and concepts.
Practice writing SQL queries to select, filter, and aggregate data.

Build a Simple Data Pipeline

Show steps

Apply your Redshift skills by creating a basic data pipeline to load and transform data.

Browse courses on Data Pipelines

Show steps

Design the data pipeline architecture.
Create a data source and a Redshift cluster.
Write a script to extract data from the source and load it into Redshift.
Test the data pipeline and optimize performance.

Performance Tuning Drills

Show steps

Sharpen your Redshift performance tuning skills through targeted exercises.

Browse courses on Performance Tuning

Show steps

Identify common performance bottlenecks in Redshift.
Practice techniques to optimize query performance, such as using indexes and partitioning.

One other activity

Expand to see all activities and additional details

Show all four activities

Redshift Database Design Document

Show steps

Document your understanding of Redshift data modeling principles by creating a design document for a sample database.

Browse courses on Data Modeling

Show steps

Define the business requirements and data model for the database.
Design the Redshift schema, including tables, columns, and relationships.
Write a detailed design document that outlines the database structure and functionality.

Career center

Learners who complete Mastering Amazon Redshift Development & Administration will develop knowledge and skills that may be useful to these careers:

Amazon Redshift Administrator

An Amazon Redshift administrator is responsible for the administration and management of Redshift data warehouses. This course will provide you with the skills and knowledge you need to be successful in this role. You will learn how to install, configure, and manage Redshift clusters, as well as how to monitor their performance and troubleshoot any issues.

See salaries and explore the career path for Amazon Redshift Administrator

Amazon Redshift Developer

An Amazon Redshift developer is responsible for the development and maintenance of data warehouses using Amazon Redshift. This course will provide you with the skills and knowledge you need to be successful in this role. You will learn how to design, develop, and maintain Redshift data warehouses, as well as how to optimize their performance.

See salaries and explore the career path for Amazon Redshift Developer

Data Scientist

A data scientist is responsible for using data to solve business problems. This course will provide you with the skills and knowledge you need to be successful in this role. You will learn how to use Redshift to build and train machine learning models, as well as how to interpret and communicate your results.

See salaries and explore the career path for Data Scientist

Data Analyst

A data analyst is responsible for collecting, cleaning, and analyzing data to identify trends and patterns. This course will provide you with the skills and knowledge you need to be successful in this role. You will learn how to use Redshift to query and analyze data, as well as how to create visualizations to communicate your findings.

See salaries and explore the career path for Data Analyst

Big Data Engineer

A big data engineer is responsible for designing, building, and maintaining big data systems. This course will provide you with the skills and knowledge you need to be successful in this role. You will learn how to use Redshift to process and analyze big data, as well as how to build and maintain data pipelines.

See salaries and explore the career path for Big Data Engineer

Database Administrator

A database administrator is responsible for the administration and management of databases. This course will provide you with the skills and knowledge you need to be successful in this role. You will learn how to install, configure, and manage Redshift clusters, as well as how to monitor their performance and troubleshoot any issues.

See salaries and explore the career path for Database Administrator

Cloud Architect

A cloud architect is responsible for designing, building, and maintaining cloud-based solutions. This course will provide you with the skills and knowledge you need to be successful in this role. You will learn how to use Redshift to build and manage data warehouses in the cloud, as well as how to integrate Redshift with other cloud services.

See salaries and explore the career path for Cloud Architect

Database Developer

A database developer is responsible for designing, developing, and maintaining databases. This course may be useful for database developers who are interested in developing databases that use Redshift. You will learn how to use Redshift to store and manage data, as well as how to query and analyze data using Redshift.

See salaries and explore the career path for Database Developer

Data Warehouse Architect

A data warehouse architect is responsible for designing and building data warehouses. This course may be useful for data warehouse architects who are interested in using Redshift to build data warehouses. You will learn how to use Redshift to design and build data warehouses, as well as how to optimize their performance.

See salaries and explore the career path for Data Warehouse Architect

Technical Architect

A technical architect is responsible for designing and building technical solutions. This course may be useful for technical architects who are interested in designing and building solutions that use Redshift. You will learn how to use Redshift to store and manage data, as well as how to query and analyze data using Redshift.

See salaries and explore the career path for Technical Architect

Data Engineer

A data engineer is responsible for designing, building, and maintaining data pipelines. This course may be useful for data engineers who are interested in using Redshift to build data pipelines. You will learn how to use Redshift to process and analyze data, as well as how to build and maintain data pipelines.

See salaries and explore the career path for Data Engineer

Software Engineer

A software engineer is responsible for designing, developing, and maintaining software applications. This course may be useful for software engineers who are interested in developing applications that use Redshift. You will learn how to use Redshift to store and manage data, as well as how to query and analyze data using Redshift.

See salaries and explore the career path for Software Engineer

Business Intelligence Analyst

A business intelligence analyst is responsible for collecting, analyzing, and interpreting data to help businesses make better decisions. This course may be useful for business intelligence analysts who are interested in using Redshift to analyze data. You will learn how to use Redshift to query and analyze data, as well as how to create visualizations to communicate your findings.

See salaries and explore the career path for Business Intelligence Analyst

Systems Analyst

A systems analyst is responsible for analyzing and designing computer systems. This course may be useful for systems analysts who are interested in analyzing and designing systems that use Redshift. You will learn how to use Redshift to store and manage data, as well as how to query and analyze data using Redshift.

See salaries and explore the career path for Systems Analyst