Visit http://brilliant.org/techTFQ/ to start STEM learning for free, and the first 200 people will receive 20% off their annual premium subscription.

This video is about stored procedures in SQL. We will look at what a procedure is, the purpose of using a procedure in SQL, the syntax for creating and executing a procedure and we will also create simple but realistic procedures with and without parameters. We will cover the concept of SQL procedures for the most popular RDBMS such as PostgreSQL, Oracle, Microsoft SQL Server and MySQL.

All scripts and datasets 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 for practicing writing SQL queries:
https://www.stratascratch.com/?via=techTFQ

My live SQL course on Lighthall:
https://www.lighthall.co/profile/techTFQ

Time stamp:
00:00 Introduction to the procedure tutorial
02:12 What is a procedure
03:07 What is the purpose of using a procedure in SQL
04:31 Syntax for creating a procedure in PostgreSQL
09:18 Syntax for creating a procedure in Oracle
10:22 Syntax for creating a procedure in Microsoft SQL Server
13:07 Syntax for creating a procedure in MySQL
15:58 Creating and executing a procedure without parameters in PostgreSQL
26:38 Creating and executing a procedure without parameters in Oracle
30:48 Creating and executing a procedure without parameters in Microsoft SQL Server
34:54 Creating and executing a procedure without parameters in MySQL
38:41 Creating and executing a procedure with parameters in PostgreSQL
51:51 Creating and executing a procedure with parameters in Oracle
56:18 Creating and executing a procedure with parameters in Microsoft SQL Server
01:02:28 Creating and executing a procedure with parameters in MySQL

If you like my videos, please consider subscribing.
MORE VIDEOS CAN BE FOUND HERE

SQL Tutorial – Basic Concepts:
https://www.youtube.com/playlist?list=PLavw5C92dz9HQQ_COgGb7kf_1H8UWUBxO

SQL Tutorial – Advanced Concepts:
https://www.youtube.com/playlist?list=PLavw5C92dz9FD9XspliRM_HZM_jK7tkii

SQL Tutorial – Advanced Concepts:
https://www.youtube.com/playlist?list=PLavw5C92dz9GbmgiW4TWVnxhjMFOIf0Q7

Practice solving basic SQL queries:
https://www.youtube.com/playlist?list=PLavw5C92dz9F66P3GFo5O6nJ4DfZNhVsp

Practice solving advanced SQL queries:
https://www.youtube.com/playlist?list=PLavw5C92dz9EIYmNXJ8ZtQ1bmLIpt0SpV

Practice solving complex SQL queries:
https://www.youtube.com/playlist?list=PLavw5C92dz9Fahr7taauUx5RnTfuGyL–

Career advice in data analysis:
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 VERY MUCH,
Thoufiq

Please take the opportunity to connect with your friends and family and share this video with them if you find it useful.