Data Engineering (AWS) Course

About Course

This course is a practical, beginner-friendly AWS Data Engineering training focused on introducing core cloud concepts and key AWS services used in data engineering. It is designed to help learners build foundational skills in data storage, processing, and transformation using AWS tools and real hands-on examples.

☁️ AWS Fundamentals – Cloud basics, IAM, and core AWS concepts.
🗄️ Data Storage with S3 – Building and managing data lakes.
⚙️ Serverless Processing – Using AWS Lambda for automation.
🔄 ETL Pipelines – Data ingestion and transformation using AWS Glue.
🔍 SQL Analytics – Querying data with Amazon Athena.
📊 Data Warehousing & BI – Loading data into Redshift and visualizing with QuickSight.

Course Content

Module 1 — Cloud & AWS Fundamentals

1. Introduction to Cloud | AWS Data Engineer

00:00
2. AWS S3 Tutorial | AWS S3 (Simple Storage Service) | AWS Data Engineer

00:00
3. Amazon S3 Practical | S3 practical | AWS Data Engineer

00:00
4. AWS S3 – Storage Classes | AWS S3 Standard – Infrequent – Glacier

00:00
5. AWS IAM – Identity and Access Management | AWS Data Engineer

00:00
6. What is IAM Role in AWS | AWS IAM ROLE | AWS DATA ENGINEER

00:00
7. What is AWS Lambda | AWS Lambda Introduction | AWS Data Engineer

00:00
8 AWS Lambda practical lab-1 | AWS Data Engineer

00:00
9 AWS Lambda Trigger | AWS Lambda Practical Lab| AWS Data Engineer

00:00
Real Time AWS Data Engineer Project

00:00
11. Introduction to AWS EC2 | Aws Data engineer

00:00
12. AWS EC2 Instance Type | AWS Data Engineer

00:00
13 AWS Glue tutorial | AWS Data Engineer

00:00
14. AWS Glue Practical | AWS Glue CSV to JSON | AWS Data Engineer

00:00
15 AWS Glue Practical | AWS Glue Lab- 2 | AWS Data Engineer

00:00
16. AWS Glue Practical lab-3 | AWS Glue multiple CSV | AWS Data engineer

00:00
17 AWS Crawler | AWS Glue Crawler | AWS Data Engineer

00:00
18 What is AWS Athena | AWS Athena theory & Lab | AWS Data Engineer

00:00
19. AWS Athena Practical Lab | Athena +Glue+s3 |AWS Data Engineer

00:00
AWS Data Engineer Project | Building a Data Pipeline on AWS

00:00
21. AWS kinesis Tutorial | AWS Kinesis | AWS Data Engineer

00:00
22. AWS Kinesis Practical Lab | AWS kinesis Firehose | AWS Data Engineer

00:00
23 AWS SNS Tutorial | AWS Simple Notification service | AWS Data Engineer

00:00
24. AWS SNS Project | AWS Data Engineer

00:00

Module 2 — Spark | Apache Spark | PySpark

1. Introduction to Spark | Apache Spark | PySpark Tutorial

00:00
2. Spark Architecture | PySpark Tutorial

00:00
3. What is RDD in Spark | Spark RDD | Pyspark tutorial

00:00
4 DAG & Lazy Evaluation in Spark | PySpark Tutorial

00:00
5. Spark Installation on Windows | Install Spark and PySpark

00:00
6. Setup Databricks Community Edition | PySpark tutorial

00:00
7. Databricks Overview | pyspark playlist

00:00
8. Create dataframe using csv | pyspark lab-1 | pyspark tutorial

00:00
9. Read JSON file using pyspark | pyspark tutorial

00:00
10. Select function in pyspark | pyspark tutorial

00:00
11. withColumn in pyspark | Pyspark Tutorial

00:00
12. Filter in Pyspark | pyspark tutorial

00:00
13. drop and dropDulicates function in pyspark | pyspark tutorial

00:00
14 sort and orderBy function in pyspark | pyspark Tutorial

00:00
15 GroupBy in pyspark | pyspark tutorial

00:00
16. Joining in Pyspark | Pyspark Tutorial

00:00
17 Union and union all in pyspark | pyspark tutorial

