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
- 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
- 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
- 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
About the author
Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 21 years of hands-on experience. He holds a Master of Science degree and numerous database certifications. Pinal has authored 14 SQL Server database books and 52 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,600 database tech articles on his blog at https://blog.sqlauthority.com.