-
Course
- Data
MySQL Fundamentals Part 2
Part 2 of the Fundamentals of MySQL series, covering stored procedures, user-defined functions, triggers and more.
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.
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