Data Engineer Complete Roadmap For Beginners and Experienced Professionals (2024) | ft. @azureli
Vložit
- čas přidán 23. 07. 2024
- In this video i will be talking to Deepak Goyal and discuss about what it takes to become a data engineer. What are prerequisite and advanced technologies that they need to learn.
We will also talk about how working professional from other data background can move to data engineering. Please like and share this video as much as possible.
Zero to hero(Advance) SQL Aggregation:
• All About SQL Aggregat...
Most Asked Join Based Interview Question:
• Most Asked SQL JOIN ba...
Solving 4 Trick SQL problems:
• Solving 4 Tricky SQL P...
Data Analyst Spotify Case Study:
• Data Analyst Spotify C...
Top 10 SQL interview Questions:
• Top 10 SQL interview Q...
Interview Question based on FULL OUTER JOIN:
• SQL Interview Question...
Playlist to master SQL :
• Complex SQL Questions ...
Rank, Dense_Rank and Row_Number:
• RANK, DENSE_RANK, ROW_...
#sql #dataengineer
Road map: SQL, python, azure, adf, pyspark, Databricks. Entire 27 minutes summary. Even after 6 months roadmap will be same.
Great one! Thanks.
Thanks Ammitji for the roadmap.the best on internet.
Great content Ankit 👍
Great session sir
Need of the hour, Thank you so much Ankit for this wonderful session to data community 😊
Always welcome 🤗
Well explained..
Very cool! Thanks both😊
Glad you enjoyed it!
Hit the like button on the video if you want me to create more podcast with data expert in the field.
Follow Deepak Goyal here : www.linkedin.com/in/deepak-goyal-93805a17
My next live SQL zero to hero bootcamp for data analytics starting October 7th. Register your spot here for a magical experience:
www.namastesql.com/courses/Think-SQL-Go-from-Zero-to-Hero-October-64f59039e4b00ea856fa045d
Thank you so much both for your actionable insights. Really appreciated this conversation.
Glad you enjoyed it!
Glad to see both Guru together... You both are helping the data community in so many ways
Thank you Deepak and Ankit for valuable guidence on roadmap
Absolutely..
Very nice podcast. Thank you Ankit
Thanks for listening🙏
One of the best podcast regarding this topic.
One thing that you need to be covered in your next podcast, like if someone has 7+ yrs of experience in IT or programming background but not related to data focused role.
What they will do for transition into a data engineer role from a non-data role (but they know programming stuff)
Sure
That Deepak said we have to showcase something like whatever the project you have done convert it into Data Engineering style 😊
When deepak said hadoop is obsolete, he tries to to mention Mapreduce is obsolete, hdfs and yarn are still on the market.
Great initiative Ankit bro 👍
✌
Hi which course will you recomend to learn ? I'm an ETL Tester..have knowledge on SQL
Thank you 👍
You are welcome
I just recommend your yt playlist and Deepak’s course . Awesome information
Thanks for sharing🙂
Hey I am working as an ux designer i want to move to Data engineering i know python and sql well, can i get succeed in this field? i have this fear companies dont hire from design field :(
I have never seen a person like Deepak. He is very polite, humble, down to earth. We have very less people in this world like him. Thanks for being the motivation for the people and creating such a wonderful content both of you.
Agree with you 🙂
I do agree, he is such a good person
Thank you Ankit :)
My pleasure 😊
Hi Ankit
I am working as consultant and want to move towards data engineering my current job is not from data domain so please make a video for transition towards data engineering
Hi Ankit
I am continously failing in interviews.I can solve SQL problem but in the intervies there is no hit and trial.We have to write correct query in one go. How to do it? please guide me.
Repetition bro. Just solve as much problems as you can.
Hi Ankit\Deepak,
Being 11 years of oracle plsql developer , to crack data engineer interview not with respect to technology perspective because that's a long term approach in short terms what topics are most important so that other can be settled by SQL even if we dont have experience in data engineer.
SQL ,Python and a bit of cloud understanding
@@ankitbansal6 will unix shell scripting works in place of python because both are scripting language
If I'm from different domain and want to switch to Data Engineering how I should make my resume and proceed. Please help I'm very disappointed of non getting shortlisted each and every time.
which domain are you from?
my current job is not from data domain so please make a video for transition towards data engineering
Bro... I had commerce in 12th , and I am little bit confused about data analyst and data engineer , bcz I am not from maths and stats background 😢 so could you please tell me how much maths is really required in this field? Help me bro 😢
Not much, very basic. For data analysts just SQL , excel and bi tool will do.
@@ankitbansal6 for data engineer?
Ankit and Deepak , both are very honest guys
Ankit Bhai Zindabad
Thank you sir,it was great, Sir pls clarify my doubt on rolling sum. IF WE WANT TO CALCULATE SUM OF 1 ROW BEFORE AND 1 ROW AFTER THE CURRENT ROW,SKIPPING THE CURRENT ROW, WHICH FUNCTION I HAVE TO USE SIR?
Question is like this sir,"Show the username of each user along with the number of photos they have posted and the number of photos posted by the user before them and after them, based on the creation date." please help sir
🙏
Use lead and lag and add
@@ankitbansal6 yes sir, i used the same ( lead() + lag() ) for this the answer is returning 2 for every row, which is wrong sir. So i am confused to use which function
Getting your first DE job is hard but once you have it, the next thing is to do well and grow in it.
How to do it?
Is it possible to skip python and pyspark to become data engineer? Currently working as ETL Informatica developer and not much into coding before.
I would suggest learning basic python. It's very easy to learn and start applying.
Belive me I learnt python in 2weeks
@@krishnakumarkumar5710 can you share some resources?
Good Podcast, but sir it's still 2023, just checked the calander to confirm 😄😄
I know. It's a future proof roadmap.
Thank you so much sir
Most welcome
what about Linux is it important to learn it ?
Yes basics you should know
Sir.... I am very interested but Data Engineering is gng to die in 5 years right??....many people are saying this..... please throw some light in this context sir😢
It's not going anywhere . You can go for it 😊
I have 11.5 years of experience I want to learn data engineering, please advice
Start with SQL and python. After that pick one cloud.
Sql server or my sql
Which one best
Stopped watching when u say azu-Reee to Azure
From where we can learn spark in a better way?
Learning SQL is not that easy, I have been using sql for last four years and I still feel like I know nothing. T-SQL DBA is vast.
I am a database Developer,how to become Data Engineer
Learn advanced SQL and python
@@ankitbansal6 thanks sir ji