LYNDA UP AND RUNNING WITH PHPMYADMIN TUTORIAL

1. 01. Introduction/01_01-Welcome.mp47.38MB
2. 01. Introduction/01_04-Whats new in this version of the course.mp44.44MB
3. 01. Introduction/01_03-Using the exercise files.mp43.33MB
4. 01. Introduction/01_02-What you need to follow this course.mp42.88MB
5. 02. What phpMyAdmin Does/02_02-A quick tour of phpMyAdmin.mp417.27MB
6. 02. What phpMyAdmin Does/02_03-Limitations of phpMyAdmin in hosted environments.mp411.6MB
7. 02. What phpMyAdmin Does/02_01-Why use phpMyAdmin.mp45.82MB
8. 03. Setting Up phpMyAdmin Locally/03_05-Enabling advanced features on MAMP for OS X.mp423.04MB
9. 03. Setting Up phpMyAdmin Locally/03_04-Enabling advanced features on Windows.mp419.88MB
10. 03. Setting Up phpMyAdmin Locally/03_03-Setting up a user account.mp413.41MB
11. 03. Setting Up phpMyAdmin Locally/03_01-Setting the server connection collation.mp410.55MB
12. 03. Setting Up phpMyAdmin Locally/03_02-Creating a database.mp47.12MB
13. 04. Creating Tables/04_06-Using the Browse tab.mp417.77MB
14. 04. Creating Tables/04_03-Defining a table.mp416.47MB
15. 04. Creating Tables/04_07-Copying a column definition to another table with central columns.mp415.35MB
16. 04. Creating Tables/04_04-Amending the table structure.mp413MB
17. 04. Creating Tables/04_02-Collation, character sets, and storage.mp410.4MB
18. 04. Creating Tables/04_01-Choosing the right column types.mp49.99MB
19. 04. Creating Tables/04_05-Inserting data manually.mp49.08MB
20. 05. Importing and Exporting Data/05_06-Creating a custom export for a single database.mp418.56MB
21. 05. Importing and Exporting Data/05_02-Importing data from an OpenDocument Spreadsheet.mp417.1MB
22. 05. Importing and Exporting Data/05_01-Importing data from Excel or a CSV file.mp415.82MB
23. 05. Importing and Exporting Data/05_07-Exporting partial data.mp413.04MB
24. 05. Importing and Exporting Data/05_05-Exporting multiple databases.mp412.69MB
25. 05. Importing and Exporting Data/05_03-Importing data from a SQL dump file.mp412.6MB
26. 05. Importing and Exporting Data/05_04-Exporting a database the quick way.mp49.29MB
27. 06. Dealing with Foreign Keys/06_03-Setting up a foreign key constraint.mp416.44MB
28. 06. Dealing with Foreign Keys/06_04-Removing a foreign key constraint.mp47.47MB
29. 06. Dealing with Foreign Keys/06_01-Understanding foreign key constraints.mp47.4MB
30. 06. Dealing with Foreign Keys/06_02-Converting the table engine.mp46.22MB
31. 07. Running Queries/07_10-Running queries from the console.mp418.76MB
32. 07. Running Queries/07_01-Performing a simple search.mp417.34MB
33. 07. Running Queries/07_04-Using QBE to set multiple conditions in a WHERE clause.mp416.83MB
34. 07. Running Queries/07_08-Saving frequently used queries with bookmarks.mp416MB
35. 07. Running Queries/07_06-Building queries manually on a single table.mp414.61MB
36. 07. Running Queries/07_02-Using query by example QBE to perform a simple search.mp413.47MB
37. 07. Running Queries/07_09-Using a variable with a bookmarked query.mp411.87MB
38. 07. Running Queries/07_05-Joining multiple tables with QBE.mp410.52MB
39. 07. Running Queries/07_07-Building a query manually on multiple tables.mp48.85MB
40. 07. Running Queries/07_03-Finding and replacing text in a column.mp48.25MB
41. 08. Views and Stored Programs/08_04-Creating a stored function.mp417.33MB
42. 08. Views and Stored Programs/08_05-Creating a trigger.mp416.69MB
43. 08. Views and Stored Programs/08_03-Creating a stored procedure.mp416.42MB
44. 08. Views and Stored Programs/08_01-Creating a view.mp414.98MB
45. 08. Views and Stored Programs/08_06-Scheduling events.mp414.59MB
46. 08. Views and Stored Programs/08_02-Editing a view.mp46.34MB
47. 09. Checking Performance/09_03-Normalizing a table.mp419.25MB
48. 09. Checking Performance/09_01-Profiling and explaining queries.mp414.65MB
49. 09. Checking Performance/09_04-Inspecting server performance.mp411.44MB
50. 09. Checking Performance/09_02-Analyzing table structure.mp411.07MB
51. 09. Checking Performance/09_05-Using Advisor to tune performance.mp49.43MB
52. 10. Conclusion/10_01-Where next.mp45.81MB