azure data engineer project | azure data engineer project end to end

[@Manwithguts1]

this video is helpful for training people who are learning to transition to cloud computing.keep posting

[@kabilannagarajan]

Great work Brother, please add more projects like this end to end, you have covered 3 months project in 45 mins, great

[@lifeitnow9600]

Great work...and most common scenario that's widely used has been covered....Keep posting such quality work in a simple and understandable to all viewers!!!!

[@yadi4diamond]

Your videos motivates an engineer to become a Data Engineer. Thanks for great teaching.

[@revcuts4648]

Idk how to express my appreciation to you, this is very helpful. Main apse aur sikhna chahta hon pls videos dalte rahiye 👑

[@hariprasad6252]

One of the best session I have ever seen this much simple and clear explanation and sir plz try to provide complete course for Azure data engineer .... 👏👏💐💐

[@fredoderazin7541]

This guy is king! Thank you for making this presentation. It’s a very practical training project.

[@gtanation4729]

Thankyou sooooo muchhh. Before this playlist i was 0 in this field but after watching all the videos of this playlist i am very confident that i can easily do azure data engineering. Thankyou againn keep uploading... We want more videos

[@kirantulluri]

This wonderful video, thanks taking time to explain in detail.

[@user-rh3dr5tc8t]

Great Explanation and easy to understand... I learnt lot process knowledge from this video. Thanks for sharing this awesome video. Please add more end to end videos for different scenarios.

[@shabeerkhan379]

Hi Brother - Keep uploading more projects & thanks !

[@aneerabdulkareem1524]

Great Work. Good tutorial. Thanks for all your efforts

[@kirigayakazutuu]

You saved my life man, Thanks bro

[@vedvikatechzone]

Great work Brother, please add more projects like this end to end.

[@USpilla143]

Very helpful,thanks for making this happened.Really worthy Vedioes ,Thanks Bro

[@user-gu5mn9zj5h]

great work bro, so much usefull information. Thanks for the video

[@srinivasaraog3180]

Very good information

[@gauranshbhutani592]

Amazing work my man, kudos, thank you so so much, Can you make more of such project based on healthcare data KPIs end to end and not use CSVs but connect data from Azure to power BI , Thanks a million, amazing project

[@SyedliyakathaliAli]

Neat and clear explanation, Thank you

[@maheshvenkat9256]

Excellent work

[@babarhussain7018]

You got another subscriber. Love your videos, very concise and easy to to understand. Keep posting😊

[@rabbanishaik2363]

Very informative video. Good Job. Thank you so much.

[@kumareshkrm7092]

Great work. Please keep do end to end projects like this.

[@balamuralibattala3283]

Thank you so much for sharing the knowledge

[@learnbydoingit]

Thanks

[@Rajesh-gm3fb]

Good Job bro...I love you...

[@apurvavaidya12]

THANK YOU FOR THE VIDEO KEEP DOING THE GREAT WORK

[@bachushankaraih5188]

Good

[@happyheart9431]

Million thanks..you are absolutely great..

[@PraveenKumar-ev1uv]

Awesome job..Appreciated

[@keshavofficial4542]

Super explanation bro..keep it up ..

[@srinuvaas-lf2xs]

Great job. Thanks a lot !!

[@saivems8452]

Suggestion - Go slow please. It's like chasing the topics....

[@Optimus_prim33]

Good good.

[@chiranthyn1126]

Great work.

[@wajidturi]

Great work

[@harshpatel3384]

Good work

[@user-cn4rq4mu7e]

great bro

[@swaroopblazing9568]

thank you for your contribution

[@learnbydoingit]

Thanks

[@user-jl5ky6qe8o]

Great work bro

[@madhusudhanmm3406]

Good explanation bro and one small request could you please post the end to end steps on note format/bullet points/short point to point in notepad also?

[@josemanuelgutierrez4095]

do you have any projects using event hubs , stream analytics ,or synapse analyrtics ?

[@priyankadubey2528]

