3 months Road map of Data Engineer with FREE resources:
Basic to advance SQL
Basic understanding of Python
Knowledge of Cloud Technologies
Understanding of ETL services and tools
Basic to advance SQL
Let’s Start with basic SQL. I have already written one blog on SQL masterclass. You can refer to it before jumping on Python.
follow the link for Master SQL in 4 weeks: https://medium.com/@akshayridlan8/master-sql-in-4-weeks-2ed52c671173
SQL FREE RESOURCES:
SQL on JavaTPoint: https://www.javatpoint.com/sql-tutorial
TrendyTech insights : https://youtu.be/bnMvWZ1PZKA
Ankit Bansal YouTube Channel: https://youtu.be/e1SVjR-xoto
Basic understanding of Python
Python is must for Data Analytics and have robust Library for creating insights from the available data.
Following are the free resources for learning Python for FREE
Krish Naik youtube Channel: https://youtu.be/bPrmA1SEN2k
Learn ETL
What is ETL and how it works:
ETL, which stands for extract, transform and load, is a data integration process that combines data from multiple data sources into a single, consistent data store that is loaded into a data warehouse or other target system.
ETL is the backbone of whole Data engineering where you will extract, transform and load the data. Building the Data Pipelines.
ETL process in Microsoft Azure Platform:
Similarly, we can perform ETL processes on different cloud platforms and other tools as well.
Free ETL resources:
https://www.guru99.com/etl-extract-load-process.html
Knowledge of Cloud Technologies
Nowadays, everything is on cloud so Data Engineer must have knowledge of at least one cloud platform like AWS, Microsoft Azure or GCP.
Free resources for learning AWS Cloud:
https://youtu.be/ckQ7d6ca2J0
Data Visualisation
And If you have knowledge of Business Intelligence tools such as Power BI or Tableau that come as cherry on cake.
These are the data Visualisation tools for representing the data in the dashboard format to the right audience so that they can take appropriate decisions on the basis of reports and data!
Free resources for POWER BI and Tableau:
Power BI YouTube channel: https://youtu.be/H84UJn1CiWo
Cheers!!!
All the very best for Future Data Engineers!!
Note: This Blog is written on the basis of personal experience. Its always depends on the learner how much grasping power one has. And I always suggest to go slow and do hands on!
