Introduction to Data Analytics on Amazon AWS Cloud

Introduction to Data Analytics on Amazon AWS Cloud, available at $49.99, has an average rating of 4.05, with 68 lectures, 2 quizzes, based on 60 reviews, and has 334 subscribers.

You will learn about Basic SQL Aggregations (SUM, AVG, MIN, MAX) using SQL Cloud Computing Basics Data Warehousing Basics AWS Redshift Essentials Loading Datasets to S3 Bucket Multiple Data Importing Techniques in Redshift AWS Glue (Extract, Transform, Load Process) Exporting S3 Data to AWS Redshift Security Group Settings Data Visualization on AWS QuickSight Dataset Report Generation and Sharing This course is ideal for individuals who are Beginners in Data Visualization, Data Warehousing. or Students at their initial stage of learning Amazon Web Services. or Students at their initial stage of learning AWS Redshift. or Beginners in learning AWS Glue for ETL Service It is particularly useful for Beginners in Data Visualization, Data Warehousing. or Students at their initial stage of learning Amazon Web Services. or Students at their initial stage of learning AWS Redshift. or Beginners in learning AWS Glue for ETL Service.

Enroll now: Introduction to Data Analytics on Amazon AWS Cloud

Summary

Title: Introduction to Data Analytics on Amazon AWS Cloud

Price: $49.99

Average Rating: 4.05

Number of Lectures: 68

Number of Quizzes: 2

Number of Published Lectures: 68

Number of Published Quizzes: 2

Number of Curriculum Items: 70

Number of Published Curriculum Objects: 70

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Basic SQL
Aggregations (SUM, AVG, MIN, MAX) using SQL
Cloud Computing Basics
Data Warehousing Basics
AWS Redshift Essentials
Loading Datasets to S3 Bucket
Multiple Data Importing Techniques in Redshift
AWS Glue (Extract, Transform, Load Process)
Exporting S3 Data to AWS Redshift
Security Group Settings
Data Visualization on AWS QuickSight
Dataset Report Generation and Sharing

Who Should Attend

Beginners in Data Visualization, Data Warehousing.
Students at their initial stage of learning Amazon Web Services.
Students at their initial stage of learning AWS Redshift.
Beginners in learning AWS Glue for ETL Service

Target Audiences

Beginners in Data Visualization, Data Warehousing.
Students at their initial stage of learning Amazon Web Services.
Students at their initial stage of learning AWS Redshift.
Beginners in learning AWS Glue for ETL Service

This course is designed for the students who are at their initial stage or at the beginner level in learning data analytics, cloud computing data visualization and Analytics using the Amazon AWS Cloud Services.

This course focuses on what cloud computing is followed by some essential concepts of data analytics. It also has practical hands-on lab exercises which covers a major portion of importing and performing some Analytics on the datasets.

The ETL tool used is AWS Glueand analytics is performed using a visual tool known as QuickSight. The lab portion covers all the essentials of the two platforms starting from importing the datasets, loading it, performing powerful SQL queries and then analyzing the same data using the visual graphical tools available on QuickSight platform.

The course goes into AWS core product of data-warehousing Redshift which is a fully managed, petabyte-scale data warehouse service in the cloud. You can start with just a few hundred gigabytes of data and scale to a petabyte or more.

This course will give you the experience to leverage the data analytical strengths of AWS Cloud and strengthen your resume. This will also enable with skills to acquire new insights for your business and customers.

Please join us in this end to end course which will take you through the learning journey of AWS core products.

Course Curriculum

Chapter 1: Introduction to Cloud Computing

Lecture 1: What is Cloud

Lecture 2: What is Cloud Computing

Lecture 3: Cloud Computing Services

Lecture 4: Why Cloud Computing

Chapter 2: Introduction to Data Warehouse

Lecture 1: How Data Warehouse works

Lecture 2: Types of Data Warehouse

Lecture 3: Data Warehouse Architecture

Lecture 4: Data Warehouse Components

