Stored Procedure, Function and Cursor| SQL Intermediate Course | Logic First Tamil

SQL Beginner Course,

00:00:00 - Introduction
00:00:48 - What is a stored procedure?
00:01:58 - Create procedure
00:06:30 - Advantages/Disadvantages of stored procedure
00:10:14 - Drop stored procedure
00:11:15 - Variables in Mysql
00:17:37 - Passing parameters IN, OUT and INOUT
00:31:20 - If Else
00:34:31 - Case statement:
00:36:18 - Loop using loop and leave
00:41:49 - Loop using while
00:43:00 - Loop using repeat
00:44:46 - User defined functions in stored procedure
00:51:51 - Deterministic vs not deterministic function
00:56:51 - Functions vs stored procedure
00:57:40 - Error handing using handler
01:08:04 - Using named condition for handler
01:08:48 - Signal and Resignal
01:13:59 - Cursor

---------------------------------------- courses and playlists --------------------------------------------------

[aravindabishek]

When teaching comes to an art, then you are an artist ❤️🎖

[Arun-uwhy]

I think no Tamil channels gives this much quality content about SQL yet...please do more videos... Real-time la epdi databases la irundhu requirements ku etha maari Query write pandradhunu podunga...like requirement as a question

[venkatesanaj]

The best Tamil Channel for program beginners.. keep Continue Wait for NEXT PART.
Please upload as soon as Possible.

[pragadheeshwaran]

வழிமேல் விழி வைத்து காத்திருந்த பதிவு 💖 நன்றி kah👌

[Ramesh-qjr]

Mam the way you explained is leading to learn the concept well.. Thank u so much mam. Have a good luck..

[abishathankappan]

Thank you so much for your help...I learnt more than I expect...

[UsharaniSudhakar-pzhx]

You know I don't have words to praise you for such concept video... Simple and neat

[jananit]

Vera level teaching akka neenga, semma 👏👏👏🥰

[kamalraj]

Perfect & simple explanation.... keep continuing the same sis.

[aruleditz]

Useful video, uinga video semmaya purithu mam 🤗

[Gokulraj_Palani]

Thanks, mam. clearly explained each line of code.👍

[mohamedazeem]

Mam please upload advanced SQl Course too

[SanjayI-ue]

ungala maari yarume procedure, function video podala thanks mam.

[shahnaz]

Mam, make videos for hyperNet,
Spring boot
And Angular❤
Humble request❤

[veerasakthivela]

Very most expected one from you madam👏. Once I was asked you about stored procedures you were suggest some other channel, I’m not able to get anything from there, But it’s my turn I’ll also write stored procedures with the the help of this one. kindly request you suggest me like that package, package body and how stored procedures and pkg, body works together💙

[selviraghavi-jpep]

This video is very good and perfectly understandable but i had an doubt at last on cursors sister instead of creating a table and assigning values and creating a stored procedure and creating a cursor and fetching and storing it and running in a loop and then after error handling you can straight away use a statement like this right CREATE TABLE BACKUP_STUDENT SELECT * FROM student_stored_procedure. I executed this code and the same output came for me also in my case
Meanwhile Thanks for making me learn this topic :)

[balavikeshd]

Waiting for SQL class Mam simple "SQL project run and explain it mam" related to data science

[aravindkumarn]

Super sis, advanced concepts tamil la adhigama illa, clearly explained

[afrinkadar]

done a great job for beginners
thank u

[atchayasingaravelu]

such a great explanation, thankyou mam