- Course
MySQL Fundamentals Part 2
Part 2 of the Fundamentals of MySQL series, covering stored procedures, user-defined functions, triggers and more.
Beginner
- Course
MySQL Fundamentals Part 2
Part 2 of the Fundamentals of MySQL series, covering stored procedures, user-defined functions, triggers and more.
Beginner
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Data
What you'll learn
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.
MySQL Fundamentals Part 2
Beginner
Table of contents
-
Introduction | 1m 5s
-
Prerequisites | 56s
-
Beginning Joins | 1m 25s
-
Inner Join | 48s
-
Visual Explanation of Inner Join | 2m 9s
-
Demo: Inner Join | 3m 10s
-
Outer Join | 41s
-
Visual Explanation of Left Outer Join | 1m 42s
-
Demo: Left Outer Join | 2m 52s
-
Visual Explanation of Right Outer Join | 1m 30s
-
Demo: Right Outer Join | 2m 58s
-
Visual Explanation of Full Outer Join | 1m 22s
-
Demo: Full Outer Join | 1m 57s
-
Visual Explanation of Cross Join | 1m 35s
-
Demo: Cross Join | 58s
-
Pop Quiz | 4m 42s
-
Equi Join | 1m 11s
-
Self Join | 1m 13s
-
Demo: Self Join | 1m 51s
-
Natural Join | 1m 4s
-
Demo: Natural Join | 2m 8s
-
Joins with Using Keyword | 33s
-
Demo: Joins with Using Keyword | 2m 58s
-
Union Operators | 44s
-
Demo: Union Operators | 3m 23s
-
Subqueries | 1m 3s
-
Demo: Subqueries | 4m 49s
-
Joins vs Subqueries | 2m 29s
-
Demo: Subqueries with Aggregation Function | 2m 33s
-
Correlated Subqueries | 1m 23s
-
Demo: Correlated Subqueries | 3m 28s
-
Puzzle | 47s
-
Solution of Puzzle | 1m 41s
-
Summary in Sixty Seconds | 33s
Pinal Dave is a Pluralsight Developer Evangelist.
