Stored Procedure, Function and Cursor| SQL Intermediate Course | Logic First Tamil
SQL Beginner Course,
• SQL Beginner Full Course in Tamil | L...
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: • Html and CSS
SQL: • SQL
DS and ALGO in C/CPP: • Introduction to Data Structures | DSA...
DS and ALGO in Java: • Introduction to Data Structures | DSA...
Python Full Course with game: • Learn Python in Tamil | Python Comple...
Java Playlist: • Learn Java in Tamil
Java one video: • Java Full Course in Tamil (2023) | Ba...
C Interview program playlist: • C Interview Programs in Tamil
C programming in one video: • C Programming in Tamil | Complete C P...
C programming playlist: • Introduction to C programming in Tami...
C++ Playlist link: • C++ Programming in Tamil
English channel link: / @logicfirst31