Lynda com - Up and Running with phpMyAdmin

1. 0. Introduction/1. Welcome.mp43.65MB
2. 0. Introduction/2. What you need to follow this course.mp42.59MB
3. 0. Introduction/3. Using the exercise files.mp42.63MB
4. 0. Introduction/4. What's new in this version of the course.mp44.24MB
5. 1. What phpMyAdmin Does/1. Why use phpMyAdmin.mp45.14MB
6. 1. What phpMyAdmin Does/2. A quick tour of phpMyAdmin.mp412.29MB
7. 1. What phpMyAdmin Does/3. Limitations of phpMyAdmin in hosted environments.mp48.73MB
8. 2. Setting Up phpMyAdmin Locally/1. Setting the server connection collation.mp48.01MB
9. 2. Setting Up phpMyAdmin Locally/2. Creating a database.mp45.42MB
10. 2. Setting Up phpMyAdmin Locally/3. Setting up a user account.mp410.23MB
11. 2. Setting Up phpMyAdmin Locally/4. Enabling advanced features on Windows.mp413.66MB
12. 2. Setting Up phpMyAdmin Locally/5. Enabling advanced features on MAMP for OS X.mp415.42MB
13. 3. Creating Tables/1. Choosing the right column types.mp48.48MB
14. 3. Creating Tables/2. Collation, character sets, and storage.mp48.97MB
15. 3. Creating Tables/3. Defining a table.mp412.04MB
16. 3. Creating Tables/4. Amending the table structure.mp49.38MB
17. 3. Creating Tables/5. Inserting data manually.mp47.24MB
18. 3. Creating Tables/6. Using the Browse tab.mp412.18MB
19. 3. Creating Tables/7. Copying a column definition to another table with central columns.mp411.34MB
20. 4. Importing and Exporting Data/1. Importing data from Excel or a CSV file.mp411.97MB
21. 4. Importing and Exporting Data/2. Importing data from an OpenDocument Spreadsheet.mp412.2MB
22. 4. Importing and Exporting Data/3. Importing data from a SQL dump file.mp48.51MB
23. 4. Importing and Exporting Data/4. Exporting a database the quick way.mp46.77MB
24. 4. Importing and Exporting Data/5. Exporting multiple databases.mp49.42MB
25. 4. Importing and Exporting Data/6. Creating a custom export for a single database.mp413.92MB
26. 4. Importing and Exporting Data/7. Exporting partial data.mp49.35MB
27. 4. Importing and Exporting Data/8. Enhanced export features in phpMyAdmin 4.5.mp48.91MB
28. 5. Dealing with Foreign Keys/1. Understanding foreign key constraints.mp46.28MB
29. 5. Dealing with Foreign Keys/2. Converting the table engine.mp44.52MB
30. 5. Dealing with Foreign Keys/3. Setting up a foreign key constraint.mp411.97MB
31. 5. Dealing with Foreign Keys/4. Removing a foreign key constraint.mp45.55MB
32. 6. Running Queries/1. Performing a simple search.mp413.04MB
33. 6. Running Queries/10. Using variables with bookmarks in phpMyAdmin 4.5.mp411.66MB
34. 6. Running Queries/11. Using named parameters in a query.mp47.6MB
35. 6. Running Queries/12. Running queries from the console.mp411.8MB
36. 6. Running Queries/13. New Console options in phpMyAdmin 4.5.mp43.65MB
37. 6. Running Queries/2. Using query by example (QBE) to perform a simple search.mp49.66MB
38. 6. Running Queries/3. Finding and replacing text in a column.mp45.78MB
39. 6. Running Queries/4. Using QBE to set multiple conditions in a WHERE clause.mp411.58MB
40. 6. Running Queries/5. Joining multiple tables with QBE.mp47.69MB
41. 6. Running Queries/6. Building queries manually on a single table.mp410.65MB
42. 6. Running Queries/7. Building a query manually on multiple tables.mp46.43MB
43. 6. Running Queries/8. Saving frequently used queries with bookmarks.mp411.66MB
44. 6. Running Queries/9. Using a variable with a bookmarked query.mp48.67MB
45. 7. Views and Stored Programs/1. Syntax checker in phpMyAmin 4.5.mp41.22MB
46. 7. Views and Stored Programs/2. Creating a view.mp410.98MB
47. 7. Views and Stored Programs/3. Editing a view.mp44.58MB
48. 7. Views and Stored Programs/4. Creating a stored procedure.mp411.62MB
49. 7. Views and Stored Programs/5. Creating a stored function.mp412.56MB
50. 7. Views and Stored Programs/6. Creating a trigger.mp412.3MB
51. 7. Views and Stored Programs/7. Scheduling events.mp411.19MB
52. 8. Checking Performance/1. Profiling and explaining queries.mp410.19MB
53. 8. Checking Performance/2. Analyzing table structure.mp47.42MB
54. 8. Checking Performance/3. Normalizing a table.mp414.74MB
55. 8. Checking Performance/4. Inspecting server performance.mp48.49MB
56. 8. Checking Performance/5. Using Advisor to tune performance.mp45.92MB
57. 9. Conclusion/1. Other changes in phpMyAdmin 4.5.mp48.7MB
58. 9. Conclusion/2. Where next.mp43.3MB