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)
@@ankitbansal6I wanna become data engineer but write now working in IT since 1.5 years in Technical Operations support role so what option should be wise which should I opt for ?? As bcoz as Data engineer roles jobs are mostly not entry level so can I go with Data Analyst entry level job and then post that prepare to switch to Data Engineer role ???
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.
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.
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
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.
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.
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 😢
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 :(
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 🙏
@@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
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😢
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
![How to Break into Data Analytics [From Non-Tech Background]](http://i.ytimg.com/vi/sW7N2s0BeqI/mqdefault.jpg)
![How to Break into Data Analytics [From Non-Tech Background]](/img/tr.png)
Road map: SQL, python, azure, adf, pyspark, Databricks. Entire 27 minutes summary. Even after 6 months roadmap will be same.
When deepak said hadoop is obsolete, he tries to to mention Mapreduce is obsolete, hdfs and yarn are still on the market.
Very cool! Thanks both😊
Glad you enjoyed it!
Great one! Thanks.
Thanks Ammitji for the roadmap.the best on internet.
Thank you Deepak and Ankit for valuable guidence on roadmap
Absolutely..
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 😊
@@ankitbansal6I wanna become data engineer but write now working in IT since 1.5 years in Technical Operations support role so what option should be wise which should I opt for ?? As bcoz as Data engineer roles jobs are mostly not entry level so can I go with Data Analyst entry level job and then post that prepare to switch to Data Engineer role ???
Great initiative Ankit bro 👍
✌
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
Very nice podcast. Thank you Ankit
Thanks for listening🙏
Need of the hour, Thank you so much Ankit for this wonderful session to data community 😊
Always welcome 🤗
Great content Ankit 👍
Great session sir
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
Well explained..
Thank you 👍
You are welcome
I just recommend your yt playlist and Deepak’s course . Awesome information
Thanks for sharing🙂
my current job is not from data domain so please make a video for transition towards data engineering
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?
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
Ankit and Deepak , both are very honest guys
Thank you Ankit :)
My pleasure 😊
Ankit Bhai Zindabad
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
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?
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.
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?
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 :(
Hi which course will you recomend to learn ? I'm an ETL Tester..have knowledge on SQL
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
Thank you so much sir
Most welcome
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?
what about Linux is it important to learn it ?
Yes basics you should know
Good Podcast, but sir it's still 2023, just checked the calander to confirm 😄😄
I know. It's a future proof roadmap.
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
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 😊
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
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