Procedure Tutorial in SQL | SQL Stored Procedure | Procedure in SQL

Visit http://brilliant.org/techTFQ/ to get started learning STEM for free, and the first 200 people will get 20% off their annual premium subscription. This video is about Stored Procedure in SQL. We look at what is a procedure, what is the purpose of using a procedure in SQL, syntax for creating and executing a procedure and also we shall create simple yet realistic procedure with and without parameters. We cover the concept of SQL Procedure for the most popular RDBMS such as PostgreSQL, Oracle, Microsoft SQL Server and MySQL. All the scripts and dataset used in this video can be downloaded for free from my discord channel. Link to join my discord below: https://discord.gg/8aRSbygbdu My Recommended SQL Course: https://learnsql.com/?ref=thoufiqmohammed My Recommended platform to practice writing SQL queries: https://www.stratascratch.com/?via=techTFQ My Live SQL Course on Lighthall: https://www.lighthall.co/profile/techTFQ Timestamp: 00:00 Introduction to procedure tutorial 02:12 What is a procedure 03:07 What is the purpose of using a procedure in SQL 04:31 Syntax to create a procedure in PostgreSQL 09:18 Syntax to create a procedure in Oracle 10:22 Syntax to create a procedure in Microsoft SQL Server 13:07 Syntax to create a procedure in MySQL 15:58 Create and execute a procedure without parameters in PostgreSQL 26:38 Create and execute a procedure without parameters in Oracle 30:48 Create and execute a procedure without parameters in Microsoft SQL Server 34:54 Create and execute a procedure without parameters in MySQL 38:41 Create and execute a procedure with parameters in PostgreSQL 51:51 Create and execute a procedure with parameters in Oracle 56:18 Create and execute a procedure with parameters in Microsoft SQL Server 01:02:28 Create and execute a procedure with parameters in MySQL If you like my videos, do consider subscribing. 🔴 WATCH MORE VIDEOS HERE 👇 ✅ SQL Tutorial - Basic concepts: https://www.youtube.com/playlist?list=PLavw5C92dz9HQQ_COgGb7kf_1H8UWUBxO ✅ SQL Tutorial - Intermediate concepts: https://www.youtube.com/playlist?list=PLavw5C92dz9FD9XspliRM_HZM_jK7tkii ✅ SQL Tutorial - Advance concepts: https://www.youtube.com/playlist?list=PLavw5C92dz9GbmgiW4TWVnxhjMFOIf0Q7 ✅ Practice Solving Basic SQL Queries: https://www.youtube.com/playlist?list=PLavw5C92dz9F66P3GFo5O6nJ4DfZNhVsp ✅ Practice Solving Intermediate SQL Queries: https://www.youtube.com/playlist?list=PLavw5C92dz9EIYmNXJ8ZtQ1bmLIpt0SpV ✅ Practice Solving Complex SQL Queries: https://www.youtube.com/playlist?list=PLavw5C92dz9Fahr7taauUx5RnTfuGyL-- ✅ Data Analytics Career guidance: https://www.youtube.com/playlist?list=PLavw5C92dz9FDsr995DjwCy9XNaIukb8P ✅ SQL Course, SQL Training Platform Recommendations: https://www.youtube.com/playlist?list=PLavw5C92dz9GqF1Q_zn8KnYvFgtEOh-2n ✅ Python Tutorial: https://www.youtube.com/playlist?list=PLavw5C92dz9FePZXIo4jpsupqp3X0w2SW THANK YOU, Thoufiq