Courses
AWS Data Engineer
AWS Data Engineer
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)
- SQL Comparision Operators
- SQL Joins
- SQL clause
- SQL Functions
- SQL Condition
- SQL Tables
- SQL Key, Constraints
Fundamentals of DataBase
- Fundamentals of Data warehouse
- Normalization
- ETL
- ELT
- Bigdata (Hadoop, Hive, Pig)
- Dimensioning Modelling
- DWH Architecture
- Data Migration
- Data Quality
- Data Validations
- Data Profiling
- Data Creation
- Data Security
- Business Intelligence
Linux
- Introduction of Linux
- Linux File System
- Basic Linux Commands
- Text Editors
- Managing Users and Groups
- Process Management
- Network Configuration
- Bash Scripting
- Package Management
- Security and Permissions
- sed, awk, grep, and regular expressions.
- System Monitoring and Logging
- Advance: sed, awk, grep, and regular expressions.
AWS
- Data Engineering fundamentals
- Overview of AWS services
- AWS Management Console and AWS CLI
- S3 basics and concepts
- S3 operations (PUT, GET, DELETE, etc.)
- EC2 instance types
- Launching, configuring, and managing instances
- RDS fundamentals
- Creating, configuring, and managing RDS instances
- DynamoDB fundamentals
- DynamoDB read and write operations
- Redshift fundamentals
- Redshift cluster management
- Glue fundamentals
- Glue Data Catalog
- Creating and managing Glue Crawlers
- EMR fundamentals and architecture
- Creating and managing EMR clusters
- Data Pipeline fundamentals
- Creating and managing Data Pipelines
- Athena fundamentals
- Querying data in Amazon S3 using Athena
- Integrating Athena with AWS Glue Data Catalog