AWS DATA ENGINEER COURSE CONTENT
Python
- Python introduction
- Python installation
- Python syntax
- Basic Python operators
- Variable & Identifier
- Data types
- If-else statements
- For loops
- While loop
- Break/continue/pass
- Read/write files
- Function
- Class and object
- Exception handling
- Mathematics
SQL
- SQL Query type (CRUD)
- Comparison Operators
- Joins
- Clauses
- SQL Functions
- Conditions
- Tables, Keys, Constraints
Fundamentals of Database
- Data Warehouse Fundamentals
- Normalization
- ETL / ELT
- Big Data (Hadoop, Hive, Pig)
- Dimensional Modeling
- Data Migration
- Data Quality & Validation
- Profiling & Creation
- Security
- Business Intelligence
Linux
- Linux Introduction
- File System
- Basic Commands
- Text Editors
- Users and Groups
- Process Management
- Network Configuration
- Bash Scripting
- Package Management
- Permissions & Security
- sed, awk, grep
- System Monitoring
AWS
- Data Engineering fundamentals
- AWS overview & CLI
- S3 Basics & Operations
- EC2: Types, Launching & Config
- RDS: Setup & Management
- DynamoDB Fundamentals
- DynamoDB Operations
- Redshift & Cluster Management
- AWS Glue: Fundamentals & Crawlers
- EMR: Architecture, Clusters
- Data Pipeline Creation
- Athena: Querying S3
- Integration with Glue Catalog
