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
(313)
Level
Intermediate
Updated
Feb 10, 2020
Duration
2h 42m
Table of contents
Introduction
Introduction 2m
Joins, Unions and Subqueries
Outer Join 1m Visual Explanation of Full Outer Join 1m Demo: Full Outer Join 2m Visual Explanation of Inner Join 2m Equi Join 1m Visual Explanation of Right Outer Join 2m Demo: Union Operators 3m Correlated Subqueries 1m Puzzle 1m Solution of Puzzle 2m Demo: Inner Join 3m Beginning Joins 1m Visual Explanation of Cross Join 2m Demo: Self Join 2m Demo: Joins with Using Keyword 3m Demo: Subqueries 5m Union Operators 1m Prerequisites 1m Introduction 1m Visual Explanation of Left Outer Join 2m Demo: Natural Join 2m Demo: Correlated Subqueries 3m Demo: Subqueries with Aggregation Function 3m Joins vs Subqueries 2m Summary in Sixty Seconds 1m Inner Join 1m Demo: Right Outer Join 3m Joins with Using Keyword 1m Demo: Cross Join 1m Demo: Left Outer Join 3m Subqueries 1m Natural Join 1m Pop Quiz 5m Self Join 1m
MySQL Functions
Numeric Functions 0m Scalar Functions 0m Demo: Information Functions 2m Demo: Aggregate Functions 3m Demo: Miscellaneous Functions 2m Demo: Numeric Functions 4m Date/Time Functions 1m Information Functions 0m Demo: String Functions 6m String Functions 0m Control Flow Functions 1m Demo: Date/Time Functions 4m Introduction 1m Cast Functions 1m Aggregate Functions 1m Miscellaneous Functions 0m Demo: Control Flow Functions 6m Demo: Cast Functions 2m Summary in Sixty Seconds 1m
MySQL Views
Introduction 1m With Check Option 0m MySQL Views 1m Demo: Views 4m Demo: Data Security 2m Demo: With Check Option 5m Demo: Simplified Queries 1m Advantages of Views 2m Demo: DML Operations 3m Summary in Sixty Seconds 1m
Stored Procedures and Stored Functions
Introduction 1m Advantages of Stored Procedure 2m Stored Functions 1m Demo: Stored Procedures with Parameters - DML Operation 2m Demo: Stored Procedures with Parameters - Functions 2m Demo: Stored Procedures with Multiple Resultset 2m Stored Procedures 1m Demo: Stored Functions - 2 2m Stored Procedure vs Stored Function 2m Demo: Stored Procedures with Parameters - Input and Output 3m Demo: Stored Functions - 1 4m Summary in Sixty Seconds 0m Demo: Beginning Stored Procedures 3m Demo: Stored Procedures - Drop and Create 1m
Triggers and Events
Triggers 1m Demo: Before Trigger 4m Demo: Recurring Event 2m Demo: Single Time Event 2m Events 1m Summary in Sixty Seconds 0m Introduction 1m Demo: After Trigger 4m
Summary and Resources
Summary and Resources 2m
Description
Course info
Rating
(313)
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
Build Your First Data Visualization with FusionCharts
Beginner
47m
Jun 9, 2020
Foundations of Document Databases with MongoDB
Beginner
2h 28m
May 6, 2020
Build Your First Data Visualization with Google Charts
Beginner
48m
Mar 26, 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