00:00
18. fill and fillna in pyspark | pyspark tutorial

00:00
19. collect in pyspark| pyspark tutorial

00:00
20. StructType & StructField in PySpark | Pyspark Tutorial

00:00
SCD TYPE-2 using ADF | Azure data engineering project

00:00
21. pivot and unpivot in pyspark | pyspark tutorial

00:00
22. UDF in pyspark | UDF(user defined function) in PySpark

00:00
23 DataFrame.transform() function in PySpark | pyspark tutorial

00:00
24. Create Temp view in PySpark | createOrReplaceTempView() function in PySpark

00:00
25. Windows function in Pyspark | PySpark Tutorial

00:00
26. date format function in Pyspark | pyspark tutorial

00:00
27. Different date functions in Pyspark | pyspark tutorial

00:00
28 PartitionBy in pyspark | Pyspark tutorial

00:00
Databricks Pyspark Project | Pyspark Project | Databricks

00:00
Databricks project end to end | Pyspark Project

00:00
31. Explode Functions in Pyspark | Pyspark Tutorial

00:00
32. Cache and Persist in pyspark | Cache vs Persist | Pyspark Interview Question

00:00
33. Duplicate records question using pyspark | pysaprk tutorial

00:00
34. Pyspark Interview question asked in Tech Mahindra | Pyspark tutorial

00:00
35. Important Pyspark Interview Question | LTIMindTree Interview

00:00
35. Important Pyspark Interview Question | LTIMindTree Interview

00:00
36. Pyspark Scenario based interview question | Pyspark Tutorial

00:00
37. Pyspark interview question |JSON Parse | pyspark tutorial

00:00
38 Cummulative sales – PySpark Interview Question | Running Total sales

00:00
40 Scenario based pyspark interview question | pyspark interview

00:00

Module 3 — SQL

1 SQL Introduction | Install SQL Server

00:00
2. What is database | Database and types | SQL Tutorial

00:00
3. DATABASE PRACTICAL

00:00
4. INSERT Statement in SQL | SQL Tutorial

00:00
5. Constraints in SQL | SQL Tutorial

00:00
6. NOT NULL & UNIQUE CONSTRAINTS | sql tutorial

00:00
7 CHECK & DEFALT CONSTRAINTS IN SQL | SQL TUTORIAL

00:00
8. PRIMARY KEY IN SQL

00:00
9. FOREIGN KEY IN SQL | SQL TUTORIAL

00:00
10. FILTER & SORT IN SQL | SQL TUTORIAL

00:00
11. DELETE VS DROP VS TRUNCATE IN SQL | SQL TUTORIAL

00:00
12. UPDATE IN SQL | SQL TUTORIAL

00:00
13. CONDITIONAL STATEMENT IN SQL | AND , OR, IN CONDITION IN SQL

00:00
14. Aggregate Function IN SQL | sql tutorial

00:00
15. Group by IN SQL | SQL TUTORIAL

00:00
16. Like Operator IN SQL | SQL TUTORIAL

00:00
17. Having Clause IN SQL | SQL Tutorial

00:00
18. TOP OR LIMIT IN SQL | SQL Tutorial

00:00
19. Distinct IN SQL | sql tutorial

00:00
20. Coalesce IN SQL | SQL Tutorial

00:00
21.Complete SQL JOINS | SQL JOIN with Examples

00:00
22. Union vs Union all IN SQL | SQL TUTORIAL

00:00
23. ALTER IN SQL | SQL Tutorial

00:00
24. Windows function in SQL | Aggregate windows function

00:00
25. RANK, DENSE_RANK, ROW_NUMBER IN SQL |SQL Analytical Functions

00:00
26. Lead and Lag in sql | SQL Playlist

00:00
27. CTE in SQL | SQL WITH Clause | (Common Table Expression)

00:00
28. VIEWS in SQL | SQL VIEWS | SQL TUTORIAL

00:00
29. SQL Stored Procedures in SQL | CREATE PROCEDURE Statement | SQL

00:00
30. Subquery in SQL || SQL Subquery tutorial with examples

00:00
31. Triggers in SQL | Sql Triggers🔫 Real Life Example

00:00

Module 4 — Interview Questions

Data Engineer Interview Questions & Answers | SQL Question -1

