Amazon Redshift for Beginners

Conceptual and working knowledge to get you onboarded for your job

What you'll learn
Amazon Redshift Architecture and Concepts
Creating free AWS account
SQL concepts
Postgres best practices

Description
This course is intended to provide conceptual as well and working knowledge of AWS Redshift. The course is intended for new joiners in the analytics industry looking for some practical hands-on experience on Redshift.

We start from basics of data warehousing, ETL, Scope of Redshift, Pricing and tools/ Applications/ Drivers.

Then move on to understand the Redshift concepts including Architecture, Clusters, Compute nodes, setting up free AWS account, S3 bucket, etc.

Then deep diving on exceptional Redshift concepts like columnar storage, column encoding, etc

Then learning the SQL and discussing detail about DDL, DML, TCL and DCL commands. In depth discussion on Create table options within Redshift

Finally, additional 2 lectures talks about COPY and UNLOAD commands in Redshift

Aim is to get anyone onboarded to AWS Redshift at the beginner level. With this working knowledge, candidates feel more confident in their day to day work.

The trainer has overall 5 years of work experience in analytics industry. This tutorial series is created to help out any professional at the early stage of their career. This course will help you if -

1) You want to gain practical knowledge of AWS Redshift and want to do hands-on for free

2) You want to setup a Redshift environment and want to know how to do it

3) You want to learn Postgres SQL for any data engineering role

4) You want clarity in terms of Redshift concepts in your career path

Who this course is for
Beginner data warehousing and data engineering professionals