SQL Query Optimization and performance tuning | SQL Tutorial for Beginners in Hindi

In this video we have discussed tips and tricks by which we can optimize any SQL query and improve performance.

Please like & share the video.

Subscribe the Channel to keep watching interesting videos helpful for your career growth:

--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------

Checkout different playlists:

--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------

Checkout Important videos :

--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------

[tansukhraigautam]

My family is not financially strong. Fee courses for advanced computer languages are therefore not affordable. In this case your YouTube videos are a blessing. Please upload more such courses here. And a big thanks for explaining in hindi

[layanibandaranayake]

I am a Sri Lankan.. But I understood everything 😊. Thank you for the short yet clear explanation.. 🙏

[sarthakgupta]

Very good video, thank you so much. Request to make same video in English too, so that this valuable knowledge is available to everyone in the world!

[iqbalkhan]

Bro mai phele ek query use krha tha but ab usme kah rha hai k atleast one partition column filter required

[sjain]

Amazing video. Thank you so much for providing such a crisp video with explanation 🙏👏

[vinaykumarboddu]

Really great points explained in single video .... thanks a lot for your video

[abhishekinvisible]

Nice points. I'm subscribing. Keep sharing your knowledge

[E]

Amazing explanation bhai. Happy diwali and thanks a lot for lovely videos.

[akshaypatil]

5:50 in table to check specific value we use LIKE, i am just confuse why did you say count & count() to aggregate function hai na

[itsdragonav]

Bhai placed heigali, tq so much for your sql queries and interview questions

[randirona]

Nice bro, jab maine real database ke sath kaam kiya practice ke baad sirf 30 attime visitor se database reply Dena band kar diya😅

[siddheshaddarkar]

Use temporary table or cte whenever possible.... Specially if you are using self join

[DetectivEDecodE]

Bhai love u ... Thank U sm .. Very helpful ✨

[siddheshaddarkar]

Index ka sequence bhi imp hai.. if case of composite index

[pratikshafoodie]

Could someone help me with answer for below question
Question:- Suppose I have table with record 1, A, 2, B, 3, C and I want separate these record with two columns where record would be for first column is 1, 2, 3 and second column would be A, B, C

[hintsoftware]

Dear Sir,
I am trying for FIFO Stock Valuation as follows using your taught methods like cte and window functions. but not getting done so far. If possible please help us solving this below case solved in a separate video which can be very fast even for lacs of records.

Input Table:
DocNo Date InnQty InnRate OutQty OutRate
1 12/02 12 12.50
2 12/03 13 ?
20 12/04 50 10.20
10 12/10 100 11.25
11 12/25 25 ?
14 12/29 150 ?


We need to populate the data according to FIFO method as following:


for 2nd OutQty(25 Pcs)=25 Pcs @ 10.20 (Because 2nd InnQty has still sufficient Left(50-1-25)=24Pcs for next outqty)



Output Query by CTE, Running Total and window functions Approach:
DocNo Date InnQty InnRate OutQty OutRate
1 12/02 12 12.50
2 12/03 13 12.32
20 12/04 50 10.20
10 12/10 100 11.25
11 12/25 25 10.20
14 12/29 150 11.08


Regards-
Sanjeeb

[mod]

Your videos are very helpful

Can you provide answer for below output
Column1
bac-123-xyz
a-1234-poi
dddd-11-pxu-201

Output
123
1234
11

[archanaw]

Agar real environment me query run karane ke baad system hang hoti hai to kya karana chahiye

[RealSlimShady-umgf]

Do you have info on how in reality you work with huge database with both primary and standalone database. Index Tables everything is well-defined. No * in select but data is in TB

[prabhatshrama]

count() and exists() ya exists() and in