Course
Skills
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
2mins
Joins, Unions and Subqueries
65mins
- 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
35mins
- 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
20mins
Stored Procedures and Stored Functions
26mins
- 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
15mins
Summary and Resources
2mins