Dive into a comprehensive 90-minute tutorial series on MySQL stored procedures and functions. Learn the fundamentals of stored routines, explore variable creation and manipulation, and master the syntax for creating procedures. Gain practical experience with SQL Fiddle for database creation, understand the concept of Database API, and discover how to effectively use SELECT and SET statements. Perfect for developers looking to enhance their MySQL skills and streamline database operations.
Overview
Syllabus
MySQL Stored Procedure 1 - Intro to Stored Routines.
MySQL Stored Procedure 2 - Intro to Variables.
MySQL Stored Procedure 3 - Variables.
MySQL Stored Procedure 4 - Creating Variables within SELECT.
MySQL Stored Procedure 5 - SQL Fiddle - CREATE DATABASE.
MySQL Stored Procedure 6 - How to Create Variables with SELECT and SET.
MySQL Stored Procedure 7 - Intro to Stored Procedures.
MySQL Stored Procedure 8 - Procedure Syntax.
MySQL Stored Procedure 9 - Database API (Application Programming Interface).
MySQL Stored Procedure 10 - CREATE PROCEDURE.
MySQL Stored Procedures All-in-One Quick Start Tutorial Series (1 HOUR!).
Taught by
Caleb Curry
