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

SQL Beginner Course, https://www.youtube.com/watch?v=r5IyLq2k2Ps&t=5218s 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 Github CodeLink - https://github.com/LogicFirstTamil ---------------------------------------- courses and playlists -------------------------------------------------- HTML and CSS: https://www.youtube.com/playlist?list=PLYM2_EX_xVvXZ2A08faQ_7Iz4unlGs176 SQL: https://www.youtube.com/playlist?list=PLYM2_EX_xVvUBh28ZT2i-jH7kBkTfB_W2 DS and ALGO in C/CPP: https://www.youtube.com/watch?v=QQBVNwA9rDI&list=PLYM2_EX_xVvVMXkQt4qqosJTplBq5v5oX DS and ALGO in Java: https://www.youtube.com/watch?v=t2U989oaI1Q&list=PLYM2_EX_xVvX7_AmNY-Deacp3rT3MIXnE Python Full Course with game: https://www.youtube.com/watch?v=BiDOehqG68g Java Playlist: https://www.youtube.com/playlist?list=PLYM2_EX_xVvVXm005Gt5unmqW6GGMjHxa Java one video: https://www.youtube.com/watch?v=qOWPCPCDRZs&t=2751s C Interview program playlist: https://www.youtube.com/playlist?list=PLYM2_EX_xVvV4Kypzs6haPDJrXBaYFVEd C programming in one video: https://www.youtube.com/watch?v=JAy56OH58Y4&t=17269s C programming playlist: https://www.youtube.com/watch?v=xKGg8UfR0mM&list=PLYM2_EX_xVvU7N5Lcp1SjKnGN5e6riUoj C++ Playlist link: https://www.youtube.com/playlist?list=PLYM2_EX_xVvUppW1kS91ZNEI20k1V1liI English channel link: https://www.youtube.com/channel/UCFhHB5_2UkzB4V5iL1oaI-Q/featured