Could you please share some videos for SQL projects, which i can include in my resume. Thanks

[@Akash13315]

Great..thank you

[@learnbydoingit]

Thanks

[@mnirani5230]

Thanks pls upload more projects

[@learnbydoingit]

Sure

[@sanskritisharma5447]

Thanks this is really helpful

[@learnbydoingit]

Good to hear

[@digitalsevasolutions]

Very helpful

[@dhananjaymali6242]

great explanation only one doubt, databricks community edition isn't available now then how to practice databricks portion

[@learnbydoingit]

Will make video for that

[@nareshm9473]

Great efforts. One time process is fine,but what if we want this to happen as a continuous process, I mean refresh of data every 1 hour?

[@learnbydoingit]

Do you mean hourly refresh ?

[@vallepumadhu3650]

Please make a video how to connect from SQL server configuration (permission, certificate authentication, reaming )and adf with linked service configuration because all are getting errors while test the connection in linked service

[@learnbydoingit]

Ok I will upload

[@vallepumadhu3650]

@@learnbydoingit below i commented exact error

[@chitrarekhatiwari6629]

Thank you so much for this

[@learnbydoingit]

Thanks

[@fahadmahmood7150]

Very Great explanation.! Could you please post some more content where u have moved the data from on-premise to ADLS gen using incremental/Delta approach. Once we did the full load on daily baisis i want to load the Incremental / change data based on last modified date of file which we have generated and take the MAX time stamp of source column.

[@learnbydoingit]

Incremental load video is a available in channel

[@mukuljha9740]

Thanks a Lot Bro.

[@learnbydoingit]

Thanks 👍

[@mareswararaomalle9958]

Please do video on health care project

[@nikhilrothe3419]

Thank you bro

[@TheHani82]

Kindly maintain low pitch voice while talking in the video

[@learnbydoingit]

Sure will take care.. Mic prblm

[@prateekkumar-xc6uo]

Can you also show us how to pass key & scope instead of passing directly ?

[@learnbydoingit]

Will upload that too

[@hassansaleem3784]

On second slide you have mentioned ' We have to build one pipeline which will transfer data and run daily' What do you mean by run daily ?

[@learnbydoingit]

Daily schedule

[@hassansaleem3784]

@@learnbydoingit But how the pipeline will trigger daily ? Because we haven't set any schedule!!

[@someshpatil4151]

@@hassansaleem3784 u need to setup trigger for that. refer any schedule trigger video that will help u to go further

[@ruckyA]

What is the benefit of using data bricks in here , i think you can also use power BI to do some data processing and manuplation

[@learnbydoingit]

Yes but if you have millions of records and that too keep on increasing so we create aggregate and then we do reporting on top of it... Here we have less columns and less data so directly u can use power bi no doubt.. But think about big data

[@user-dq4yf6mk7m]

Thanks alot

[@learnbydoingit]

Thanks

[@mihirit7137]

I wanted to know if the pipeline is real time , i.e. if there are changes made in the Flatfile or SQL or data is added will it be reflected in powerbi ?

[@learnbydoingit]

Yes

[@user-pk8iz4bu7c]

Can anyone provide the notebook document for databricks part.

[@SH-cy6lh]

Bro are you on LinkedIn?

[@bhartimankar4052]

Hello! I really appreciate this excellent tutorial. Thank u for the amazing content. However when I tried to copy data , I encountered an error "Schema import failed: Please select a table" . however my table is showing and selected still got that error in 12:03 .Could you kindly assist me with this issue? Thank you in advance for your help!

[@learnbydoingit]

Do select import schema as none while selecting table I have created video for this error yesterday please do watch

[@learnbydoingit]

Pls follow kzbin.info/www/bejne/aH-ch3yvh9iHmposi=8oA5P6qLIGT83tlm

[@bhartimankar4052]

Thanks for your fast reply and all your efforts. Its worked .

[@user-gt8bz4tw6u]

Power bi needs to data engineer jobs? ,i think its for data analytics right

[@learnbydoingit]

