Data Engineering Volume 1 (AWS) - OLAP & Data Warehouse

  • Data Engineering Volume 1 (AWS)

Learners Enrolled : 10

Created by Soumyadeep Dey

  • English

About the course

This is Volume 1 of Data Engineering course on AWS. In this course I will talk about the Data Warehouse and OLAP (Online Analytical Processing) technologies on AWS. It will give you detailed explanations on AWS Data Engineering Services like S3 (Simple Storage Service), Redshift, Athena, Hive, Glue Data Catalog, Lake Formation. This course delves into the data warehouse or consumption and storage layer of Data Engineering pipeline. At the end of the course, you will get to do 10 different projects that match real life scenarios with approx. 200 GB of data.

In Volume 2, I will showcase Data Processing (Batch and Streaming) Services. 

 

You will get opportunities to do hands-on using large datasets (100 GB - 200 GB or more of data). Moreover, this course will provide you hands-on exercises that match with real-time scenarios like Redshift query performance tuning, streaming ingestion, Window functions, ACID transactions, COPY command, Distributed & Sort key, WLM, Row level and column level security, Athena partitioning, Athena WLM etc.  

Some other highlights:

  • Contains training of data modelling - Normalization & ER Diagram for OLTP systems. Dimensional modellingfor OLAP/DWH systems
  • Data modelling hands-on.
  • Other technologies covered - EC2, EBS, VPC and IAM.
  • Multiple hands-on projects with total data size of 500 GB.
  • Live sessions 2 days a week (total 4 hours) to clear doubts, exercises, concepts etc. 

 

Course Curriculum

What do we offer

Live learning

Live sessions (6-8 hrs) every week. Link of the sessions will be shared once you enrol. Recording for the live sessions will be made available to all learners.

Structured learning

Our curriculum is designed to take you from Beginner level to Expert level using production size datasets and production like scenarios for all courses.

Community & Networking

Interact and network with like-minded folks from various backgrounds in Live Sessions.

Learn with the best

Stuck on something? Discuss it with your peers and the instructors in the inbuilt chat groups.

Production Like Projects

Each course contains minimum of 8 to 10 projects with min of 150 - 200 GB of datasets. It is highly recommended to complete all the projects to get understanding of real life scenarios.

Get certified

Flaunt your skills with course certificates. You can showcase the certificates on LinkedIn with a click.

Reviews

Enroll Now