MySQL Fundamentals Part 2

By Pinal Dave
Part 2 of the Fundamentals of MySQL series, covering stored procedures, user-defined functions, triggers and more.
Course info
Rating
(318)
Level
Intermediate
Updated
Feb 10, 2020
Duration
2h 42m
Table of contents
Introduction
Introduction 2m
Joins, Unions and Subqueries
Beginning Joins 1m Correlated Subqueries 1m Demo: Correlated Subqueries 3m Demo: Cross Join 1m Demo: Full Outer Join 2m Demo: Inner Join 3m Demo: Joins with Using Keyword 3m Demo: Left Outer Join 3m Demo: Natural Join 2m Demo: Right Outer Join 3m Demo: Self Join 2m Demo: Subqueries 5m Demo: Subqueries with Aggregation Function 3m Demo: Union Operators 3m Equi Join 1m Inner Join 1m Introduction 1m Joins vs Subqueries 2m Joins with Using Keyword 1m Natural Join 1m Outer Join 1m Pop Quiz 5m Prerequisites 1m Puzzle 1m Self Join 1m Solution of Puzzle 2m Subqueries 1m Summary in Sixty Seconds 1m Union Operators 1m Visual Explanation of Cross Join 2m Visual Explanation of Full Outer Join 1m Visual Explanation of Inner Join 2m Visual Explanation of Left Outer Join 2m Visual Explanation of Right Outer Join 2m
MySQL Functions
Aggregate Functions 1m Cast Functions 1m Control Flow Functions 1m Date/Time Functions 1m Demo: Aggregate Functions 3m Demo: Cast Functions 2m Demo: Control Flow Functions 6m Demo: Date/Time Functions 4m Demo: Information Functions 2m Demo: Miscellaneous Functions 2m Demo: Numeric Functions 4m Demo: String Functions 6m Information Functions 0m Introduction 1m Miscellaneous Functions 0m Numeric Functions 0m Scalar Functions 0m String Functions 0m Summary in Sixty Seconds 1m
MySQL Views
Advantages of Views 2m Demo: DML Operations 3m Demo: Data Security 2m Demo: Simplified Queries 1m Demo: Views 4m Demo: With Check Option 5m Introduction 1m MySQL Views 1m Summary in Sixty Seconds 1m With Check Option 0m
Stored Procedures and Stored Functions
Advantages of Stored Procedure 2m Demo: Beginning Stored Procedures 3m Demo: Stored Functions - 1 4m Demo: Stored Functions - 2 2m Demo: Stored Procedures - Drop and Create 1m Demo: Stored Procedures with Multiple Resultset 2m Demo: Stored Procedures with Parameters - DML Operation 2m Demo: Stored Procedures with Parameters - Functions 2m Demo: Stored Procedures with Parameters - Input and Output 3m Introduction 1m Stored Functions 1m Stored Procedure vs Stored Function 2m Stored Procedures 1m Summary in Sixty Seconds 0m
Triggers and Events
Demo: After Trigger 4m Demo: Before Trigger 4m Demo: Recurring Event 2m Demo: Single Time Event 2m Events 1m Introduction 1m Summary in Sixty Seconds 0m Triggers 1m
Summary and Resources
Summary and Resources 2m
Description
Course info
Rating
(318)
Level
Intermediate
Updated
Feb 10, 2020
Duration
2h 42m
Description

MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open source web application software stack. In this course, which is part 2 of the Fundamentals of MySQL series, we explore more advanced topics such as stored procedures & user-defined functions, subqueries & joins, views and events & triggers.

About the author
Pinal Dave
About the author

Pinal Dave is a Pluralsight Developer Evangelist.

More from the author
Open Source Cloud: Executive Briefing
Beginner
25m
Aug 6, 2020
Build Your First Data Visualization with FusionCharts
Beginner
47m
Jun 9, 2020
Foundations of Document Databases with MongoDB
Beginner
2h 28m
May 6, 2020
More courses by Pinal Dave

You're the smartest person in the room

PROVE IT

Your team won't just close the skills gap

THEY'LL HURDLE IT