Yes it's for analytics but in few companies you have to build report also

[@SomeOne-qv2tf]

aggregate table creation error: IllegalArgumentException: All week-based patterns are unsupported since Spark 3.0, detected: e, Please use the SQL function EXTRACT instead

[@learnbydoingit]

Not sure about this error ...which part u are stuck

[@yashsharma-td6ii]

This project is done on azure cloud right ??

[@learnbydoingit]

Yes

[@World_Exploror]

Please share notebook it will be helpful

[@Rahul-wu1ig]

bro when we say we need to learn python for azure data engineering. Is that mean that we are learning python for pyspark? please clear this doubt, coz I understand pyspark, but I don't want to do python in deep, I know the basics of python.

[@learnbydoingit]

Yes pyspark for data engineer..

[@Rahul-wu1ig]

@@learnbydoingit so it means we are learning python just to understand pyspark and implement it?

[@user-gg5kt7qy6b]

one interview qs from tech mahindra is how you give the names to tables in sql ,comment the ans pls

[@Canadian_Drizzles]

Hi. I can't connect Data Factory with the server. I couldn't find the username and password. Can you please help me to fix this issue?

[@learnbydoingit]

Hope which creating server u have given authentication method and pass username and password

[@matthewmark7224]

great video but i was unable to use the integration runtime using postgresql. how do i download the sql you are using? is it free?

[@learnbydoingit]

Yes it's free use sql server download in google

[@matthewmark7224]

@@learnbydoingit ok thanks. it worked.

[@logsofzany]

what about the pipeline bro? doesn't require?

[@logsofzany]

bro just told me, I love you but as a friend by liking my doubt comment but not answering it💀💀🤡

[@YogeshSingh-b1v]

any idea how to connect sql server via azue data studio to azure data factory in macbook

[@learnbydoingit]

I haven't uploaded video but you will get similar video in youtube

[@YogeshSingh-b1v]

​@@learnbydoingitthanks for reply but i dint find any if you can share really would help me

[@dianeavwenaghagha1193]

what happens if connection is not successful after download of the integration runtime

[@someshpatil4151]

reinstall and try again it will work

[@mainuddinali9561]

i m not able to find user name, server name and password in my sql

[@learnbydoingit]

Will upload video for that

[@mainuddinali9561]

@@learnbydoingit if it is possible,plz do hurry

[@user-pk8iz4bu7c]

Facing same issue. Unable to get the password from SQL server. Please reply urgently @learnbydoingit

[@Kalyan91]

What is the title of the project so that i can add it in my resume?

[@learnbydoingit]

Data migration and analysis

[@zahidalam7831]

How to connect sql server and what would be the user and password , i already installed sql server management ???? Kindly help me out .

[@learnbydoingit]

While installing there is process to setup login and password and if you havent done then also there is process to add

[@zahidalam7831]

@@learnbydoingit how to do now, it's already installed sir

[@sandeepivs]

Please share us the ppt

[@user-fm8qd8bu6m]

hie can i do this project entirely on the cloud without on premises servers

[@learnbydoingit]

Yes use sql db in azure

[@yogeshvanare133]

brother can you send this power point sheet

[@LuckyAzher]

integration run time issue cannot connect to sql server

[@learnbydoingit]

Have u created Integration run timr

[@LuckyAzher]

@@learnbydoingit still no struck to that error since that day now the latest error im getting make sure sql db firewall allows integration run time to acess please help

[@insidehead]

How much amount I will be charged to do perform these workflow?

[@learnbydoingit]

SQL server free , power bi free , databricks free edition and only for azure if you have not created account you can create 30 days free and practice.

[@insidehead]

@@learnbydoingit I know actually my ac expired. That's y I asked

[@sanjud198]

i am unable to mount using this way. Can you please help me in this regard

[@learnbydoingit]

What is the error need to debug

[@learnbydoingit]

What is the error need to debug

[@asthasatija-f1y]

What does KPI means?

[@learnbydoingit]

KPI stands for Key Performance Indicator, which is a quantifiable metric used to track progress towards a specific business objective.

[@madheshrajs1675]

Bro the azure services you are using is free of cost?? If not, is there any way to use it free. Can you please help me on this. I'm trying to do by practice but stuck in the above questions.

[@learnbydoingit]

Free for one month

[@user-pq7yc3fl7o]

hi where is the data file

[@learnbydoingit]

It's there in telegram and description also I will add in hour

[@vijaykanaparthi980]

Ur lecture so fast...

[@learnbydoingit]

Will take care but each step wr have covered you will definitely like... You can slow KZbin speed

[@therestfulmedia363]

How to check sql server password I can see user name but password I can’t see in my SSMS

[@learnbydoingit]

Is this windows authentication?

[@learnbydoingit]

While setting up ssms there is option.to setup username and password... Second way is to add login ur name and password

[@asitadeka4010]

can anyone help me if i wan to put this project in resume what description shoulf i write

[@learnbydoingit]

U can mention about data pipeline , pyspark databricks and visualization part

[@Sandy-zn7vy]

I m not able to find in SQL server

[@learnbydoingit]

Will upload today

[@sejalahire1370]

@@learnbydoingit have u uploaded it sir? i m not able to find server name and ur vdo related to that as well..please help sir

[@learnbydoingit]

@@sejalahire1370 server name is while login you see name in sql

[@SomeOne-qv2tf]

i got 3 errors 154 commented memebers not got any single error woow great please help

[@learnbydoingit]

What is the error

[@therestfulmedia363]

11:31 what is username and password, how can I know

[@learnbydoingit]

Sql ?

[@therestfulmedia363]

Yes

[@learnbydoingit]

If urs showing windows authentication then there is process to setup user name and password you can search in youtube

[@Sandy-zn7vy]

Where to find SQL server user name and password

[@learnbydoingit]

While installing we have option to setup or you can add in logic and do i will upload video for that

[@Sandy-zn7vy]

@@learnbydoingit please make a video on this

[@grandhisandeep007]

Please keep the ppt we will verify

[@learnbydoingit]

What you want to verify?

[@learnbydoingit]

Uploaded in telegram

[@shyammaths5705]

could you provide csv file

[@learnbydoingit]

Available in description

[@user-xo7ju5rr8z]

Speak slow😮

[@learnbydoingit]

Will try that

[@user-xo7ju5rr8z]

@@learnbydoingit thanks for accepting...

[@user-xo7ju5rr8z]

@@learnbydoingit Sir I have one question..I joined MNC as a fresher and its been 2 and half year.But I Have worked only for 10 to 11 months and around 4 to 5 was training period. Other than this I was on bench and they are not putting me in project. But Now I planning to change the company but I dont know how to clear interviews as I didnt work much..Dont know what exactly the projects Are...Please give me an idea how to prepare I have knowledge on sql, Sql server, Power BI, Adf, Adb, Synapse, Snowflake basics. Please help me sir😌

[@shaqibiqbal1839]

Hey at 22:59 , I am doing same step but i am getting an error that "SyntaxError: invalid syntax (, line 1) File :1 select * from online_sale_analysis ^ SyntaxError: invalid syntax" Even though i have created "df.createOrReplaceTempView('online_sale_analysis')" and it is successfully done. What is this error ?

[@shaqibiqbal1839]

I have done that mouting part and created df

[@learnbydoingit]

Do check df is created or not

[@shaqibiqbal1839]

yes it created even though i can see dataframe data@@learnbydoingit

[@shaqibiqbal1839]

yes it is created i can access my df and can see df data @@learnbydoingit

[@shaqibiqbal1839]

Yes i checked df is already created and able to access df but still having same issue@@learnbydoingit

[@manasactis4-9996]

Please Help me Out through this ERROR Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'MANASAGADDI\SQLEXPRESS01', Database: 'sales', User: 'pizza'. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access. A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) The certificate chain was issued by an authority that is not trusted

[@learnbydoingit]

Check linked service and connection string to access ir