Lynda Learning phpMyAdmin | 84CBA4AE4E649D023239F6A4FFE5C32007AAA678

Lynda Learning phpMyAdmin

Name	Lynda - Learning phpMyAdmin	DOWNLOAD Copy Link
Total Size	749.3 MB
Total Files	57
Hash	84CBA4AE4E649D023239F6A4FFE5C32007AAA678

/0 - Introduction/
E3 - What's new in this version of the course.mp4	7.4 MB
E2 - Using the exercise files.mp4	3.5 MB
E1 - What you need to follow this course.mp4	3.0 MB
/1 - 1. What phpMyAdmin Does/
E5 - A quick tour of phpMyAdmin.mp4	18.0 MB
E6 - Limitations of phpMyAdmin in hosted environments.mp4	12.1 MB
E4 - Why use phpMyAdmin-.mp4	6.0 MB
/2 - 2. Setting Up phpMyAdmin Locally/
E11 - Enabling advanced features on MAMP for OS X.mp4	24.1 MB
E10 - Enabling advanced features on Windows.mp4	20.7 MB
E9 - Setting up a user account.mp4	14.0 MB
E7 - Setting the server connection collation.mp4	11.0 MB
E8 - Creating a database.mp4	7.4 MB
/3 - 3. Creating Tables/
E17 - Using the Browse tab.mp4	18.5 MB
E14 - Defining a table.mp4	17.2 MB
E18 - Copying a column definition to another table with central columns.mp4	16.0 MB
E15 - Amending the table structure.mp4	13.6 MB
E13 - Collation, character sets, and storage.mp4	10.9 MB
E12 - Choosing the right column types.mp4	10.4 MB
E16 - Inserting data manually.mp4	9.5 MB
/4 - 4. Importing and Exporting Data/
E24 - Creating a custom export for a single database.mp4	19.4 MB
E20 - Importing data from an OpenDocument Spreadsheet.mp4	18.0 MB
E19 - Importing data from Excel or a CSV file.mp4	16.5 MB
E26 - Enhanced export features in phpMyAdmin 4.5.mp4	15.7 MB
E25 - Exporting partial data.mp4	13.6 MB
E23 - Exporting multiple databases.mp4	13.3 MB
E21 - Importing data from a SQL dump file.mp4	13.1 MB
E22 - Exporting a database the quick way.mp4	9.7 MB
/5 - 5. Dealing with Foreign Keys/
E29 - Setting up a foreign key constraint.mp4	17.1 MB
E30 - Removing a foreign key constraint.mp4	7.8 MB
E27 - Understanding foreign key constraints.mp4	7.6 MB
E28 - Converting the table engine.mp4	6.5 MB
/6 - 6. Running Queries/
E40 - Using variables with bookmarks in phpMyAdmin 4.5.mp4	21.7 MB
E42 - Running queries from the console.mp4	19.7 MB
E31 - Performing a simple search.mp4	18.1 MB
E34 - Using QBE to set multiple conditions in a WHERE clause.mp4	17.8 MB
E38 - Saving frequently used queries with bookmarks.mp4	16.7 MB
E36 - Building queries manually on a single table.mp4	15.3 MB
E32 - Using query by example (QBE) to perform a simple search.mp4	14.1 MB
E41 - Using named parameters in a query.mp4	13.8 MB
E39 - Using a variable with a bookmarked query.mp4	12.5 MB
E35 - Joining multiple tables with QBE.mp4	11.0 MB
E37 - Building a query manually on multiple tables.mp4	9.2 MB
E33 - Finding and replacing text in a column.mp4	8.7 MB
E43 - New Console options in phpMyAdmin 4.5.mp4	6.5 MB
/7 - 7. Views and Stored Programs/
E48 - Creating a stored function.mp4	18.1 MB
E49 - Creating a trigger.mp4	17.4 MB
E47 - Creating a stored procedure.mp4	17.1 MB
E45 - Creating a view.mp4	15.7 MB
E50 - Scheduling events.mp4	15.3 MB
E46 - Editing a view.mp4	6.6 MB
E44 - Syntax checker in phpMyAmin 4.5.mp4	2.2 MB
/8 - 8. Checking Performance/
E53 - Normalizing a table.mp4	20.1 MB
E51 - Profiling and explaining queries.mp4	15.3 MB
E54 - Inspecting server performance.mp4	11.9 MB
E52 - Analyzing table structure.mp4	11.6 MB
E55 - Using Advisor to tune performance.mp4	9.9 MB
/9 - Conclusion/
E56 - Other changes in phpMyAdmin 4.5.mp4	15.6 MB
E57 - Where next.mp4	6.1 MB
Total files 57