Скачать или смотреть SQL Procedures, Triggers & Events (MySQL Live Demo)

SQL Procedures, Triggers and Events

Join me where I cover SQL Procedures, Triggers and Events

I cover the terminology and why you might hear PL/SQL or T-SQL, where these terms come from so you can understand in laymen's terms

Step by step I walk you through creating procedures... you learn about query parameters and variables, why they are used and how

We then walk through triggers and how they are executed with some clear business cases on where they can be used

Finally we look at events and how the UI differs to procedures and triggers
Extending to queries, including joins, operators, functions and even transactions!

All of this is delivered in a way that is easy to follow and understand, as well as covering some of the technical terms used to describe each aspect

=== Timestamps ===
0:00 - What do we need to build?
00:50 - Procedures, Triggers and understanding different databases (MySQL, SQL Server & Oracle)
02:08 - Stored Procedures
19:13 - Triggers
27:27 - Events

☕ SUPPORT THE CHANNEL
If you’re enjoying these videos and want to help me make more, consider buying me a coffee:
https://buymeacoffee.com/lukesaunders

Getting to know SQL (Watch this first to understand the basics)
   • Getting to Know SQL (Live Demo using mySQL)  

MySQL Workbench link
https://dev.mysql.com/downloads/workb...

If your interested in learning more about logistics and integration please review my other videos.

#sql
#mysql
#mysql_workbench
#sqltips
#procedures
#triggers
#plsql
#tsql

Feel free to connect:
  / lukeksaunders