Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA CompTIA Security+ Amazon AWS AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Development Database Design & Development Amazon QuickSight

Mastering AWS Glue, QuickSight, Athena & Redshift Spectrum

Master serverless analytics with AWS Glue, QuickSight, Athena, & Redshift Spectrum (includes preview features with labs)
Rating: 4.1 out of 54.1 (1,487 ratings)
8,877 students
Created by Siddharth Mehta
Last updated 7/2020
English
30-Day Money-Back Guarantee

What you'll learn

  • Confidently work with AWS Serverless services to develop Data Catalogue, ETL, Analytics and Reporting on a Data Lake
  • Develop deep knowledge in Glue, Athena, Redshift Spectrum and QuickSight
  • Build a serverless data lake on AWS using structured and unstructured data
  • Architect Serverless Analytics solutions on AWS cloud platform
Curated for the Udemy for Business collection

Course content

23 sections • 193 lectures • 18h 25m total length

  • Preview05:23
  • Pre-requisites - What you'll need for this course
    04:20
  • Course Objectives
    01:46
  • Course Content, Convention and Resources
    02:59

  • Preview01:45
  • What is Serverless Computing ?
    09:54
  • Basics of AWS Serverless Data Lake Architecture
    19:54

  • Preview01:21
  • Lab: Sample Data Setup on Amazon S3
    03:26
  • Lab: Amazon S3 - Analytics Configuration
    03:29

  • Preview01:48
  • Amazon Redshift - Introduction and Pre-requisites
    05:11
  • Amazon Redshift - Developing a Redshift Cluster
    15:00
  • Amazon Redshift - Installing Client Tools
    13:24
  • Amazon Redshift - Installing Sample Data
    13:44

  • Preview01:40
  • AWS Glue - Architecture
    14:10
  • AWS Glue - Terminology
    10:50
  • AWS Glue - Applications
    07:42
  • AWS Glue - Internals
    12:34
  • AWS Glue - Cost
    04:22
  • Lab: AWS Glue - Security and Privileges Setup
    10:34
  • AWS Glue - Advance Network Configuration
    09:33
  • Lab: AWS Glue - Advance Network Configuration
    05:24

  • Preview01:13
  • AWS Glue - Data Catalog
    04:46
  • Lab: AWS Glue - Databases
    07:36
  • AWS Glue - Tables
    06:04
  • AWS Glue - Designing Tables
    11:15

  • Preview01:44
  • AWS Glue - Introduction to Crawlers
    09:26
  • Lab - Introduction to AWS Glue Classifiers
    04:17
  • Lab 1 - AWS Glue - Developing Data Catalog with Crawlers
    18:00
  • Lab 2 - AWS Glue - Developing Data Catalog with Crawlers
    02:52
  • Lab 3 - AWS Glue - Developing Data Catalog with Crawlers
    10:41
  • Lab 4 - AWS Glue - Developing Data Catalog with Crawlers
    07:36
  • Lab 5 - AWS Glue - Developing Data Catalog with Crawlers
    08:09
  • Lab 6 - AWS Glue - Developing Data Catalog with Crawlers
    05:22
  • Lab 7 - AWS Glue - Developing Data Catalog with Crawlers
    07:35

  • Preview01:05
  • Introduction to AWS Glue Jobs
    06:22
  • Lab 1 - Developing AWS Glue Jobs
    18:40
  • AWS Glue Job Properties
    05:25
  • Lab 2 - Developing AWS Glue Jobs
    02:26
  • Lab 3 - Assignment : Importing Data from Redshift
    04:03
  • Lab 4 - Developing AWS Glue Jobs
    05:45
  • AWS Glue Job Scripts and Properties
    04:54
  • Lab 5 - Developing AWS Glue Jobs
    13:33
  • AWS Glue - Built-in ETL Transformations and Job Bookmarks
    13:23

  • Preview01:08
  • Introduction to AWS Glue Triggers
    04:58
  • Lab 1 - Developing AWS Glue Triggers
    07:25
  • Lab 2 - Developing AWS Glue Triggers
    05:21

  • Preview01:21
  • Lab: Creating a AWS Glue Development Endpoint
    07:32
  • Lab: Installing and configuring Apache Zeppelin
    06:58
  • Lab: Port Forwarding Configuration
    06:13
  • Lab: Integrating AWS Glue Development Endpoint with Apache Zeppelin
    05:22
  • AWS Glue Monitoring
    04:11

Requirements

  • Basic knowledge of database and data warehouse concepts
  • Working knowledge of AWS Concepts and Tools like AWS Console, S3, VPC, Security Group, AZ, IAM, Role, Policy etc
  • Basic working knowledge of any SQL style query language
  • Working knowledge of Redshift would be an advantage, but is not mandatory. Course covers Redshift cluster development
  • Course includes demo of all the labs. An AWS Account would be required to try labs hands-on.

Description

PS:

  1. Please do NOT join the course if you do NOT have any basic working knowledge of AWS Console and AWS Services like S3, IAM, VPC, Security Groups etc. AWS Beginners may struggle understanding some of the topics.

  2. Course explains all the labs. If you want to practice labs, it would require AWS Account and may cost $$.

  3. Basic working knowledge of Redshift is recommended, but not a must.

  4. This course has been designed for intermediate and expert AWS Developers / Architects / Administrators.

  5. Course covers each and every feature that AWS has released since 2018 for AWS Glue, AWS QuickSight, AWS Athena, and Amazon Redshift Spectrum, and it regularly updated with every new feature released for these services.