00:00
2. SQL Interview question and answer | Data Engineer

00:00
3 . Data engineer interview question | SQL Interview question

00:00
4. SQL Interview important question | Data Engineer Interview

00:00
5. SQL Most Asked Interview question and answer | data engineer

00:00
6. Python Interview Questions and Answers | data engineer

00:00
7. Python Coding Questions for Data Engineer Interviews | Data Engineer

00:00
8. Python interview question -3 | Data Engineer

00:00
9 python interview question -4 | Data Engineer Interview

00:00
10, Python interview question | Data Engineer | Python Dictionary

00:00
11. SQL Important Interview Question and answer | Data engineer

00:00
12. Python interview question & answer | Data Engineer

00:00
13. PySpark interview question and answer | data engineer

00:00
14. SQL interview question | Fill null values with previous value | data engineer

00:00
15 SQL interview question- 8 | Data Engineer Interview

00:00
16. PySpark interview questions | Null values Problem | Data Engineer

00:00
17. Consecutive days PySpark interview question | Data Engineer interview

00:00
18. PySpark interview question | Find Employee salary greater than manager Salary | Data Engineer

00:00
19. pyspark interview questions and answer – customer analysis

00:00

Module 5 — Python

1. Introduction to python playlist | Python Playlist

00:00
2. What is Python? | Features and Benefits Explained for Beginners 🚀

00:00
3. Python data type and variables | python playlist

00:00
4. Python input function and type casting

00:00
5. Python Operators | python playlist

00:00
6. Python If-Else Statements: Beginner to Advanced Examples

00:00
7. Python For Loops: Complete Guide with Examples

00:00
8. Python While Loops: Beginner to Advanced Examples

00:00
9. Python List Introduction | python playlist

00:00
10. List Methods in Python | Python Tutorial

00:00
12. Swap Two Elements in a List | Python coding exercise – 2

00:00
13. How to reverse a list | python coding – 3

00:00
14. sum and average of given list | python coding – 4

00:00
15.Find Even and odd number of List | python playlist

00:00
16. Remove Duplicates from a List in Python

00:00
17. Python List Comprehension | python playlist

00:00
18.Tuples in Python Explained: Best Practices & Examples | python playlist

00:00
19. Sets in Python | Python Sets Explained: | python playlist

00:00
20.Python Dictionary Tutorial: Best Practices & Examples | python playlist

00:00
21.Python Strings: Best Practices, Methods & Examples | python playlist

00:00
22. Python String Coding Questions & Solutions | python playlist

00:00
23. Python Functions Explained: Basics to Advanced with Examples | python playlist

00:00
24. *args and **kwargs In Python | Python Tutorials

00:00
25. Lambda in python | Python playlist

00:00
26.Map, Filter and Reduce in Python | python playlist

00:00

Student Ratings & Reviews

4.0

Total 2 Ratings

1 Rating

0 Rating

1 Rating

0 Rating

7 years ago

This is a really great course for all levels in financial analysis. Wither you're beginner or expert, you'll find new things to learn here. Starting from Excel to Accounting to financial statements analysis and concluding with PowerPoint to present your work. Above all that, I'm really getting real world experience and not just text book materials.

7 years ago

This course is highly recommended. I was able to improve my excel skills, financial analysis and accounting reporting skills after reviewing a few times and practising some of the tasks and examples provided.

About Course

What Will You Learn?

Course Content

Module 1 — Cloud & AWS Fundamentals

1. Introduction to Cloud | AWS Data Engineer

2. AWS S3 Tutorial | AWS S3 (Simple Storage Service) | AWS Data Engineer

3. Amazon S3 Practical | S3 practical | AWS Data Engineer

4. AWS S3 – Storage Classes | AWS S3 Standard – Infrequent – Glacier

5. AWS IAM – Identity and Access Management | AWS Data Engineer

6. What is IAM Role in AWS | AWS IAM ROLE | AWS DATA ENGINEER

7. What is AWS Lambda | AWS Lambda Introduction | AWS Data Engineer

8 AWS Lambda practical lab-1 | AWS Data Engineer

9 AWS Lambda Trigger | AWS Lambda Practical Lab| AWS Data Engineer

Real Time AWS Data Engineer Project

