MySQL Fundamentals Part 2
Pluralsight
Course Summary
Part 2 of the Fundamentals of MySQL series, covering stored procedures, user-defined functions, triggers and more.
-
+
Course 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.
-
+
Course Syllabus
Introduction- 2m 9s
—Introduction 2m 9sJoins, Unions and Subqueries- 1h 3m
—Introduction 1m 5s
—Prerequisites 0m 56s
—Beginning Joins 1m 25s
—Inner Join 0m 48s
—Visual Explanation of Inner Join 2m 10s
—Demo: Inner Join 3m 11s
—Outer Join 0m 41s
—Visual Explanation of Left Outer Join 1m 43s
—Demo: Left Outer Join 2m 53s
—Visual Explanation of Right Outer Join 1m 30s
—Demo: Right Outer Join 2m 59s
—Visual Explanation of Full Outer Join 1m 23s
—Demo: Full Outer Join 1m 57s
—Visual Explanation of Cross Join 1m 36s
—Demo: Cross Join 0m 58s
—Pop Quiz 4m 42s
—Equi Join 1m 12s
—Self Join 1m 14s
—Demo: Self Join 1m 51s
—Natural Join 1m 5s
—Demo: Natural Join 2m 9s
—Joins with Using Keyword 0m 33s
—Demo: Joins with Using Keyword 2m 58s
—Union Operators 0m 45s
—Demo: Union Operators 3m 23s
—Subqueries 1m 3s
—Demo: Subqueries 4m 49s
—Joins vs Subqueries 2m 29s
—Demo: Subqueries with Aggregation Function 2m 34s
—Correlated Subqueries 1m 23s
—Demo: Correlated Subqueries 3m 29s
—Puzzle 0m 47s
—Solution of Puzzle 1m 41s
—Summary in Sixty Seconds 0m 34sMySQL Functions- 36m 55sMySQL Views- 19m 19sStored Procedures and Stored Functions- 25m 23sTriggers and Events- 13m 41sSummary and Resources- 2m 18s
This course is listed under
Open Source
, Development & Implementations
, Data & Information Management
, Operating Systems
and IT Security & Architecture
Community
Related Posts: