Tried using table partition but dropping the original constraint and creating a new constraint is taking more than 1 hour each for 11 million of records. Is this expected? It’s not ideal if you cannot afford long downtime just to do the maintenance.

What is first step actually cant understand how to run query

Thank you..for such an amazing tutorial….trying to download from past few days….but too many errors…finally got ur video…

Aa scripts evaru istahru we need to create aa

I have done all the configuration but namenode is not starting on localhost

Have you used stored procedure on this data?

Hi Sagar, For you how date columns getting todays date in department table? And for status column also how you are getting automatic inserting value as 1?

Can you please share sql query which you have executed, so that we will follow same

Brother I am getting same issue while using premium one in free trial. Can you help me.

pls share all SQL scripts

Hai Sagar, you need to provide whatever you created scripts on Drive and share the link ,it will be usefull for learn.most of the people like that , and also you might get subscribers and loves

Thanks very much for this informative video, l have been struggling, finally you saved my @$$

amazing teacher as usual thank you

sir main ne abhi abhi forented complete kiya h javascript and react tk database learn krna chahta h sql kaise complete kre

In case there is a failover which happened in primary server, it shifts to secondary server. Have few questions in this context? 1) When does it shifts back to primary , is that manual? 2) Say my application is connected to primary, transactions are happening live. if failover happens and moves to secondary server, will the transactions in the applications wont update any more in the database , since it is secondary, how can i assure my read/write are done asynchronously irrespective of the server shift.

Can you make video on Application part also. it will be great learning

Thanks for the video series, it's useful.

Bhai data set kha se download kare

how can i get the data on which u r working for practice? only transcript are available, which i dont know how to use, can u pls guide???

bro can i do this project in oracle also.it will work ? iam using the version of 10g. or it will work in mysql ? so it will work? please reply me .becoz iam so confused

please can get the dataset for this sql project

Hi Br o thank you very much for sharing valuable knowledge, could you please provide database? for practice purpose

Hi..Can i use mysql server

make something related to roject for business analytics to crack the interview

Bro you are doing very good job, No-one does that, Please don't get nervous and make your presentation better. Topics you've explained are very informative, I just wanted to add that Don't get nervous while the Voiceover. You are doing great job🔥

Very useful, thank you for sharing 🙏🙏

The browse directory didn’t work for me it gave me path does not exist on hdfs or webHDFS is disabled please check your path or enable webHDFS . Could you help please

Can I ask what resources did you use to be very very good at SQL?

please, can you send me the text file?

bro where is setup/installation??

شكرا على هذه المعلومات المفيدة اشكرك من كل قلبي

chandawad la rahata ka

can i execute the same project and same queries on PostGre SQL?

Great content

Really awesome, I tried so many tutorial sites and video tutorials but none worked until I followed your way. Thank you so much!!!

Hello Sagar. your videos are really Awesome and good explanation in interview format. Thank you.

Hello Sagar. your videos are really Awesome and good explanation in interview format. Thank you.

Hello Sagar. your videos are really Awesome and good explanation in interview format. Thank you.

Hello Sagar. your videos are really Awesome and good explanation in interview format. Thank you.

Hello Sagar. your videos are really Awesome and good explanation in interview format. Thank you.

Hello Sagar. your videos are really Awesome and good explanation in interview format. Thank you.

Hello Sagar. your videos are really Awesome and good explanation in interview format. Thank you.

Hello Sagar. your videos are really Awesome and good explanation in interview format. Thank you.

Hello Sagar. your videos are really Awesome and good explanation in interview format. Thank you.

Hi sagar thank you fir the vi i am trying to set up the ssms and run the script at the beginning but unable to kindly assist

Which sql server management studio are you using not able to find debug option

The way you said...Sabka Mangal Sabka Bhala...real sagar

YOUR VEDIOS ARE AWESOME BRO

I need source code

Can i mention this project in resume?