Lynda com Up and Running with phpMyAdmin | EB35C7AF5861B5CF866E3556C817DC456BBCAECB

Lynda com Up and Running with phpMyAdmin

Name	Lynda.com - Up and Running with phpMyAdmin	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	539.1 MB
Total Files	60
Hash	EB35C7AF5861B5CF866E3556C817DC456BBCAECB

/0. Introduction/
1. Welcome.mp4	3.8 MB
2. What you need to follow this course.mp4	2.7 MB
3. Using the exercise files.mp4	2.8 MB
4. What's new in this version of the course.mp4	4.4 MB
/1. What phpMyAdmin Does/
1. Why use phpMyAdmin.mp4	5.4 MB
2. A quick tour of phpMyAdmin.mp4	12.9 MB
3. Limitations of phpMyAdmin in hosted environments.mp4	9.2 MB
/2. Setting Up phpMyAdmin Locally/
1. Setting the server connection collation.mp4	8.4 MB
2. Creating a database.mp4	5.7 MB
3. Setting up a user account.mp4	10.7 MB
4. Enabling advanced features on Windows.mp4	14.3 MB
5. Enabling advanced features on MAMP for OS X.mp4	16.2 MB
/3. Creating Tables/
1. Choosing the right column types.mp4	8.9 MB
2. Collation, character sets, and storage.mp4	9.4 MB
3. Defining a table.mp4	12.6 MB
4. Amending the table structure.mp4	9.8 MB
5. Inserting data manually.mp4	7.6 MB
6. Using the Browse tab.mp4	12.8 MB
7. Copying a column definition to another table with central columns.mp4	11.9 MB
/4. Importing and Exporting Data/
1. Importing data from Excel or a CSV file.mp4	12.6 MB
2. Importing data from an OpenDocument Spreadsheet.mp4	12.8 MB
3. Importing data from a SQL dump file.mp4	8.9 MB
4. Exporting a database the quick way.mp4	7.1 MB
5. Exporting multiple databases.mp4	9.9 MB
6. Creating a custom export for a single database.mp4	14.6 MB
7. Exporting partial data.mp4	9.8 MB
8. Enhanced export features in phpMyAdmin 4.5.mp4	9.3 MB
/5. Dealing with Foreign Keys/
1. Understanding foreign key constraints.mp4	6.6 MB
2. Converting the table engine.mp4	4.7 MB
3. Setting up a foreign key constraint.mp4	12.6 MB
4. Removing a foreign key constraint.mp4	5.8 MB
/6. Running Queries/
1. Performing a simple search.mp4	13.7 MB
10. Using variables with bookmarks in phpMyAdmin 4.5.mp4	12.2 MB
11. Using named parameters in a query.mp4	8.0 MB
12. Running queries from the console.mp4	12.4 MB
13. New Console options in phpMyAdmin 4.5.mp4	3.8 MB
2. Using query by example (QBE) to perform a simple search.mp4	10.1 MB
3. Finding and replacing text in a column.mp4	6.1 MB
4. Using QBE to set multiple conditions in a WHERE clause.mp4	12.1 MB
5. Joining multiple tables with QBE.mp4	8.1 MB
6. Building queries manually on a single table.mp4	11.2 MB
7. Building a query manually on multiple tables.mp4	6.7 MB
8. Saving frequently used queries with bookmarks.mp4	12.2 MB
9. Using a variable with a bookmarked query.mp4	9.1 MB
/7. Views and Stored Programs/
1. Syntax checker in phpMyAmin 4.5.mp4	1.3 MB
2. Creating a view.mp4	11.5 MB
3. Editing a view.mp4	4.8 MB
4. Creating a stored procedure.mp4	12.2 MB
5. Creating a stored function.mp4	13.2 MB
6. Creating a trigger.mp4	12.9 MB
7. Scheduling events.mp4	11.7 MB
/8. Checking Performance/
1. Profiling and explaining queries.mp4	10.7 MB
2. Analyzing table structure.mp4	7.8 MB
3. Normalizing a table.mp4	15.5 MB
4. Inspecting server performance.mp4	8.9 MB
5. Using Advisor to tune performance.mp4	6.2 MB
/9. Conclusion/
1. Other changes in phpMyAdmin 4.5.mp4	9.1 MB
2. Where next.mp4	3.5 MB
/
Ex_Files_UaR_phpMyAdmin.zip	41.5 KB
Info.txt	1.2 KB
Total files 60