Data Engineer Complete Roadmap For Beginners and Experienced Professionals (2024) | ft. @azureli

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

[@durgaprasad-vm4mh]

Road map: SQL, python, azure, adf, pyspark, Databricks. Entire 27 minutes summary. Even after 6 months roadmap will be same.

[@mohitmotwani9256]

Great one! Thanks.

[@aishwaryac3845]

Thanks Ammitji for the roadmap.the best on internet.

[@dataquery03382]

Great session sir

[@bukunmiadebanjo9684]

Great content Ankit 👍

[@karthikeyana6490]

Very cool! Thanks both😊

[@ankitbansal6]

Glad you enjoyed it!

[@sammail96]

Very nice podcast. Thank you Ankit

[@ankitbansal6]

Thanks for listening🙏

[@sapnanimbalkar1210]

Thank you Deepak and Ankit for valuable guidence on roadmap

[@samirdeshmukh9886]

Absolutely..

[@ankitbansal6]

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

[@AlbouryNdiaye-ro8qz]

Thank you so much both for your actionable insights. Really appreciated this conversation.

[@ankitbansal6]

Glad you enjoyed it!

[@gunjankothari7471]

Well explained..

[@ajithshetty1684]

Need of the hour, Thank you so much Ankit for this wonderful session to data community 😊

[@ankitbansal6]

Always welcome 🤗

[@anupgupta5781]

Glad to see both Guru together... You both are helping the data community in so many ways

[@joerokcz]

When deepak said hadoop is obsolete, he tries to to mention Mapreduce is obsolete, hdfs and yarn are still on the market.

[@kanchankumar3355]

Great initiative Ankit bro 👍

[@ankitbansal6]

✌

[@Kondaranjith3]

Thank you 👍

[@ankitbansal6]

You are welcome

[@tipsandhacksbygaurav]

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)

[@ankitbansal6]

Sure

[@ramuraman8426]

That Deepak said we have to showcase something like whatever the project you have done convert it into Data Engineering style 😊

[@AdityaRaj-ti3uz]

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

[@utkarshmishra5057]

I just recommend your yt playlist and Deepak’s course . Awesome information

[@ankitbansal6]

Thanks for sharing🙂

[@silverfang6486]

Hi which course will you recomend to learn ? I'm an ETL Tester..have knowledge on SQL

[@09tt072]

Ankit and Deepak , both are very honest guys

[@TechnoSparkBigData]

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.

[@ankitbansal6]

Agree with you 🙂

[@anupgupta5781]

I do agree, he is such a good person

[@drishtisahu7887]

my current job is not from data domain so please make a video for transition towards data engineering

[@venkateshchandru128]

Thank you Ankit :)

[@ankitbansal6]

My pleasure 😊

[@amrindersingh4591]

Ankit Bhai Zindabad

[@views-re2om]

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 :(

[@ashanair5909]

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?

[@user-su2wt6rb2v]

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.

[@ankitbansal6]

SQL ,Python and a bit of cloud understanding

[@user-su2wt6rb2v]

@@ankitbansal6 will unix shell scripting works in place of python because both are scripting language

[@Sanskritik_bharat]

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.

[@MachinoLearno]

Repetition bro. Just solve as much problems as you can.

[@djsahu98]

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.

[@views-re2om]

which domain are you from?

[@Thekingslayer-ig5se]

Thank you so much sir

[@ankitbansal6]

Most welcome

[@user-jy8mt2om6g]

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]

Use lead and lag and add

[@user-jy8mt2om6g]

@@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

[@aadil8409]

Good Podcast, but sir it's still 2023, just checked the calander to confirm 😄😄

[@ankitbansal6]

I know. It's a future proof roadmap.

[@user-dk5rg8vt7t]

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 😢

[@ankitbansal6]

Not much, very basic. For data analysts just SQL , excel and bi tool will do.

[@user-dk5rg8vt7t]

@@ankitbansal6 for data engineer?

[@parthasarathimandal9437]

Is it possible to skip python and pyspark to become data engineer? Currently working as ETL Informatica developer and not much into coding before.

[@ankitbansal6]

I would suggest learning basic python. It's very easy to learn and start applying.

[@krishnakumarkumar5710]

Belive me I learnt python in 2weeks

[@parthasarathimandal9437]

@@krishnakumarkumar5710 can you share some resources?

[@germanaboytes649]

what about Linux is it important to learn it ?

[@ankitbansal6]

Yes basics you should know

[@vidulat6935]

I have 11.5 years of experience I want to learn data engineering, please advice

[@ankitbansal6]

Start with SQL and python. After that pick one cloud.

[@chandu4649]

Sql server or my sql Which one best

[@marvelmad7]

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😢

[@ankitbansal6]

It's not going anywhere . You can go for it 😊

[@prem1.83]

From where we can learn spark in a better way?

[@datalearningsihan]

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.

[@AbhishekKumar-gf4db]

I am a database Developer,how to become Data Engineer

[@ankitbansal6]

Learn advanced SQL and python

[@AbhishekKumar-gf4db]

@@ankitbansal6 thanks sir ji