MySQL Fundamentals Part 2

Focused View

Pinal Dave

2:43:07

75 View

1. Introduction

1. Version Check.mp4

00:15

2. Introduction.mp4

02:07

02. Joins, Unions and Subqueries

01. Introduction.mp4

01:05

02. Prerequisites.mp4

00:56

03. Beginning Joins.mp4

01:25

04. Inner Join.mp4

00:48

05. Visual Explanation of Inner Join.mp4

02:09

06. Demo - Inner Join.mp4

03:10

07. Outer Join.mp4

00:41

08. Visual Explanation of Left Outer Join.mp4

01:42

09. Demo - Left Outer Join.mp4

02:52

10. Visual Explanation of Right Outer Join.mp4

01:30

11. Demo - Right Outer Join.mp4

02:58

12. Visual Explanation of Full Outer Join.mp4

01:22

13. Demo - Full Outer Join.mp4

01:57

14. Visual Explanation of Cross Join.mp4

01:35

15. Demo - Cross Join.mp4

00:58

16. Pop Quiz.mp4

04:42

17. Equi Join.mp4

01:11

18. Self Join.mp4

01:13

19. Demo - Self Join.mp4

01:51

20. Natural Join.mp4

01:04

21. Demo - Natural Join.mp4

02:08

22. Joins with Using Keyword.mp4

00:33

23. Demo - Joins with Using Keyword.mp4

02:58

24. Union Operators.mp4

00:44

25. Demo - Union Operators.mp4

03:23

26. Subqueries.mp4

01:03

27. Demo - Subqueries.mp4

04:49

28. Joins vs Subqueries.mp4

02:29

29. Demo - Subqueries with Aggregation Function.mp4

02:33

30. Correlated Subqueries.mp4

01:23

31. Demo - Correlated Subqueries.mp4

03:28

32. Puzzle.mp4

00:47

33. Solution of Puzzle.mp4

01:41

34. Summary in Sixty Seconds.mp4

00:33

03. MySQL Functions

01. Introduction.mp4

01:07

02. Scalar Functions.mp4

00:28

03. String Functions.mp4

00:27

04. Demo - String Functions.mp4

06:14

05. Numeric Functions.mp4

00:27

06. Demo - Numeric Functions.mp4

04:13

07. DateTime Functions.mp4

00:42

08. Demo - DateTime Functions.mp4

04:01

09. Control Flow Functions.mp4

00:37

10. Demo - Control Flow Functions.mp4

06:25

11. Cast Functions.mp4

00:34

12. Demo - Cast Functions.mp4

02:07

13. Information Functions.mp4

00:29

14. Demo - Information Functions.mp4

01:40

15. Miscellaneous Functions.mp4

00:27

16. Demo - Miscellaneous Functions.mp4

02:24

17. Aggregate Functions.mp4

00:58

18. Demo - Aggregate Functions.mp4

02:52

19. Summary in Sixty Seconds.mp4

00:30

04. MySQL Views

01. MySQL Views.mp4

01:04

02. Introduction.mp4

00:58

03. Demo - Views.mp4

03:47

04. Advantages of Views.mp4

01:57

05. Demo - Simplified Queries.mp4

01:15

06. Demo - Data Security.mp4

01:58

07. Demo - DML Operations.mp4

02:45

08. With Check Option.mp4

00:26

09. Demo - With Check Option.mp4

04:31

10. Summary in Sixty Seconds.mp4

00:33

05. Stored Procedures and Stored Functions

01. Introduction.mp4

00:58

02. Stored Procedures.mp4

00:42

03. Advantages of Stored Procedure.mp4

01:42

04. Demo - Beginning Stored Procedures.mp4

02:31

05. Demo - Stored Procedures with Multiple Resultset.mp4

01:40

06. Demo - Stored Procedures with Parameters - Functions.mp4

01:38

07. Demo - Stored Procedures with Parameters - DML Operation.mp4

02:24

08. Demo - Stored Procedures with Parameters - Input and Output.mp4

03:01

09. Demo - Stored Procedures - Drop and Create.mp4

01:15

10. Stored Functions.mp4

00:36

11. Demo - Stored Functions - 1.mp4

04:28

12. Demo - Stored Functions - 2.mp4

02:18

13. Stored Procedure vs Stored Function.mp4

01:33

14. Summary in Sixty Seconds.mp4

00:27

6. Triggers and Events

1. Introduction.mp4

00:50

2. Triggers.mp4

00:42

3. Demo - Before Trigger.mp4

03:42

4. Demo - After Trigger.mp4

03:36

5. Events.mp4

00:31

6. Demo - Single Time Event.mp4

02:10

7. Demo - Recurring Event.mp4

01:39

8. Summary in Sixty Seconds.mp4

00:27

7. Summary and Resources

1. Summary and Resources.mp4

02:18

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

MySQL

Pinal Dave

Instructor's Courses

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 45 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,500 database tech articles on his blog at https://blog.sqlauthority.com.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.