MySQL Fundamentals Part 2

سرفصل های دوره

Part 2 of the Fundamentals of MySQL series, covering stored procedures, user-defined functions, triggers and more.

1. Introduction

1. Version Check

2. Introduction

02. Joins, Unions and Subqueries

01. Introduction

02. Prerequisites

03. Beginning Joins

04. Inner Join

05. Visual Explanation of Inner Join

06. Demo - Inner Join

07. Outer Join

08. Visual Explanation of Left Outer Join

09. Demo - Left Outer Join

10. Visual Explanation of Right Outer Join

11. Demo - Right Outer Join

12. Visual Explanation of Full Outer Join

13. Demo - Full Outer Join

14. Visual Explanation of Cross Join

15. Demo - Cross Join

16. Pop Quiz

17. Equi Join

18. Self Join

19. Demo - Self Join

20. Natural Join

21. Demo - Natural Join

22. Joins with Using Keyword

23. Demo - Joins with Using Keyword

24. Union Operators

25. Demo - Union Operators

26. Subqueries

27. Demo - Subqueries

28. Joins vs Subqueries

29. Demo - Subqueries with Aggregation Function

30. Correlated Subqueries

31. Demo - Correlated Subqueries

32. Puzzle

33. Solution of Puzzle

34. Summary in Sixty Seconds

03. MySQL Functions

01. Introduction

02. Scalar Functions

03. String Functions

04. Demo - String Functions

05. Numeric Functions

06. Demo - Numeric Functions

07. DateTime Functions

08. Demo - DateTime Functions

09. Control Flow Functions

10. Demo - Control Flow Functions

11. Cast Functions

12. Demo - Cast Functions

13. Information Functions

14. Demo - Information Functions

15. Miscellaneous Functions

16. Demo - Miscellaneous Functions

17. Aggregate Functions

18. Demo - Aggregate Functions

19. Summary in Sixty Seconds

04. MySQL Views

01. MySQL Views

02. Introduction

03. Demo - Views

04. Advantages of Views

05. Demo - Simplified Queries

06. Demo - Data Security

07. Demo - DML Operations

08. With Check Option

09. Demo - With Check Option

10. Summary in Sixty Seconds

05. Stored Procedures and Stored Functions

01. Introduction

02. Stored Procedures

03. Advantages of Stored Procedure

04. Demo - Beginning Stored Procedures

05. Demo - Stored Procedures with Multiple Resultset

06. Demo - Stored Procedures with Parameters - Functions

07. Demo - Stored Procedures with Parameters - DML Operation

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

09. Demo - Stored Procedures - Drop and Create

10. Stored Functions

11. Demo - Stored Functions - 1

12. Demo - Stored Functions - 2

13. Stored Procedure vs Stored Function

14. Summary in Sixty Seconds

6. Triggers and Events

1. Introduction

2. Triggers

3. Demo - Before Trigger

4. Demo - After Trigger

5. Events

6. Demo - Single Time Event

7. Demo - Recurring Event

8. Summary in Sixty Seconds

7. Summary and Resources

1. Summary and Resources

139,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: PluralSight