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
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.
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)
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 😢
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.
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
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
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😢
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.
Road map: SQL, python, azure, adf, pyspark, Databricks. Entire 27 minutes summary. Even after 6 months roadmap will be same.
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
When deepak said hadoop is obsolete, he tries to to mention Mapreduce is obsolete, hdfs and yarn are still on the market.
Stopped watching when u say azu-Reee to Azure
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
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 😊
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?
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?
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.
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.
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?
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
🙏
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
Ankit Bhai Zindabad
my current job is not from data domain so please make a video for transition towards data engineering
Hi which course will you recomend to learn ? I'm an ETL Tester..have knowledge on SQL
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
Thank you Deepak and Ankit for valuable guidence on roadmap
Absolutely..
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 😊
Very cool! Thanks both😊
Glad you enjoyed it!
Great one! Thanks.
From where we can learn spark in a better way?
Need of the hour, Thank you so much Ankit for this wonderful session to data community 😊
Always welcome 🤗
Thanks Ammitji for the roadmap.the best on internet.
Very nice podcast. Thank you Ankit
Thanks for listening🙏
Great session sir
Glad to see both Guru together... You both are helping the data community in so many ways
Good Podcast, but sir it's still 2023, just checked the calander to confirm 😄😄
I know. It's a future proof roadmap.
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 so much both for your actionable insights. Really appreciated this conversation.
Glad you enjoyed it!
Great initiative Ankit bro 👍
✌
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?
Ankit and Deepak , both are very honest guys
what about Linux is it important to learn it ?
Yes basics you should know
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
Well explained..
Great content Ankit 👍
Thank you 👍
You are welcome
I just recommend your yt playlist and Deepak’s course . Awesome information
Thanks for sharing🙂
Thank you Ankit :)
My pleasure 😊
I am a database Developer,how to become Data Engineer
Learn advanced SQL and python
@@ankitbansal6 thanks sir ji
Thank you so much sir
Most welcome