Serverless is the future of cloud computing and AWS is continuously launching new services on Serverless paradigm. AWS launched Athena and QuickSight in Nov 2016, Redshift Spectrum in Apr 2017, and Glue in Aug 2017. Data and Analytics on AWS platform is evolving and gradually transforming to serverless mode.


Businesses have always wanted to manage less infrastructure and more solutions. Big data challenges are continuously challenging the infrastructure boundaries. Having Serverless Storage, Serverless ETL, Serverless Analytics, and Serverless Reporting, all on one cloud platform had sounded too good to be true for a very long time. But now its a reality on AWS platform. AWS is the only cloud provider that has all the native serverless components for a true Serverless Data Lake Analytics solution.


It's not a secret that when a technology is new in the industry, professionals with expertise in new technologies command great salaries. Serverless is the future, Serverless is the industry demand, and Serverless is new. It's the perfect time and opportunity to jump into Serverless Analytics on AWS Platform.


In this course, we would learn the following:

1) We will start with Basics on Serverless Computing and Basics of Data Lake Architecture on AWS.

2) We will learn Schema Discovery, ETL, Scheduling, and Tools integration using Serverless AWS Glue Engine built on Spark environment.

3) We will learn to develop a centralized Data Catalogue too using Serverless AWS Glue Engine.

4) We will learn to query data lake using Serverless Athena Engine build on the top of Presto and Hive.

5) We will learn to bridge the data warehouse and data lake using Serverless Amazon Redshift Spectrum Engine built on the top of Amazon Redshift platform.

6) We will learn to develop reports and dashboards, with a powerpoint like slideshow feature, and mobile support, without building any report server, by using Serverless Amazon QuickSight Reporting Engines.

7) We will finally learn how to source data from data warehouse, data lake, join data, apply row security, drill-down, drill-through and other data functions using the Serverless Amazon QuickSight Reporting Engines.


This course understands your time is important, and so the course is designed to be laser-sharp on lecture timings, where all the trivial details are kept at a minimum and focus is kept on core content for experienced AWS Developers / Architects / Administrators. By the end of this course, you can feel assured and confident that you are future-proof for the next change and disruption sweeping the cloud industry.

I am very passionate about AWS Serverless computing on Data and Analytics platform, and am covering A-to-Z of all the topics discussed in this course.

So if you are excited and ready to get trained on AWS Serverless Analytics platform, I am ready to welcome you in my class !

Who this course is for:

  • Anyone who wants to learn AWS Serverless technologies for data and analytics should take this course
  • Data Professionals seeking to learn Serverless Storage, Serverless ETL, Serverless Data Analysis and Serverless Reporting should take this course

Instructor

Siddharth Mehta
Enterprise Cloud Architect, Published Author, Cloud Geek
Siddharth Mehta
  • 4.2 Instructor Rating
  • 5,398 Reviews
  • 45,682 Students
  • 11 Courses

Udemy's Top 10% of most engaging instructors

My name is Siddharth Mehta. I have career experience of more than 15 years in the IT Industry and am presently working as Enterprise Cloud Architect. I am published author on many online and print-media publications. I have taught thousands of students on Udemy and have number of courses on Data and Analytics. 

Would you consider learning from just any hobbyist who knows programming or someone who just teaches programming without practically using it in the real world, or someone who has experience of using the technology in real world on multi-million dollar large-scale projects globally ? I will teach you everything I know about the subject, from my years of practical experience in the field of BI, Data, Analytics, Cloud and Data Science.

If you are interested in learning more about me, below are some of my career highlights:

I have career experience of more than 15+ years and am presently working in New York Metro region as Enterprise Architect for a life-sciences proprietary multi-tenant product technology portfolio, managing an ecosystem of ISVs and tenants. Below are some of my career highlights:


-|- International experience of working across geographies (US, UK, Singapore) for multi-national clients in Banking, Logistics, Government, Media Entertainment, Products, Life Sciences and other domains

-|- Lead architecture of multi-million dollar portfolios containing apps in Cloud, web, mobile, BI, Analytics, Data warehousing, Reporting, Collaboration, CMS, NoSQL and other categories.

-|- Official inventor of a patented application

-|- Published author/reviewer of whitepapers for Microsoft MSDN Library, Manning publication, Packt publication and others.

-|- Certifications: AWS Certified Solution Architect, TOGAF 9, CITA-F, HCAHD and more


In my present role, I remain responsible for Estimations like AO, IO, SI, IC & Security, Architecture Design, Technology Stack selection, Infra design, 3rd party products evaluation and procurement, and Performance engineering. Hands-On Technology experience of below tech:


-|- OS: Win, Linux

-|- Cloud: GCP, Azure, AWS

-|- Databases: Neo4j, AWS Neptune, Redis, Memcached, MongoDB, Cassandra, HBase, SQL Server, MariaDB, Postgres, Aurora, MySQL, SSAS, AWS Redshift, Google BigQuery, Azure Data Lake, AWS RDS, DynamoDB, Athena, AWS Elasticache

-|- Big Data: Google DataProc, AWS EMR, Kafka, Spark, Hive, Oozie

-|- Search: AWS Elasticsearch

-|- Web: Node.JS, Angular, jQuery, REST APIs, React

-|- ESB/ETL: AWS Lambda, Step Functions, AWS Kinesis, AWS Glue, Mulesoft, SSIS, AWS Data pipeline

-|- Data Science: R , Python, GGPlot 2, Numpy, Seaborn, Pandas, Skikit-learn, Spark ML, Data Mining, Regression & Classification algorithms

-|- Reports / Dashboards : Tableau, Qlikview, SSRS, AWS Quicksight, D3

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.