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
(321)
Level
Intermediate
Updated
Feb 10, 2020
Duration
2h 42m
Table of contents
Introduction
Introduction 2m
Joins, Unions and Subqueries
Introduction 1m Prerequisites 1m Beginning Joins 1m Inner Join 1m Visual Explanation of Inner Join 2m Demo: Inner Join 3m Outer Join 1m Visual Explanation of Left Outer Join 2m Demo: Left Outer Join 3m Visual Explanation of Right Outer Join 2m Demo: Right Outer Join 3m Visual Explanation of Full Outer Join 1m Demo: Full Outer Join 2m Visual Explanation of Cross Join 2m Demo: Cross Join 1m Pop Quiz 5m Equi Join 1m Self Join 1m Demo: Self Join 2m Natural Join 1m Demo: Natural Join 2m Joins with Using Keyword 1m Demo: Joins with Using Keyword 3m Union Operators 1m Demo: Union Operators 3m Subqueries 1m Demo: Subqueries 5m Joins vs Subqueries 2m Demo: Subqueries with Aggregation Function 3m Correlated Subqueries 1m Demo: Correlated Subqueries 3m Puzzle 1m Solution of Puzzle 2m Summary in Sixty Seconds 1m
MySQL Functions
Introduction 1m Scalar Functions 0m String Functions 0m Demo: String Functions 6m Numeric Functions 0m Demo: Numeric Functions 4m Date/Time Functions 1m Demo: Date/Time Functions 4m Control Flow Functions 1m Demo: Control Flow Functions 6m Cast Functions 1m Demo: Cast Functions 2m Information Functions 0m Demo: Information Functions 2m Miscellaneous Functions 0m Demo: Miscellaneous Functions 2m Aggregate Functions 1m Demo: Aggregate Functions 3m Summary in Sixty Seconds 1m
MySQL Views
MySQL Views 1m Introduction 1m Demo: Views 4m Advantages of Views 2m Demo: Simplified Queries 1m Demo: Data Security 2m Demo: DML Operations 3m With Check Option 0m Demo: With Check Option 5m Summary in Sixty Seconds 1m
Stored Procedures and Stored Functions
Introduction 1m Stored Procedures 1m Advantages of Stored Procedure 2m Demo: Beginning Stored Procedures 3m Demo: Stored Procedures with Multiple Resultset 2m Demo: Stored Procedures with Parameters - Functions 2m Demo: Stored Procedures with Parameters - DML Operation 2m Demo: Stored Procedures with Parameters - Input and Output 3m Demo: Stored Procedures - Drop and Create 1m Stored Functions 1m Demo: Stored Functions - 1 4m Demo: Stored Functions - 2 2m Stored Procedure vs Stored Function 2m Summary in Sixty Seconds 0m
Triggers and Events
Introduction 1m Triggers 1m Demo: Before Trigger 4m Demo: After Trigger 4m Events 1m Demo: Single Time Event 2m Demo: Recurring Event 2m Summary in Sixty Seconds 0m
Summary and Resources
Summary and Resources 2m
Description
Course info
Rating
(321)
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 ChartBlocks
Beginner
35m
Dec 1, 2020
Storing and Managing Data with Postgres on Heroku
Intermediate
2h 26m
Sep 30, 2020
Open Source Cloud: Executive Briefing
Beginner
25m
Aug 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