MySQL Stored Procedures and Functions
Offered By: Caleb Curry via YouTube
Course Description
Overview
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.
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
Related Courses
Creating Programmatic SQL Database ObjectsMicrosoft via edX Developing SQL Databases
Microsoft via edX Advanced Relational Database and SQL
Coursera Project Network via Coursera SQL Functions
Coursera Project Network via Coursera Master C# And SQL By Building Applications
Udemy