Lecture 5: Why use Data Warehouse

Chapter 3: Introduction to AWS RedShift

Lecture 1: Amazon Web Services

Lecture 2: What is AWS Redshift

Lecture 3: Why AWS RedShift

Chapter 4: Lab: Practical Guide to AWS Redshift

Lecture 1: Lab: Creating AWS Account

Lecture 2: Lab: AWS Web Console Overview

Lecture 3: Lab: Identity and Access Management IAM Roles

Lecture 4: Lab: Creating a AWS Cluster

Lecture 5: Lab: Creating IAM User on Redshift

Lecture 6: Lab: Getting Started with AWS RedShift QueryEditor

Lecture 7: Lab: Installing SQL Workbench Client Tool

Lecture 8: Lab: Connecting AWS RedShift with SQL Client

Lecture 9: Lab: AWS RedShift SQL Queries

Lecture 10: Lab: Loading Dataset into S3 Bucket

Lecture 11: Lab: Setting up AWS CLI

Lecture 12: Lab: Load Dataset to S3 Bucket from CLI

Lecture 13: Lab: Data Loading from S3 to AWS RedShift – Part1

Lecture 14: Lab: Data Loading from S3 to AWS RedShift – Part2

Chapter 5: ETL with AWS GLUE

Lecture 1: What is ETL

Lecture 2: Introduction to AWS GLUE

Lecture 3: ETL Process in Data Warehouse

Lecture 4: ETL Tools

Lecture 5: Lab: Fetch Table From S3 using AWS GLUE

Lecture 6: Lab: Create IAM Role and Fetch Data from S3 Bucket

Lecture 7: Lab: Security Group and VPC Setup

Lecture 8: Lab: Connecting AWS Redshift to GLUE

Lecture 9: Lab: Crawl RedShift Table MetaData to GLUE

Lecture 10: Lab: GLUE Job to Transfer Data from S3 to RedShift

Lecture 11: Lab: Data Transformation with AWS GLUE

Lecture 12: Lab: Loading datasets into RedShift using JDBC

Chapter 6: SQL Foundation for Data Analytics

Lecture 1: Introduction to SQL

Lecture 2: Basic SQL Commands

Lecture 3: Lab: SELECT Statement Part1

Lecture 4: Lab: SELECT Statement Part2

Lecture 5: Lab: SELECT Statement Part3

Lecture 6: Lab: DISTINCT Statement

Lecture 7: Lab: COUNT keyword

Lecture 8: Lab: WHERE Keyword

Lecture 9: Lab: AND Keyword

Lecture 10: Lab: OR Keyword

Lecture 11: Lab: NOT keyword

Lecture 12: Lab: UPDATE Statement

Lecture 13: Lab: DELETE Statement

Lecture 14: Lab: INSERT Statement

Lecture 15: Lab: Table SQL Joins Part1

Lecture 16: Lab: Table SQL Joins Part2

Lecture 17: Lab: SQL Functions Part1

Lecture 18: Lab: SQL Functions Part2

Lecture 19: Lab: Value Calculation and Sorting

Lecture 20: Lab: Slicing and Limiting Data

Lecture 21: Lab: Grouping and Filtering

Chapter 7: AWS QuickSight Dashboard and Visualization

Lecture 1: Introduction to AWS QuickSight

Lecture 2: Lab: Creating AWS QuickSight Account

Lecture 3: Lab: Importing Dataset

Lecture 4: Lab: Basic Data Aggregation in AWS QuickSight

Lecture 5: Lab: Donut and Pie Chart

Lecture 6: Lab: Bar Chart

Lecture 7: Lab: Line Chart

Lecture 8: Lab: Dashboard

Chapter 8: Capstone Project

Lecture 1: Capstone Project Description

Instructors

SKILL CURB
TECHNOLOGY MADE EASY

Rating Distribution

1 stars: 3 votes
2 stars: 1 votes
3 stars: 13 votes
4 stars: 20 votes
5 stars: 23 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!

Menu