
Explore AWS storage options like S3 and Glacier with lifecycle management and real-time ingestion via firehose to S3, Redshift, Elasticsearch, and Splunk, including on-premises migration via Storage Gateway and Snowball.
Compare popular data formats for a data lake; understand row vs column storage, Parquet efficiency, and when to convert data to optimize storage and query performance.
Collect data in its native format and transform in the data lake for analytics. Leverage EMR, Spark, Hive, Glue ETL, and Kinesis Firehose for Parquet or ORC, enabling downstream use.
Explore Amazon S3 storage classes by creating a bucket, uploading files, and using standard, infrequent access, intelligent tiering, deep archive, and glacier retrieval options to compare costs and retrieval times.
Enable S3 versioning to track and manage multiple object versions, read a specific version, delete and undelete objects, and understand storage costs for all versions.
Set up cross-region S3 replication for disaster recovery by enabling versioning on source and destination, creating buckets in different regions, and configuring a replication rule with an IAM role.
From midnight on October 19 to October 20, 2025, AWS’s us-east-1 region faced one of its longest disruptions — lasting over 15 hours and impacting key services like DynamoDB, EC2, Glue and IAM. The incident also triggered cascading failures across other regions that rely on us-east-1–hosted global services.
In this video, we unpack what went wrong, how AWS managed the crisis, and the disaster recovery (DR) strategies every architect should apply to protect workloads from region-level and cross-region dependencies.
Explore analyzing a university rankings dataset from Kaggle in a data lake using Athena, performing ELT and ETL with Spark, and visualizing insights with Amazon QuickSight.
Set up a Glue crawler for ranking data and query it with Athena. Use QuickSight for dashboards and address data quality, switching from lazy serde to open csv serde.
Leverage Amazon QuickSight to visualize university rankings by year and region, using Spice data import, pivot tables, and calculated fields to reveal top ranks, distinct counts, and dashboards.
Learn how to manage schema changes in a data lake using the glue catalog with csv format, focusing on Athena’s index-based access and risks from shuffled or missing columns.
Learn how Athena reads Parquet by name, supports index-based access, and handles shuffled, missing, or new columns without query changes, noting that renaming columns or data type changes require testing.
Learn how csv schema changes impact athena queries and how to preserve column order, add new columns at the end, and keep the glue catalog in sync with crawlers.
Partition data in S3 and create partitioned tables to query specific partitions, using iris setosa, versicolor, and virginica files to demonstrate partitioning, catalog updates, and performance gains.
Organize iris data using hive compatible partitions and a self documenting folder structure by type. Create a hive partition crawler, run MSCK and add partitions, and update the Athena catalog.
Learn how AWS's latest security feature strengthens Data Perimeter Security to protect your data from unauthorized access and exfiltration. In this video, I’ll walk you through key strategies to safeguard sensitive data across multiple AWS accounts. Discover how to prevent data leaks caused by misconfigurations, insider threats, and malicious actors.
AWS: Understand the Confused Deputy Problem and 3 Solution Patterns
https://youtu.be/viVoZBc-33s?si=n_415NmIiC2PkGYf
Explore Amazon Comprehend in a live lab to perform sentiment analysis, custom classification, and medical text extraction, while analyzing syntax, key phrases, and language detection.
Explore the six key advantages of cloud computing with AWS, including consumption-based pricing, scalability, speed, global reach, and cost-management tools.
Explore AWS global infrastructure, including public, gov, and China clouds, and see how regions and availability zones, linked by the AWS backbone, ensure data locality and low latency.
Hello, my name is Chandra Lingam, and I will be your instructor for the Data Lake in AWS course.
In this course, we will begin by gaining an understanding of the fundamental concepts of a data lake and when it is the appropriate solution as opposed to a data warehouse
We will then delve into the various components that make up a data lake solution, including the ability to query files directly using SQL for rapid ad hoc analysis of datasets
During the course, we will cover the topic of handling changes to the structure of the files in the data lake. We will delve into the various scenarios, such as new fields, new partitions, changes in data types, and missing data, and discuss the techniques on how to handle them effectively. We will also delve into Glue Catalog Management and the evolution of schemas, with a focus on minimizing disruption to downstream systems
We will also look into different data formats, such as CSV, Parquet, Avro, and ORC, and examine their respective strengths and weaknesses. Following that, we will delve into Glue ETL, a robust Apache Spark-based solution for data transformation.
This course is filled with hands-on exercises and projects.
You will analyze a University Rankings dataset, which is easy to understand, useful, and has a mix of data types with many data quality issues.
You will learn to utilize Athena for querying data, tackle data quality problems through SQL, and cleanse the data using Glue - Apache Spark ETL.
Additionally, the course covers techniques for simplifying queries using views and visualizing data using Amazon QuickSight.
To showcase the scalability of Athena, we will query the large Amazon Customer Reviews dataset containing over 130 million reviews. Finally, we will construct a serverless application using Kinesis Firehose, Lambda, Comprehend AI, Glue, Athena, and S3, which can process an unlimited number of customer reviews, perform sentiment analysis, and store the results in the data lake for querying.
I am excited to meet you soon!
Thank you!
Chandra Lingam
Compute With Cloud Inc