Pluralsight Path MySQL (2020)

Files Included :

1 Course Overview.mp4 (3.21 MB)
MP4
1 Introduction.mp4 (5.41 MB)
MP4
2 The Relational Model.mp4 (8.6 MB)
MP4
3 Summary.mp4 (359.8 KB)
MP4
1 Introduction.mp4 (4.76 MB)
MP4
2 Basic SQL Commands - SELECT.mp4 (1.5 MB)
MP4
3 Basic SQL Commands - INSERT.mp4 (3.66 MB)
MP4
4 Basic SQL Commands - UPDATE.mp4 (2.58 MB)
MP4
5 Basic SQL Commands - DELETE.mp4 (2.98 MB)
MP4
6 Course Housekeeping.mp4 (4.03 MB)
MP4
7 Summary.mp4 (678.06 KB)
MP4
01 Introduction.mp4 (5.16 MB)
MP4
02 Demo - SELECT.mp4 (3.7 MB)
MP4
03 The SELECT List.mp4 (2.73 MB)
MP4
04 SELECT List Wildcard ().mp4 (1.97 MB)
MP4
05 The FROM Clause.mp4 (5.66 MB)
MP4
06 Demo - FROM Clause.mp4 (9.02 MB)
MP4
07 How to Constrain the Result Set.mp4 (919.52 KB)
MP4
08 DISTINCT and NOT DISTINCT.mp4 (3.28 MB)
MP4
09 Demo - Distinct.mp4 (9.15 MB)
MP4
10 Summary.mp4 (591.27 KB)
MP4
01 The WHERE Clause.mp4 (4.35 MB)
MP4
02 Demo - WHERE Clause.mp4 (2.9 MB)
MP4
03 Boolean Operators.mp4 (2.44 MB)
MP4
04 The AND Keyword.mp4 (1.7 MB)
MP4
05 Demo - AND.mp4 (6.01 MB)
MP4
06 The OR Keyword.mp4 (1.5 MB)
MP4
07 Demo - OR.mp4 (7.49 MB)
MP4
08 Other Boolean Operators.mp4 (279.85 KB)
MP4
09 BETWEEN.mp4 (2.16 MB)
MP4
10 Demo - BETWEEN.mp4 (8.17 MB)
MP4
11 LIKE.mp4 (1.92 MB)
MP4
12 Demo - LIKE.mp4 (9.79 MB)
MP4
13 IN.mp4 (1.56 MB)
MP4
14 Demo - IN.mp4 (8.28 MB)
MP4
15 IS.mp4 (1.73 MB)
MP4
16 IS NOT.mp4 (1.47 MB)
MP4
17 Demo - IS AND IS NOT.mp4 (24.67 MB)
MP4
18 Summary.mp4 (866.89 KB)
MP4
01 Introduction.mp4 (1.27 MB)
MP4
02 ORDER BY.mp4 (1.94 MB)
MP4
03 Demo - ORDER BY.mp4 (4.26 MB)
MP4
04 Set Functions.mp4 (4.11 MB)
MP4
05 Demo - Set Functions.mp4 (20.44 MB)
MP4
06 Set Function And Qualifiers.mp4 (1.97 MB)
MP4
07 Demo - Set Function And Qualifiers.mp4 (5.31 MB)
MP4
08 GROUP BY.mp4 (3.06 MB)
MP4
09 Demo - GROUP BY.mp4 (8.38 MB)
MP4
10 HAVING.mp4 (2.61 MB)
MP4
11 Demo - HAVING.mp4 (12.76 MB)
MP4
12 Summary.mp4 (770.88 KB)
MP4
01 Introduction.mp4 (1.55 MB)
MP4
02 CROSS JOIN.mp4 (1.52 MB)
MP4
03 Demo - CROSS JOIN.mp4 (4.95 MB)
MP4
04 INNER JOIN.mp4 (2.74 MB)
MP4
05 Demo - INNER JOIN.mp4 (6.31 MB)
MP4
06 OUTER JOINs.mp4 (1.07 MB)
MP4
07 LEFT OUTER JOIN.mp4 (1.78 MB)
MP4
08 Demo - LEFT OUTER JOIN.mp4 (3.73 MB)
MP4
09 RIGHT OUTER JOIN.mp4 (1.48 MB)
MP4
10 Demo - RIGHT OUTER JOIN.mp4 (8.06 MB)
MP4
11 FULL OUTER JOIN.mp4 (2.37 MB)
MP4
12 Demo - FULL OUTER JOIN.mp4 (6.19 MB)
MP4
13 SELF JOIN.mp4 (1.73 MB)
MP4
14 Summary.mp4 (530.19 KB)
MP4
01 Introduction.mp4 (1.81 MB)
MP4
02 INSERT.mp4 (2.51 MB)
MP4
03 Demo - INSERT.mp4 (17.06 MB)
MP4
04 BULK INSERT.mp4 (2.38 MB)
MP4
05 Demo - BULK INSERT.mp4 (4.16 MB)
MP4
06 UPDATE.mp4 (1.82 MB)
MP4
07 Demo - UPDATE.mp4 (10.66 MB)
MP4
08 DELETE.mp4 (2.1 MB)
MP4
09 Demo - DELETE.mp4 (6.68 MB)
MP4
10 Summary.mp4 (379.51 KB)
MP4
01 Introduction.mp4 (1.35 MB)
MP4
02 CREATE DATABASE.mp4 (2.87 MB)
MP4
03 Demo - CREATE DATABASE.mp4 (3.04 MB)
MP4
04 CREATE TABLE.mp4 (5.79 MB)
MP4
05 Demo - CREATE TABLE.mp4 (8.19 MB)
MP4
06 NULL Values.mp4 (4.08 MB)
MP4
07 PRIMARY KEY.mp4 (1.85 MB)
MP4
08 CONSTRAINT.mp4 (2.53 MB)
MP4
09 ALTER TABLE.mp4 (3.11 MB)
MP4
10 DROP TABLE.mp4 (1.19 MB)
MP4
11 Demo - CREATE TABLE.mp4 (22.48 MB)
MP4
12 Summary.mp4 (1.62 MB)
MP4
1 Version Check.mp4 (479.83 KB)
MP4
2 Introduction.mp4 (3.19 MB)
MP4
1 Introduction.mp4 (1.36 MB)
MP4
2 Downloads.mp4 (1.24 MB)
MP4
3 Demo - Installation.mp4 (4.85 MB)
MP4
4 Demo - Installation Part 2.mp4 (8.77 MB)
MP4
5 MySQL Workbench.mp4 (1.07 MB)
MP4
6 Demo - MySQL Workbench.mp4 (7.37 MB)
MP4
7 MySQL Command Line Editor.mp4 (838.38 KB)
MP4
8 Demo - MySQL Command Line Editor.mp4 (2.52 MB)
MP4
9 Summary in Sixty Seconds.mp4 (767.99 KB)
MP4
1 Introduction.mp4 (1.41 MB)
MP4
2 ClientServer System.mp4 (2.76 MB)
MP4
3 Web Application Server.mp4 (3.19 MB)
MP4
4 History of Relational Database Model.mp4 (1.75 MB)
MP4
5 Relational Database Model Concepts.mp4 (4.41 MB)
MP4
6 Relational Database Model Keys.mp4 (7.48 MB)
MP4
7 Column Definition.mp4 (3.94 MB)
MP4
8 Summary in Sixty Seconds.mp4 (946.99 KB)
MP4
01 Introduction.mp4 (1.32 MB)
MP4
02 MySQL Workbench Features.mp4 (3.46 MB)
MP4
03 Starting MySQL Workbench.mp4 (3.56 MB)
MP4
04 Demo - Opening a New Connection.mp4 (5.72 MB)
MP4
05 Demo - Manage Connections.mp4 (7.14 MB)
MP4
06 Demo - Selecting Data.mp4 (2.06 MB)
MP4
07 Demo - Updating Data.mp4 (10.78 MB)
MP4
08 Demo - Open and Execute SQL File.mp4 (4.4 MB)
MP4
09 Demo - Inserting Data.mp4 (3.24 MB)
MP4
10 Demo - Deleting Data.mp4 (2.1 MB)
MP4
11 Demo - View and Edit Column Definition.mp4 (7.89 MB)
MP4
12 Demo - Creating Snippet.mp4 (3.26 MB)
MP4
13 Demo - Output Window.mp4 (1.89 MB)
MP4
14 Demo - Data Modeling.mp4 (4.7 MB)
MP4
15 Demo - Server Administration.mp4 (7.19 MB)
MP4
16 Demo - Workbench Central.mp4 (7.35 MB)
MP4
17 Summary in Sixty Seconds.mp4 (1.34 MB)
MP4
01 Introduction.mp4 (1.66 MB)
MP4
02 Basics of SELECT statement.mp4 (2.79 MB)
MP4
03 Setup for demo.mp4 (1.12 MB)
MP4
04 Beginning SELECT statement.mp4 (4.31 MB)
MP4
05 Demo - Select without FROM clause.mp4 (4.31 MB)
MP4
06 Demo - Retrieve all the data from table.mp4 (4.42 MB)
MP4
07 Demo - Order data based on a column.mp4 (4.63 MB)
MP4
08 Demo - Retrieve selected columns from table.mp4 (3.43 MB)
MP4
09 Demo - Retrieve selected columns and rows.mp4 (6.7 MB)
MP4
10 Demo - Bringing it together.mp4 (7.35 MB)
MP4
11 Demo - Retrieve empty resultset.mp4 (1.83 MB)
MP4
12 Working with Arithmetic Expressions.mp4 (2.78 MB)
MP4
13 Demo - Arithmetic Expressions.mp4 (8.61 MB)
MP4
14 Select statement and other functions.mp4 (929.11 KB)
MP4
15 Demo - Select statement and other functions.mp4 (6.12 MB)
MP4
16 Demo - Select statement and string functions.mp4 (10.24 MB)
MP4
17 Demo - Select statement and date functions.mp4 (15.12 MB)
MP4
18 Demo - Select statement and distinct rows.mp4 (3.75 MB)
MP4
19 Introducing WHERE clause.mp4 (1.71 MB)
MP4
20 Select statement and Comparision Operators.mp4 (1.39 MB)
MP4
21 Demo - Comparision Operators.mp4 (12.72 MB)
MP4
22 Select statement and Logical Operators.mp4 (1.85 MB)
MP4
23 Demo - Logical Operators.mp4 (16.82 MB)
MP4
24 Select statement and WHERE clause.mp4 (3.16 MB)
MP4
25 Demo - Using Between in WHERE clause.mp4 (12.95 MB)
MP4
26 Demo - Using Like in WHERE clause.mp4 (11.32 MB)
MP4
27 Select statement and ORDER BY clause.mp4 (1.5 MB)
MP4
28 Demo - Select statement and.mp4 (9.62 MB)
MP4
29 Retrieving limited rows.mp4 (2.65 MB)
MP4
30 Demo - Retrieving limited rows.mp4 (5.16 MB)
MP4
31 Summary in Sixty Seconds.mp4 (1.38 MB)
MP4
1 Introduction.mp4 (1.16 MB)
MP4
2 Insert Statement.mp4 (1.6 MB)
MP4
3 Demo - Insert Statement.mp4 (26.71 MB)
MP4
4 Update Statement.mp4 (1.18 MB)
MP4
5 Demo - Update Statement.mp4 (15.19 MB)
MP4
6 Delete Statement.mp4 (922.4 KB)
MP4
7 Demo - Delete Statement.mp4 (9.83 MB)
MP4
8 Summary in Sixty Seconds.mp4 (936.69 KB)
MP4
1 Final Words.mp4 (2.7 MB)
MP4
1 Version Check.mp4 (484.95 KB)
MP4
2 Introduction.mp4 (3.12 MB)
MP4
01 Introduction.mp4 (1.66 MB)
MP4
02 Prerequisites.mp4 (1.43 MB)
MP4
03 Beginning Joins.mp4 (2 MB)
MP4
04 Inner Join.mp4 (1.44 MB)
MP4
05 Visual Explanation of Inner Join.mp4 (3.24 MB)
MP4
06 Demo - Inner Join.mp4 (5.82 MB)
MP4
07 Outer Join.mp4 (985.59 KB)
MP4
08 Visual Explanation of Left Outer Join.mp4 (2.54 MB)
MP4
09 Demo - Left Outer Join.mp4 (5.32 MB)
MP4
10 Visual Explanation of Right Outer Join.mp4 (2.02 MB)
MP4
11 Demo - Right Outer Join.mp4 (5.62 MB)
MP4
12 Visual Explanation of Full Outer Join.mp4 (2.12 MB)
MP4
13 Demo - Full Outer Join.mp4 (4.24 MB)
MP4
14 Visual Explanation of Cross Join.mp4 (3.25 MB)
MP4
15 Demo - Cross Join.mp4 (1.83 MB)
MP4
16 Pop Quiz.mp4 (9.37 MB)
MP4
17 Equi Join.mp4 (1.71 MB)
MP4
18 Self Join.mp4 (1.72 MB)
MP4
19 Demo - Self Join.mp4 (3.42 MB)
MP4
20 Natural Join.mp4 (1.56 MB)
MP4
21 Demo - Natural Join.mp4 (4.39 MB)
MP4
22 Joins with Using Keyword.mp4 (873.55 KB)
MP4
23 Demo - Joins with Using Keyword.mp4 (5.92 MB)
MP4
24 Union Operators.mp4 (1.21 MB)
MP4
25 Demo - Union Operators.mp4 (6.21 MB)
MP4
26 Subqueries.mp4 (1.46 MB)
MP4
27 Demo - Subqueries.mp4 (10.81 MB)
MP4
28 Joins vs Subqueries.mp4 (3.97 MB)
MP4
29 Demo - Subqueries with Aggregation Function.mp4 (5.94 MB)
MP4
30 Correlated Subqueries.mp4 (2.11 MB)
MP4
31 Demo - Correlated Subqueries.mp4 (7.38 MB)
MP4
32 Puzzle.mp4 (988.13 KB)
MP4
33 Solution of Puzzle.mp4 (3.55 MB)
MP4
34 Summary in Sixty Seconds.mp4 (879.15 KB)
MP4
01 Introduction.mp4 (1.6 MB)
MP4
02 Scalar Functions.mp4 (804.44 KB)
MP4
03 String Functions.mp4 (1.32 MB)
MP4
04 Demo - String Functions.mp4 (14.49 MB)
MP4
05 Numeric Functions.mp4 (1.14 MB)
MP4
06 Demo - Numeric Functions.mp4 (8.21 MB)
MP4
07 DateTime Functions.mp4 (2.23 MB)
MP4
08 Demo - DateTime Functions.mp4 (8.32 MB)
MP4
09 Control Flow Functions.mp4 (1.08 MB)
MP4
10 Demo - Control Flow Functions.mp4 (12.15 MB)
MP4
11 Cast Functions.mp4 (816.35 KB)
MP4
12 Demo - Cast Functions.mp4 (4.21 MB)
MP4
13 Information Functions.mp4 (1.13 MB)
MP4
14 Demo - Information Functions.mp4 (3.54 MB)
MP4
15 Miscellaneous Functions.mp4 (1.22 MB)
MP4
16 Demo - Miscellaneous Functions.mp4 (4.27 MB)
MP4
17 Aggregate Functions.mp4 (1.98 MB)
MP4
18 Demo - Aggregate Functions.mp4 (6.18 MB)
MP4
19 Summary in Sixty Seconds.mp4 (889.63 KB)
MP4
01 MySQL Views.mp4 (1.24 MB)
MP4
02 Introduction.mp4 (1.7 MB)
MP4
03 Demo - Views.mp4 (7.71 MB)
MP4
04 Advantages of Views.mp4 (3.37 MB)
MP4
05 Demo - Simplified Queries.mp4 (3.11 MB)
MP4
06 Demo - Data Security.mp4 (4.27 MB)
MP4
07 Demo - DML Operations.mp4 (5.81 MB)
MP4
08 With Check Option.mp4 (770.25 KB)
MP4
09 Demo - With Check Option.mp4 (10.17 MB)
MP4
10 Summary in Sixty Seconds.mp4 (940.03 KB)
MP4
01 Introduction.mp4 (1.25 MB)
MP4
02 Stored Procedures.mp4 (1.37 MB)
MP4
03 Advantages of Stored Procedure.mp4 (2.82 MB)
MP4
04 Demo - Beginning Stored Procedures.mp4 (4.46 MB)
MP4
05 Demo - Stored Procedures with Multiple Resultset.mp4 (2.85 MB)
MP4
06 Demo - Stored Procedures with Parameters - Functions.mp4 (3.02 MB)
MP4
07 Demo - Stored Procedures with Parameters - DML Operation.mp4 (5.47 MB)
MP4
08 Demo - Stored Procedures with Parameters - Input and Output.mp4 (6.23 MB)
MP4
09 Demo - Stored Procedures - Drop and Create.mp4 (2.29 MB)
MP4
10 Stored Functions.mp4 (1.17 MB)
MP4
11 Demo - Stored Functions - 1.mp4 (9.23 MB)
MP4
12 Demo - Stored Functions - 2.mp4 (5.24 MB)
MP4
13 Stored Procedure vs Stored Function.mp4 (2.23 MB)
MP4
14 Summary in Sixty Seconds.mp4 (739.51 KB)
MP4
1 Introduction.mp4 (1.01 MB)
MP4
2 Triggers.mp4 (1.13 MB)
MP4
3 Demo - Before Trigger.mp4 (8.24 MB)
MP4
4 Demo - After Trigger.mp4 (8.63 MB)
MP4
5 Events.mp4 (1004.79 KB)
MP4
6 Demo - Single Time Event.mp4 (4.6 MB)
MP4
7 Demo - Recurring Event.mp4 (3.75 MB)
MP4
8 Summary in Sixty Seconds.mp4 (707.51 KB)
MP4
1 Summary and Resources.mp4 (3.55 MB)
MP4
1 Introduction.mp4 (8.09 MB)
MP4
01 Introduction.mp4 (961.64 KB)
MP4
02 MySQL Workbench Editions.mp4 (1.68 MB)
MP4
03 Demo - Installation and Setup.mp4 (2.5 MB)
MP4
04 Demo - Setup New Connection.mp4 (5.36 MB)
MP4
05 Demo - Advanced MySQL Connection.mp4 (5.21 MB)
MP4
06 Demo - Duplicate MySQL Connections.mp4 (5.46 MB)
MP4
07 Demo - Impact of Settings on Query.mp4 (4.24 MB)
MP4
08 Demo - Navigator.mp4 (1.8 MB)
MP4
09 Demo - Server Status.mp4 (9.11 MB)
MP4
10 Demo - Client Connection.mp4 (4.88 MB)
MP4
11 Demo - Users and Previleges.mp4 (10.57 MB)
MP4
12 Demo - Create New User.mp4 (4.13 MB)
MP4
13 Demo - Status and System Variables.mp4 (6.86 MB)
MP4
14 Demo - Data Export.mp4 (8.38 MB)
MP4
15 Demo - Data ImportRestore.mp4 (3.83 MB)
MP4
16 Demo - StartupShutdown.mp4 (2.63 MB)
MP4
17 Demo - Server Logs.mp4 (9.09 MB)
MP4
18 Demo - Options File.mp4 (7.24 MB)
MP4
19 Summary in Sixty Seconds.mp4 (1.82 MB)
MP4
01 Introduction.mp4 (865.85 KB)
MP4
02 Demo - Opening SQL Editor.mp4 (2.18 MB)
MP4
03 Demo - Opening SQL Queries File.mp4 (1.82 MB)
MP4
04 Demo - Query Menu - Execute.mp4 (9.41 MB)
MP4
05 Demo - Query Menu - Explain.mp4 (12.37 MB)
MP4
06 Demo - Query Menu - Stop Script Exectuion on Errors.mp4 (6.12 MB)
MP4
07 Demo - Query Menu - Limit Rows.mp4 (5.58 MB)
MP4
08 Demo - Query Menu - Reconnect to Server.mp4 (1.9 MB)
MP4
09 Demo - Query Menu - Transactions.mp4 (9.27 MB)
MP4
10 Demo - Toolbar of Resultset.mp4 (16.97 MB)
MP4
11 Demo - Features of Resultset Panel.mp4 (8.63 MB)
MP4
12 Demo - Toolbar of SQL Query Tab.mp4 (11.13 MB)
MP4
13 Demo - Contex Help.mp4 (4.2 MB)
MP4
14 Demo - Snippets.mp4 (6.77 MB)
MP4
15 Demo - Auto Complete.mp4 (3.31 MB)
MP4
16 Summary in Sixty Seconds.mp4 (1.29 MB)
MP4
01 Introduction.mp4 (1.71 MB)
MP4
02 Demo - Create EER Model by Reverse Engineering.mp4 (17.31 MB)
MP4
03 Demo - EER Diagram.mp4 (13.82 MB)
MP4
04 Demo - Vertical Menu.mp4 (5.95 MB)
MP4
05 Demo - MySQL Model and History.mp4 (7.74 MB)
MP4
06 Demo - Model Templates.mp4 (6.05 MB)
MP4
07 Demo - Forward Engineering.mp4 (5.45 MB)
MP4
08 Demo - Schema Transfer.mp4 (3.43 MB)
MP4
09 Demo - Schema Compare.mp4 (8.3 MB)
MP4
10 Demo - Tools and Utilities.mp4 (7.22 MB)
MP4
11 Summary in Sixty Seconds.mp4 (1.56 MB)
MP4
01 Introduction.mp4 (1.31 MB)
MP4
02 Demo - Workbench Preferences Screen.mp4 (1.4 MB)
MP4
03 Demo - General Preferences.mp4 (8.28 MB)
MP4
04 Demo - Administrator Preferences.mp4 (1.89 MB)
MP4
05 Demo - SQL Editor Preferences.mp4 (4.45 MB)
MP4
06 Demo - SQL Queries Preferences.mp4 (9.06 MB)
MP4
07 Demo - Model Preferences.mp4 (3.97 MB)
MP4
08 Demo - Diagram Preferences.mp4 (3.73 MB)
MP4
09 Demo - Appearance and Theme Preferences.mp4 (4.43 MB)
MP4
10 Summary in Sixty Seconds.mp4 (1.15 MB)
MP4
1 Introduction.mp4 (561.04 KB)
MP4
2 Demo - MySQL Workbench Shortcuts.mp4 (7.87 MB)
MP4
3 Keyboard Shortcuts.mp4 (6.56 MB)
MP4
4 Final Note.mp4 (556.14 KB)
MP4
1 Version Check.mp4 (365.17 KB)
MP4
2 Introduction.mp4 (13.68 MB)
MP4
3 Course Outline.mp4 (4.91 MB)
MP4
01 Introduction.mp4 (1.36 MB)
MP4
02 Notes on mysqldump.mp4 (1.91 MB)
MP4
03 Scenario Setup.mp4 (3.58 MB)
MP4
04 Scenario 1 - Backup Single Database.mp4 (1.29 MB)
MP4
05 Demo 1 - Backup Single Database.mp4 (7.83 MB)
MP4
06 Scenario 2 - Backup Multiple Databases.mp4 (2.41 MB)
MP4
07 Demo 2 - Backup Multiple Databases.mp4 (4.19 MB)
MP4
08 Scenario 3 - Backup All Databases.mp4 (1.87 MB)
MP4
09 Demo 3 - Backup All Databases.mp4 (2.5 MB)
MP4
10 Scenario 4 - Backup Single Table.mp4 (1.76 MB)
MP4
11 Demo 4 - Backup Single Table.mp4 (5.68 MB)
MP4
12 Scenario 5 - Backup All Databases.mp4 (2.29 MB)
MP4
13 Demo 5 - Backup of Stored Procedure, Triggers, and Events.mp4 (6.93 MB)
MP4
14 Various Backup Options.mp4 (5.57 MB)
MP4
15 Summary.mp4 (1.39 MB)
MP4
1 Introduction.mp4 (1.25 MB)
MP4
2 Notes on Restore.mp4 (1.33 MB)
MP4
3 Script for Backup and Restore.mp4 (1.87 MB)
MP4
4 Scenario Setup.mp4 (1.7 MB)
MP4
5 Scenario 1 - Restore Single Databases.mp4 (1.36 MB)
MP4
6 Demo 1 - Restore Single Databases.mp4 (7.87 MB)
MP4
7 Scenario 2 - Restore Multiple Databases.mp4 (1.44 MB)
MP4
8 Demo 2 - Restore Multiple Databases.mp4 (4.92 MB)
MP4
9 Summary.mp4 (1.66 MB)
MP4
01 Introduction.mp4 (1.76 MB)
MP4
02 Notes on MySQL Workbench.mp4 (6.39 MB)
MP4
03 Demo - Backup Single Database.mp4 (5.61 MB)
MP4
04 Demo - Backup Multiple Databases.mp4 (4.27 MB)
MP4
05 Demo - Backup Individual Tables.mp4 (12.79 MB)
MP4
06 Demo - Backup Routines and Events.mp4 (7.06 MB)
MP4
07 Demo - Backup Database in Dump Folder.mp4 (10.25 MB)
MP4
08 Demo - Restore Database From Single File.mp4 (3.87 MB)
MP4
09 Demo - Restore Database From Dump Folder.mp4 (5.59 MB)
MP4
10 Summary.mp4 (1.17 MB)
MP4
1 Introduction.mp4 (1.18 MB)
MP4
2 Point in Time Recovery.mp4 (2.21 MB)
MP4
3 Demo - Point in Time Recovery With Log File Edit.mp4 (21.96 MB)
MP4
4 Demo - Point in Time Recovery With Timestamp.mp4 (10.69 MB)
MP4
5 Frequency of Backup.mp4 (1.84 MB)
MP4
6 Location of Backup.mp4 (1.73 MB)
MP4
7 Copy Database From One Server to Another.mp4 (3.19 MB)
MP4
8 Best Time of the Day for Backup and Restore.mp4 (1.62 MB)
MP4
9 Final Note.mp4 (3.73 MB)
MP4
1 Version Check.mp4 (356.96 KB)
MP4
2 Introduction.mp4 (3.34 MB)
MP4
01 Introduction.mp4 (2.04 MB)
MP4
02 InnoDB vs MyISAM.mp4 (6.29 MB)
MP4
03 B-Tree Index.mp4 (2.29 MB)
MP4
04 Advantages of B-Tree Index.mp4 (3.79 MB)
MP4
05 Clustered Index.mp4 (1020.03 KB)
MP4
06 Advantages of Clustered Index.mp4 (1.67 MB)
MP4
07 Disadvantages of Clustered Index.mp4 (2 MB)
MP4
08 Secondary Index.mp4 (1.03 MB)
MP4
09 Building Clustered B-Tree.mp4 (8.48 MB)
MP4
10 Building Secondary Index B-Tree.mp4 (2.16 MB)
MP4
11 InnoDB Clustered Table.mp4 (5.03 MB)
MP4
12 Hash Index.mp4 (1.88 MB)
MP4
13 Limitation of Hash Index.mp4 (2.08 MB)
MP4
14 Adaptive Hash Index.mp4 (3.01 MB)
MP4
15 Building Hash Index.mp4 (5.43 MB)
MP4
16 Other Indexes.mp4 (2.04 MB)
MP4
17 Summary in Sixty Seconds.mp4 (945.71 KB)
MP4
01 Introduction.mp4 (874.48 KB)
MP4
02 Effectiveness of Index.mp4 (1.38 MB)
MP4
03 Demo - List Indexes.mp4 (9.35 MB)
MP4
04 Demo - Basics of Indexes.mp4 (17.11 MB)
MP4
05 Demo - Order of Columns in Index.mp4 (13.8 MB)
MP4
06 Demo - Optimize OR Conditions.mp4 (24.27 MB)
MP4
07 Demo - Optimize OR Conditions - Advanced.mp4 (28.3 MB)
MP4
08 Demo - Optimize AND Conditions.mp4 (19.18 MB)
MP4
09 Demo - Optimize AND Conditions - Advanced.mp4 (9.07 MB)
MP4
10 Demo - Cover Index.mp4 (14.46 MB)
MP4
11 Demo - Clustered Index.mp4 (29.69 MB)
MP4
12 Demo - Index Hints.mp4 (20.42 MB)
MP4
13 Summary in Sixty Seconds.mp4 (944.07 KB)
MP4
1 Introduction.mp4 (1.16 MB)
MP4
2 MySQL Query Optimizer.mp4 (1.55 MB)
MP4
3 Statistics.mp4 (1.34 MB)
MP4
4 InnoDB Statistics.mp4 (3.52 MB)
MP4
5 Data and Index Fragmentation.mp4 (2.15 MB)
MP4
6 Index Maintenance.mp4 (9.28 MB)
MP4
7 Other Index Maintenance Tips.mp4 (2.77 MB)
MP4
8 Summary in Sixty Seconds.mp4 (1.09 MB)
MP4
1 Checklists.mp4 (3.94 MB)
MP4
1 Version Check.mp4 (367.91 KB)
MP4
2 Introduction.mp4 (7.31 MB)
MP4
1 Introduction.mp4 (1.36 MB)
MP4
2 Prerequisite.mp4 (1.23 MB)
MP4
3 Overheard.mp4 (1.57 MB)
MP4
4 Understanding Data Needs.mp4 (3.43 MB)
MP4
5 Demo - Setup.mp4 (2.12 MB)
MP4
6 Demo - Best Practices for Data Access.mp4 (7.21 MB)
MP4
7 Demo - Why SELECT Star () is Bad Idea.mp4 (19.37 MB)
MP4
8 Summary in Sixty Seconds.mp4 (873.55 KB)
MP4
01 Introduction.mp4 (1.53 MB)
MP4
02 Execution Path of a Query.mp4 (1.34 MB)
MP4
03 Client Protocols.mp4 (2.81 MB)
MP4
04 Query Cache.mp4 (1.37 MB)
MP4
05 Parser.mp4 (1.11 MB)
MP4
06 Preprocessor.mp4 (999.76 KB)
MP4
07 Query Optimizer.mp4 (2.46 MB)
MP4
08 Query Optimizer Responsibilities.mp4 (2.39 MB)
MP4
09 Query Optimizer Limitations.mp4 (3.69 MB)
MP4
10 Query Execution Engine and Storage.mp4 (2.97 MB)
MP4
11 Returning Result to Client.mp4 (1.86 MB)
MP4
12 Additional Notes on Query Optimizer.mp4 (1.44 MB)
MP4
13 Maximizing Query Optimizer Performance.mp4 (885.15 KB)
MP4
14 Understanding Query States.mp4 (5.03 MB)
MP4
15 Demo - Show Full Processlist.mp4 (6.11 MB)
MP4
16 Understanding Explain Command.mp4 (771.46 KB)
MP4
17 Demo - Explain Command.mp4 (11.57 MB)
MP4
18 Demo - Explain Extended Command.mp4 (5.6 MB)
MP4
19 Summary in Sixty Seconds.mp4 (931.04 KB)
MP4
01 Introduction.mp4 (2.28 MB)
MP4
02 Demo - Index Used for SELECT clause.mp4 (30.28 MB)
MP4
03 Demo - One Complex Query vs Multiple Simple Queries.mp4 (14.2 MB)
MP4
04 Demo - One Complex Query vs Multiple Simple Queries - Part 2.mp4 (14.92 MB)
MP4
05 Demo - One Complex Query vs Multiple Simple Queries with Index.mp4 (20.73 MB)
MP4
06 Demo - Table Order in Join Clause - INNER JOIN.mp4 (23.52 MB)
MP4
07 Demo - Table Order in Join Clause - OUTER JOIN.mp4 (13.22 MB)
MP4
08 Demo - Most Optimal Choice - Subquery vs Exists vs Joins.mp4 (34.43 MB)
MP4
09 Demo - Most Optimal Choice - Subquery vs Exists vs Joins - Part 2.mp4 (13.79 MB)
MP4
10 Demo - Tuning Aggregate Function.mp4 (16.65 MB)
MP4
11 Demo - Optimizing Group By Clause.mp4 (21.86 MB)
MP4
12 Demo - Optimizing Paging with LIMIT Clause.mp4 (9.38 MB)
MP4
13 Demo - Impact on Performance of UNION and UNION ALL.mp4 (13.07 MB)
MP4
14 Demo - Index and Not Equal to Operator.mp4 (7.49 MB)
MP4
15 Summary in Sixty Seconds.mp4 (1.21 MB)
MP4
1 Best Practices.mp4 (6.85 MB)
MP4
1 Version Check.mp4 (356.41 KB)
MP4
2 Introduction.mp4 (9.48 MB)
MP4
01 Introduction.mp4 (1.17 MB)
MP4
02 Prerequisite Software.mp4 (1.59 MB)
MP4
03 Prerequisite Software for This Course.mp4 (1.58 MB)
MP4
04 Demo Setup.mp4 (595.4 KB)
MP4
05 Demo - Installing Apache Server.mp4 (2.89 MB)
MP4
06 Demo - Installing PHP Server.mp4 (2.23 MB)
MP4
07 Demo - Installing MySQL Server.mp4 (5.01 MB)
MP4
08 Demo - Installing phpMyAdmin.mp4 (6.2 MB)
MP4
09 Demo - Getting Started With phpMyAdmin.mp4 (5.71 MB)
MP4
10 Demo - Removing Warnings and Error From phpMyAdmin.mp4 (13.96 MB)
MP4
11 Summary.mp4 (1.37 MB)
MP4
01 Introduction.mp4 (1.63 MB)
MP4
02 Scenario Setup.mp4 (3.96 MB)
MP4
03 Scenario 1 - Reports.mp4 (1.67 MB)
MP4
04 Demo 1 - Reports.mp4 (13.3 MB)
MP4
05 Scenario 2 - Variables.mp4 (1.43 MB)
MP4
06 Demo - Variables.mp4 (4.78 MB)
MP4
07 Scenario 3 - Monitor.mp4 (1.95 MB)
MP4
08 Demo 3 - Monitor.mp4 (10.21 MB)
MP4
09 Scenario 4 - Database Operations.mp4 (1.67 MB)
MP4
10 Demo 4 - Database Operations.mp4 (4.44 MB)
MP4
11 Scenario 5 - Create User.mp4 (1.64 MB)
MP4
12 Demo 5 - Create User.mp4 (8.15 MB)
MP4
13 Scenario 6 - Export and Import.mp4 (1.63 MB)
MP4
14 Demo 6 - Export and Import.mp4 (9.76 MB)
MP4
15 Summary.mp4 (1.19 MB)
MP4
01 Introduction.mp4 (1.72 MB)
MP4
02 Scenario Setup.mp4 (3.78 MB)
MP4
03 Scenario 1 - Browse and Edit.mp4 (1.23 MB)
MP4
04 Demo - Delete Rows.mp4 (23.39 MB)
MP4
05 Demo - Edit Rows.mp4 (10.59 MB)
MP4
06 Demo - Profiling Query and Print Table.mp4 (13.03 MB)
MP4
07 Scenario 2 - Data Structure.mp4 (1.57 MB)
MP4
08 Demo - Change Data Structure.mp4 (18.38 MB)
MP4
09 Scenario 3 - Create, Read, Update, and Delete.mp4 (1.22 MB)
MP4
10 Demo - Execute SQL Scripts.mp4 (4.9 MB)
MP4
11 Scenario 4 - Advanced Search.mp4 (1.84 MB)
MP4
12 Demo - Advanced Search and Replace.mp4 (17.41 MB)
MP4
13 Scenario 5 - Table Maintenance.mp4 (1.76 MB)
MP4
14 Demo - Table Maintenance.mp4 (20.79 MB)
MP4
15 Scenario 6 - Table Options.mp4 (1.36 MB)
MP4
16 Demo - Table Options.mp4 (10.01 MB)
MP4
17 Scenario 7 - Export and Import.mp4 (1.3 MB)
MP4
18 Demo - Export Table in Excel Format.mp4 (4.32 MB)
MP4
19 Scenario 8 - Tracking.mp4 (1.97 MB)
MP4
20 Demo - Tracking.mp4 (13.41 MB)
MP4
21 Summary.mp4 (1.28 MB)
MP4
1 Introduction.mp4 (884.88 KB)
MP4
2 Scenario Setup.mp4 (2.5 MB)
MP4
3 Scenario 1 - Home Screen Customization.mp4 (1.23 MB)
MP4
4 Demo - Home Screen Customization - Features.mp4 (13.51 MB)
MP4
5 Demo - Home Screen Customization - Queries.mp4 (5.8 MB)
MP4
6 Demo - Home Screen Customization - Navigation.mp4 (7.57 MB)
MP4
7 Summary.mp4 (869.55 KB)
MP4
1 Summary and Resources.mp4 (4.65 MB)
MP4