» » Pluralsight.com - MySQL Fundamentals Part 2



Information of news
4-09-2013, 17:54

Pluralsight.com - MySQL Fundamentals Part 2

Category: Tutorials

Pluralsight.com - MySQL Fundamentals Part 2

Pluralsight.com - MySQL Fundamentals Part 2
English | 87 WebRips (MP4) + Workfiles (PDF, SQL) | Size: 456.70 MB






Introduction 00:02:09
Introduction 02:09

Joins, Unions and Subqueries 01:03:56
Introduction 01:05
Prerequisites 00:56
Beginning Joins 01:25
Inner Join 00:48
Visual Explanation of Inner Join 02:10
Demo: Inner Join 03:11
Outer Join 00:41
Visual Explanation of Left Outer Join 01:43
Demo: Left Outer Join 02:53
Visual Explanation of Right Outer Join 01:30
Demo: Right Outer Join 02:59
Visual Explanation of Full Outer Join 01:23
Demo: Full Outer Join 01:57
Visual Explanation of Cross Join 01:36
Demo: Cross Join 00:58
Pop Quiz 04:42
Equi Join 01:12
Self Join 01:14
Demo: Self Join 01:51
Natural Join 01:05
Demo: Natural Join 02:09
Joins with Using Keyword 00:33
Demo: Joins with Using Keyword 02:58
Union Operators 00:45
Demo: Union Operators 03:23
Subqueries 01:03
Demo: Subqueries 04:49
Joins vs Subqueries 02:29
Demo: Subqueries with Aggregation Function 02:34
Correlated Subqueries 01:23
Demo: Correlated Subqueries 03:29
Puzzle 00:47
Solution of Puzzle 01:41
Summary in Sixty Seconds 00:34

MySQL Functions 00:36:55
Introduction 01:07
Scalar Functions 00:28
String Functions 00:28
Demo: String Functions 06:14
Numeric Functions 00:28
Demo: Numeric Functions 04:14
Date/Time Functions 00:42
Demo: Date/Time Functions 04:02
Control Flow Functions 00:38
Demo: Control Flow Functions 06:26
Cast Functions 00:35
Demo: Cast Functions 02:08
Information Functions 00:29
Demo: Information Functions 01:41
Miscellaneous Functions 00:28
Demo: Miscellaneous Functions 02:25
Aggregate Functions 00:59
Demo: Aggregate Functions 02:53
Summary in Sixty Seconds 00:30

MySQL Views 00:19:19
MySQL Views 01:04
Introduction 00:58
Demo: Views 03:48
Advantages of Views 01:57
Demo: Simplified Queries 01:15
Demo: Data Security 01:59
Demo: DML Operations 02:45
With Check Option 00:27
Demo: With Check Option 04:32
Summary in Sixty Seconds 00:34

Stored Procedures and Stored Functions 00:25:23
Introduction 00:59
Stored Procedures 00:43
Advantages of Stored Procedure 01:42
Demo: Beginning Stored Procedures 02:31
Demo: Stored Procedures with Multiple Resultset 01:41
Demo: Stored Procedures with Parameters - Functions 01:39
Demo: Stored Procedures with Parameters - DML Operation 02:25
Demo: Stored Procedures with Parameters - Input and Output 03:02
Demo: Stored Procedures - Drop and Create 01:16
Stored Functions 00:37
Demo: Stored Functions - 1 04:29
Demo: Stored Functions - 2 02:19
Stored Procedure vs Stored Function 01:33
Summary in Sixty Seconds 00:27

Triggers and Events 00:13:41
Introduction 00:50
Triggers 00:42
Demo: Before Trigger 03:42
Demo: After Trigger 03:37
Events 00:32
Demo: Single Time Event 02:10
Demo: Recurring Event 01:40
Summary in Sixty Seconds 00:28

Summary and Resources 00:02:18
Summary and Resources 02:18



Link Download


Buy Premium To Support Me & Get Resumable Support & Fastest Speed


uploaded


Rapidgator.net
Site BBcode/HTML Code:

Tags to an Article: Pluralsight, com, MySQL, Fundamentals, Part

Dear visitor, you went to the site as unregistered user.
We recommend you Sign up or Login to website under your name.
Information
Would you like to leave your comment? Please Login to your account to leave comments. Don't have an account? You can create a free account now.