This course teaches learners how to create and utilize MySQL stored procedures and functions. By the end of the course, students will be able to create variables, write stored procedures, and understand the syntax for creating procedures in MySQL. The course uses a hands-on approach with practical examples and SQL Fiddle exercises. It is suitable for individuals looking to enhance their MySQL database management skills and those interested in learning about stored routines in MySQL.
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