11. Introduction to AWS EC2 | Aws Data engineer

12. AWS EC2 Instance Type | AWS Data Engineer

13 AWS Glue tutorial | AWS Data Engineer

14. AWS Glue Practical | AWS Glue CSV to JSON | AWS Data Engineer

15 AWS Glue Practical | AWS Glue Lab- 2 | AWS Data Engineer

16. AWS Glue Practical lab-3 | AWS Glue multiple CSV | AWS Data engineer

17 AWS Crawler | AWS Glue Crawler | AWS Data Engineer

18 What is AWS Athena | AWS Athena theory & Lab | AWS Data Engineer

19. AWS Athena Practical Lab | Athena +Glue+s3 |AWS Data Engineer

AWS Data Engineer Project | Building a Data Pipeline on AWS

21. AWS kinesis Tutorial | AWS Kinesis | AWS Data Engineer

22. AWS Kinesis Practical Lab | AWS kinesis Firehose | AWS Data Engineer

23 AWS SNS Tutorial | AWS Simple Notification service | AWS Data Engineer

24. AWS SNS Project | AWS Data Engineer

Module 2 — Spark | Apache Spark | PySpark

1. Introduction to Spark | Apache Spark | PySpark Tutorial

2. Spark Architecture | PySpark Tutorial

3. What is RDD in Spark | Spark RDD | Pyspark tutorial

4 DAG & Lazy Evaluation in Spark | PySpark Tutorial

5. Spark Installation on Windows | Install Spark and PySpark

6. Setup Databricks Community Edition | PySpark tutorial

7. Databricks Overview | pyspark playlist

8. Create dataframe using csv | pyspark lab-1 | pyspark tutorial

9. Read JSON file using pyspark | pyspark tutorial

10. Select function in pyspark | pyspark tutorial

11. withColumn in pyspark | Pyspark Tutorial

12. Filter in Pyspark | pyspark tutorial

13. drop and dropDulicates function in pyspark | pyspark tutorial

14 sort and orderBy function in pyspark | pyspark Tutorial

15 GroupBy in pyspark | pyspark tutorial

16. Joining in Pyspark | Pyspark Tutorial

17 Union and union all in pyspark | pyspark tutorial

18. fill and fillna in pyspark | pyspark tutorial

19. collect in pyspark| pyspark tutorial

20. StructType & StructField in PySpark | Pyspark Tutorial

SCD TYPE-2 using ADF | Azure data engineering project

21. pivot and unpivot in pyspark | pyspark tutorial

22. UDF in pyspark | UDF(user defined function) in PySpark

23 DataFrame.transform() function in PySpark | pyspark tutorial

24. Create Temp view in PySpark | createOrReplaceTempView() function in PySpark

25. Windows function in Pyspark | PySpark Tutorial

26. date format function in Pyspark | pyspark tutorial

27. Different date functions in Pyspark | pyspark tutorial

28 PartitionBy in pyspark | Pyspark tutorial

Databricks Pyspark Project | Pyspark Project | Databricks

Databricks project end to end | Pyspark Project

31. Explode Functions in Pyspark | Pyspark Tutorial

32. Cache and Persist in pyspark | Cache vs Persist | Pyspark Interview Question

33. Duplicate records question using pyspark | pysaprk tutorial

34. Pyspark Interview question asked in Tech Mahindra | Pyspark tutorial

35. Important Pyspark Interview Question | LTIMindTree Interview

35. Important Pyspark Interview Question | LTIMindTree Interview

36. Pyspark Scenario based interview question | Pyspark Tutorial

37. Pyspark interview question |JSON Parse | pyspark tutorial

38 Cummulative sales – PySpark Interview Question | Running Total sales

40 Scenario based pyspark interview question | pyspark interview

Module 3 — SQL

1 SQL Introduction | Install SQL Server

2. What is database | Database and types | SQL Tutorial

3. DATABASE PRACTICAL

4. INSERT Statement in SQL | SQL Tutorial

5. Constraints in SQL | SQL Tutorial

6. NOT NULL & UNIQUE CONSTRAINTS | sql tutorial

7 CHECK & DEFALT CONSTRAINTS IN SQL | SQL TUTORIAL

8. PRIMARY KEY IN SQL